SQL - IF a value equals a certain number then the amount of rows should equal that certain number
===

Scenario: I have 1 columns in my select statement; Name which I want to repeat based on the value of a column named Number. Example Jim W has a Number value of 6 so I want the SQL statement to return 6 rows with the Name of Jim W.

Name <br>
JIM W <br>
JIM W<br>
JIM W<br>
JIM W<br>
JIM W<br>
JIM W<br>

Other points to note is that it should group by a column named region and its SQL Server 2008. 

Is this possible?

Thanks

