Yes, we have Omaha steaks...and in the airport too. Don't get me wrong, Omaha steaks has good steaks, but I don't think they can compete with an actual steak...

Omaha....steak. I guess it's a mid-western thing, but Omaha has it's fair share of steak houses, but there's one in particular that puts a spin on traditional steaks. ...

Pheasant death....had a great hunt this weekend with a bunch of good friends. Shot a bunch of birds, clays, high-powers, and blew some stuff up.....video/pics on my facebook. ...

This thread is a year old. I would suggest creating a new thread with your question.

Please post your expression.

Set your variable up to Evaluate as Expression and use the expression builder to add the carriage returns into your variable.

"This " + "\r is " + "\r a "...

or bacon?

The same technique should work just fine. You'll just want to include carriage returns in your header variable where needed.

mmm....bacon

Yes, as Steve stated, please start a new thread. Then update this thread with the link to the new one and I'll hop over there......I think I see your...

Can you post the results of the RESTORE FILELISTONLY statement?

Lutz, I agree...please stay on. I know that you have ample XML experience and could add value to this thread. Thus far, I've been poking around to try...

Yes, that makes sense. My example shows the insert into the table simply to create sample data. Ignore that part and focus on the output. What I...

OK, so how does this differ from what you expect?

DECLARE @AmendBarsetFlight TABLE (RowID int IDENTITY(1,1), XMLBeforeAction xml, XMLAfterAction xml)

INSERT INTO @AmendBarsetFlight(XMLBeforeAction, XMLAfterAction)

VALUES('

<xml_node>

<test>XMLBeforeAction</test>

</xml_node>',

'

<xml_node>

<test>XMLAfterAction</test>

</xml_node>'

)

SELECT XMLBeforeAction,

...

An example here would really help. Can you post an example of what the column data would be and how you expect your result set to look?