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 |
|
pizzazzz
Yak Posting Veteran
55 Posts |
 Posted - 2011-03-18 : 16:13:00
|
| Hello:Someone has created a lot of sql queries (loong) and I'd like/need to combine the datasets into one dataset. I'll add a column to id each type of query. each query has the exact number of columns.not sure how to tackle this one... should i create a stored procedure and call each sql query? should I embed each into a case statment (can this actually be done?)any suggestions would be helpful... I do not want to rewrite these too long.thanks, pizzazzz |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2011-03-18 : 16:32:38
|
| How about using UNION?Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
pizzazzz
Yak Posting Veteran
55 Posts |
Posted - 2011-03-18 : 16:40:36
|
| Thanks Skorch! that worked and will work for thsis project... |
|
|
|
|
|
|
Need to combine the output of several long queries