Forum Replies Created

Viewing 15 posts - 331 through 345 (of 3,232 total)

  • RE: Where are you?

    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...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Where are you?

    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. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    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. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: pass table name as a parameter in stored procedure

    Simhadri Basava (9/15/2010)


    How to include where condition in above query.

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

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Creating Header AND Footer to a flat file destination file

    Please post your expression.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Creating Header AND Footer to a flat file destination file

    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 "...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    Brandie Tarvin (9/14/2010)


    ...with lox?

    Or cream cheese?

    or bacon?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Creating Header AND Footer to a flat file destination file

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

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    CirquedeSQLeil (9/13/2010)


    Bacon

    mmm....bacon

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Restoring database from another server

    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...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Restoring database from another server

    Can you post the results of the RESTORE FILELISTONLY statement?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Need to select all elements of an XML document from an XML data type column

    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...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Need to select all elements of an XML document from an XML data type column

    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...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Need to select all elements of an XML document from an XML data type column

    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,

    ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Need to select all elements of an XML document from an XML data type column

    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?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 15 posts - 331 through 345 (of 3,232 total)