skal have følgende ned i en xml variabel men kan simpelthen ikke få det til at lykkes.
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')
det der resultere jo i et xml output, hvordan får jeg det i en variabel???
hvis det kan være nogen hjælp for nogen så er det en stored procedure som jeg gerne vil output variablen sat på.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Mathias> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= 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')
return 1
END
så jeg vil altså gerne have at xmldata sættes til det der returneres af af et af de select statements!
hvis der er nogle der kan hjælpe villle jeg blive meget glad
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.