apply xsl on xml to generate sql
-
Hi All, I have this XML files here: CCCRM Adrian 2008-09-15 2008-09-15 2008-09-21 2008-09-15 14:10:00 15:44:00 16:44:00 22:50:00 And I applied this XSL: Declare @TimeCardID int set @TimeCardID = exec spCreateTimeCard ' ', ' ' exec spCreateTimeCardSession @TimeCardID, ' ', ' ' It generate this sql statement: Declare @TimeCardID int set @TimeCardID = exec spCreateTimeCard '2008-09-15', 'Adrian' exec spCreateTimeCardSession @TimeCardID, ' 14:10:00', '15:44:00' exec spCreateTimeCardSession @TimeCardID, '16:44:00', '22:50:00' but this is not what i want, is there a way that i can generate this statement like this: Declare @TimeCardID int set @TimeCardID = exec spCreateTimeCard '2008-09-15', 'Adrian' exec spCreateTimeCardSession @TimeCardID, '14:10:00', '15:44:00' exec spCreateTimeCardSession @TimeCardID, '16:44:00', '22:50:00' Thanks in advance
-
Hi All, I have this XML files here: CCCRM Adrian 2008-09-15 2008-09-15 2008-09-21 2008-09-15 14:10:00 15:44:00 16:44:00 22:50:00 And I applied this XSL: Declare @TimeCardID int set @TimeCardID = exec spCreateTimeCard ' ', ' ' exec spCreateTimeCardSession @TimeCardID, ' ', ' ' It generate this sql statement: Declare @TimeCardID int set @TimeCardID = exec spCreateTimeCard '2008-09-15', 'Adrian' exec spCreateTimeCardSession @TimeCardID, ' 14:10:00', '15:44:00' exec spCreateTimeCardSession @TimeCardID, '16:44:00', '22:50:00' but this is not what i want, is there a way that i can generate this statement like this: Declare @TimeCardID int set @TimeCardID = exec spCreateTimeCard '2008-09-15', 'Adrian' exec spCreateTimeCardSession @TimeCardID, '14:10:00', '15:44:00' exec spCreateTimeCardSession @TimeCardID, '16:44:00', '22:50:00' Thanks in advance