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.
| Author |
Topic |
|
Teachme
Starting Member
45 Posts |
 Posted - 2006-10-18 : 12:20:57
|
| Is there a way to repeat selected records in a query more than once.for instance if i have a query such as this select col1 from tbl1..and it returns one record of value lets say 10 but i want it to repeat 10 times. In other words i get 10 records of value 10. thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-18 : 12:23:38
|
| Why?If col1 returns 1000000000 you want to repeat as many times?MadhivananFailing to plan is Planning to fail |
 |
|
|
Teachme
Starting Member
45 Posts |
Posted - 2006-10-18 : 12:26:34
|
| no not as many times..i just have a scenario where i wana repeat some records like 13 times..same values.. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-18 : 14:39:10
|
zomg, the PERFECT time to chime in with "DO IT IN THE FRONT END" [Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-21 : 08:30:46
|
quote:
Originally posted by DonAtWork
zomg, the PERFECT time to chime in with "DO IT IN THE FRONT END"[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp
 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Repeat selected records