Jeg vil tro du skal lave en output variabel i din sp for at kunne gemme det i en variabel. Evt kan du lave den om til en funktion, der returnerer dit xml.
Kan du fortælle mig hvordan jeg får hele xml dokumentet ned i min outpt variabel? kan simpelthen ikke få det til at virke.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO
ALTER PROCEDURE [dbo].[GetDispositionsAsXML] @country varchar(4), @xmldata xml output AS
if (@country='DK') BEGIN select Disposition_1.name_DK as Disposition, Disposition_2.name_dk as name from DeviationPropertyGlobal Disposition_1 left join DeviationPropertyRelation DPR on Disposition_1.id = DPR.parentid inner join DeviationPropertyType DPT on DPT.id = Disposition_1.Typeid AND DPT.uniquename = 'Disposition_1' left join DeviationPropertyGlobal Disposition_2 on DPR.childid = Disposition_2.id for xml auto, root('root')
return 1
END
if (@country='EN') BEGIN select
Disposition_1.name_en as Disposition, Disposition_2.name_en as name from DeviationPropertyGlobal Disposition_1 left join DeviationPropertyRelation DPR on Disposition_1.id = DPR.parentid inner join DeviationPropertyType DPT on DPT.id = Disposition_1.Typeid AND DPT.uniquename = 'Disposition_1' left join DeviationPropertyGlobal Disposition_2 on DPR.childid = Disposition_2.id for xml auto, root('root')
return 1
END
if (@country='SE') BEGIN select
Disposition_1.name_se as Disposition, Disposition_2.name_se as name from DeviationPropertyGlobal Disposition_1 left join DeviationPropertyRelation DPR on Disposition_1.id = DPR.parentid inner join DeviationPropertyType DPT on DPT.id = Disposition_1.Typeid AND DPT.uniquename = 'Disposition_1' left join DeviationPropertyGlobal Disposition_2 on DPR.childid = Disposition_2.id for xml auto, root('root')
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.