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 - 2006-04-10 : 09:34:15
|
| lalitha writes "I have two tables named connectionString and parameter which has parent and child relationship.I needed the ouptput as follows:<connectionStrings> <connectionString name="Connection String"> <parameters> <parameter name="database" value="modle" isSensitive="false" /> <parameter name="Integrated Security" value="True" isSensitive="false" /> <parameter name="server" value="Y34255" isSensitive="false" /> </parameters> </connectionString>Please help me to do this" |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-04-10 : 09:56:05
|
| Have you read the section on EXPLICIT mode in Books Online, and have you tried constructing a Universal Table for your data?FYI, this is MUCH easier to do in SQLSVR 2005, though I imagine that is not an option for you... |
 |
|
|
|
|
|
For XML Explicit