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 |
|
PRIYA.CYNTHIA
Starting Member
3 Posts |
 Posted - 2010-03-09 : 10:24:05
|
| I have a requirement to display the each record in a table 10 times. Can this be achieved using a sql query? |
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-03-09 : 10:27:37
|
quote:
Originally posted by PRIYA.CYNTHIA
I have a requirement to display the each record in a table 10 times. Can this be achieved using a sql query?
Show us the sample data with the output expected please?..Could i ask,you dou want to do that? |
 |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2010-03-09 : 10:30:46
|
| hint: cross join |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-10 : 01:52:29
|
quote:
Originally posted by PRIYA.CYNTHIA
I have a requirement to display the each record in a table 10 times. Can this be achieved using a sql query?
Why do you need this?If you use front end application to show data, do this replication thereMadhivananFailing to plan is Planning to fail |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2010-03-10 : 01:58:03
|
| select * from <Table_name>GO 10Karthikhttp://karthik4identity.blogspot.com/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-10 : 02:02:47
|
quote:
Originally posted by karthik_padbanaban
select * from <Table_name>GO 10Karthikhttp://karthik4identity.blogspot.com/
Provided SQL Server version is 2005 or moreMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
sql query for redundant display