Generate Defined number of rows dynamically (SET based approach)
In this article , we will generate as much number of rows as needed for each row of given table dynamically. We have a table named #Employee with two columns “EmpName” and “RowsToGenerate”. Lets explore “Generate rows dynamically” topic in with examples and demos. Generate Rows dynamically as per given count: Below is the structure of the table #Employee […]
Generate Defined number of rows dynamically (SET based approach) Read More »