Create stored Procedure to get xml data fields

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

engintoksoz SSC Veteran Points: 264 More actions · Answer 1

something like this?

SELECT cast('<root>' + cast(xmlcol1 as nvarchar(max)) + cast(xmlcol2 as nvarchar(max))+'</root>' as xml) FROM yourtable

anupamabr SSC Eights! Points: 930 More actions · Answer 2

Hi

I dont knw what exactly you mean..I am new to stored procedure and xml data field..So Please provide some eg with code

lklein Ten Centuries Points: 1234 More actions · Answer 3

Passing Multiple Parameters to a Stored Procedure

1.Define your parameter in your stored procedure as xml

IE: @DEPART XML

The parameter now acts and behaves like a table

IE: INNER JOIN @DEPART.nodes('/DEPART/LOCATION_DESC') as m(item)

on cast(TL.TK_LOCATIONS_UID as VARCHAR(10))

= m.item.value('TK_LOCATIONS_UID[1]','VARCHAR(10)')

2.Dataset Alter Parameter section:

=Code.ReturnXML(Parameters!DEPART.Value,"DEPART","LOCATION_DESC","TK_LOCATIONS_UID")

3.In the Report Properties Code section:

Function ReturnXML(ByVal MultiValueList As Object, ByVal DEPART As String, ByVal LOCATION_DESC As String, ByVal TK_LOCATIONS_UID As String) As String

Dim ReturnString = ""

Dim sParamItem As Object

ReturnString = " "

For Each sParamItem In MultiValueList

ReturnString &= " "

Return (ReturnString)

End Function

Note in this example: Parameter = Depart Value= TK_LOCATIONS_UID Label=LOCATION_DESC

anupamabr SSC Eights! Points: 930 More actions · Answer 4

SSC Eights!

Points: 930

December 9, 2008 at 12:42 pm

Thanks alot!!I will try and let you know