Advertisement

04.23.2008 at 09:57PM PDT, ID: 23349230
[x]
Attachment Details

Concatenate XML in Sql Server 2005

Asked by RkVerma in SQL Server 2005, Visual Studio .NET 2005

Tags: Microsoft, Sql Server, 2005

Hi Everybody,

I have to generate a huge xml report in Sql Server 2005 Stored procedure. I can not take varchar because of maximum length limit. So decided to take XML Variable but unfortunately we can not concatenate XML variables. So if anybody knows that how to concatenate please let me know.
Right Now I am using temptable in which there is one xml column so I am updating that xml column in the loop in stored procedure but that is taking very long time coz it updates every node to the temp table.
so please help me on this.

RKStart Free Trial
[+][-]04.23.2008 at 11:25PM PDT, ID: 21428127

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.27.2008 at 01:07AM PDT, ID: 21448485

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.27.2008 at 05:30AM PDT, ID: 21448947

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.28.2008 at 04:01PM PDT, ID: 21458375

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 02:19AM PDT, ID: 21460643

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 02:21AM PDT, ID: 21460649

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 04:12AM PDT, ID: 21461108

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 04:14AM PDT, ID: 21461120

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.29.2008 at 04:51PM PDT, ID: 21467176

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]04.30.2008 at 01:19AM PDT, ID: 21468895

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Visual Studio .NET 2005
Tags: Microsoft, Sql Server, 2005
Sign Up Now!
Solution Provided By: angelIII
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628