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-05-16 : 08:17:21
|
| Ramesh writes "I have want output in following foramt .<rd:FocusReferenceData xmlns:rd="http://provfin.com/schemas/ReferenceDataUpdate" rd:name="Text"> <rd:Row> <rd:OrderNo>1</rd:OrderNo> <rd:ReturnRef>UT</rd:ReturnRef> <rd:Text>UTR</rd:Text> </rd:Row> <rd:Row> <rd:OrderNo>2</rd:OrderNo> <rd:ReturnRef>ST</rd:ReturnRef> <rd:Text>TEST</rd:Text> </rd:Row></rd:FocusReferenceData>the Query is Below CREATE TABLE #Reason_For_Miss_Table1(OrderNo int IDENTITY, ReturnRef varchar(10),[Text] varchar(50)) CREATE TABLE #Reason_For_Miss_Table2(TAG iNT, Parent int , tag1 varchar(100), tag2 varchar(1000), tag3 varchar(100), orderno varchar(1000),ReturnRef varchar(10),[Text] varchar(50)) INSERT INTO #Reason_For_Miss_Table1 (ReturnRef,[Text]) SELECT [NP].Non_Payment_Code,[NPD].Description FROM Non_Payment [NP], Non_Payment_Desc [NPD] WHERE [NP].Non_Payment_Code = [NPD].Non_Payment_Code AND [NP].Active_Bln = 1 ORDER BY [NP].Sequence_NumINSERT INTO #Reason_For_Miss_Table2(TAG ,parent,tag1,tag2,tag3,orderno,ReturnRef ,[Text] ) SELECT 1 as tag, Null as parent, Null AS [rd:FocusReferenceData!1], 'http://provfin.com/schemas/ReferenceDataUpdate' AS [rd:FocusReferenceData!1!xmlns:rd], 'Text' AS [rd:FocusReferenceData!1!rd:name], OrderNo AS [rd:Row!2!rd:OrderNo!element], ReturnRef AS [rd:Row!2!rd:ReturnRef!element], [Text] AS [rd:Row!2!rd:Text!element] FROM #Reason_For_Miss_Table1 Can u pls help me in getting the required OutPut Xml format " |
|
|
|
|
|
|
|
XMl Explicit mode