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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-05 : 08:48:12
|
| kalpak writes "I have one asp page which basically fire three queryies so using three recordset for each now if i want to merge all three in to one recordset than whether it is possible ??if yes than how ??" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-05 : 09:04:12
|
| ADO has a really cool command called SHAPE. It allows you to perform this kind of thing using only one recordset. It's very similar to an XML structure, where hierarchical data can be stored and manipulated. In fact, using the ADO Save method you can ouput this into XML fairly easily.www.4guysfromrolla.com and www.asp101.com each have several really good articles on the SHAPE command, if you search their sites for it.If you're using SQL Server 2000, there is also XML functionality built into it. It's up to you if you want to use it, but if you do, Books Online has all the details. |
 |
|
|
|
|
|
About merging different record set