Phil Parkin (1/5/2014)

---

Sowbhari (1/3/2014)

---

If you can change the stored procedure to output as a concatenated string of the required columns data delimited with "," for the respective customer then you...

If you can change the stored procedure to output as a concatenated string of the required columns data delimited with "," for the respective customer then you can write to...

What happens if you change the SQL to include the database name as well?

INSERT INTO DatabaseName.SchemaName.TableName

Please do not cross post. Original thread can be accessed here

http://www.sqlservercentral.com/Forums/Topic1524645-3077-1.aspx

This is the correct SQL,somehow...

This might help

DECLARE @StartTime VARCHAR(MAX),@X XML

SELECT @StartTime = '7:00 AM

12:30 PM'

SELECT @X = CONVERT(XML,'' + replace(@StartTime,'','</br>') + '</br>')

SELECT x.i.value('.','varchar(max)') AS [StartTime]

FROM @X.nodes('//br') x(i)

Try this...

SELECT * FROM @myTable

WHERE

(CONVERT(XML,LOWER(CONVERT(VARCHAR(MAX),[yourXML]))).exist('for $x in /z/a where ( ($x/b[1]) = 1 ) return $x')>0 )

I don't think you would require a conditional split in this scenario. Instead you can filter the required data at your source where StatusFlag = 0.