Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Multiple copy of a single Row

Author  Topic 

Amjath
Yak Posting Veteran

66 Posts

Posted - 2007-08-15 : 22:50:27
Hi All,

Dont mistake me for asking such a small question, im little bit confused.

Result of my query gives 1 rows.
i want some hundred copy of that single row, how can i do that.

Right now i put a while loop and i get the things done, but i know its a wrong way. plz guide me

With Regards
Amjath

PS:if anybody having good tutorial for sql pls pass it to me

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-08-15 : 23:02:53
cross join to a tally table or use F_TABLE_NUMBER_RANGE from http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685&SearchTerms=F_TABLE_NUMBER_RANGE


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-16 : 01:33:53
quote:
Originally posted by Amjath

Hi All,

Dont mistake me for asking such a small question, im little bit confused.

Result of my query gives 1 rows.
i want some hundred copy of that single row, how can i do that.

Right now i put a while loop and i get the things done, but i know its a wrong way. plz guide me

With Regards
Amjath

PS:if anybody having good tutorial for sql pls pass it to me


Why do you need multiple copies of same row?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -