Repeat Rows N Times According to Column Value

by

You can use a simple JOIN to get the desired result as below:

SELECT  t1.*, t2.number + 1 RepeatNumber
FROM    TableA t1
JOIN    master.dbo.spt_values t2 ON t2.type="P" AND t2.number < t1.Quantity

The above query repeats each record by the specified number in Quantity column.

Note for master.dbo.spt_values on type="P":

This table is used for getting a series of number which is hard-coded in it by
condition of type="P".

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Is it possible to write single query on two table which are not connected to each other?
  3. CROSS JOIN vs INNER JOIN in SQL
  4. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  5. Split function equivalent in T-SQL?
  6. Is the NOLOCK (Sql Server hint) bad practice?
  7. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  8. Where value in column containing comma delimited values
  9. Parse comma-separated string to make IN List of strings in the Where clause
  10. SQL query to split column data into rows
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  14. Compare DATETIME and DATE ignoring time portion
  15. Split function in SQL Server 2008
  16. Procedure or function !!! has too many arguments specified
  17. SQL “between” not inclusive
  18. How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table
  19. Can I set ignore_dup_key on for a primary key?
  20. Using PIVOT in SQL Server 2008
  21. How do I prevent a database trigger from recursing?
  22. How can I group by date time column without taking time into consideration
  23. How to combine results of two queries into a single dataset
  24. When using GETDATE() in many places, is it better to use a variable?
  25. Executing SQL Server Agent Job from a stored procedure and returning job result
  26. SQL take just the numeric values from a varchar
  27. Cumulative Total in MS Sql server [duplicate]
  28. SQL Server SELECT INTO @variable?
  29. SQL Server equivalent of WM_CONCAT function [duplicate]
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment