Forum Replies Created

Viewing 13 posts - 61 through 73 (of 73 total)

  • RE: Putting result of select for xml into a variable

    There are two answers to your question.

    1. It can't be done with "for xml" (because t-sql won't let you do anything with the output.

    2. It can be done by faking...

  • RE: xml vb script help

    Create an xml document (msxml2.domdocument) and use it to accept the output from the for xml t-sql.

    TIP: "for xml auto, elements" is the easiest way to use the...

  • RE: SP with Select * from table for xml auto

    Why does the column header matter? You only see it if you save it directly to a file.

    If you are going to have a 'front-end' to run this t-sql...

  • RE: select...insert

    Unless you can associate the actionTypeID with something to derive the desc, date and report or simply use constants to default these columns you can't.

    Unless I'm missing something obvious you...

  • RE: Why is XML support in SQL Server beneficial?

    By allowing SQL Server to return (and/or receive) XML you can build pseudo-web services which can be bound directly into XML and used on the client side.

    The benefits of having...

  • RE: for xml generates annoying header guid

    To start with I don't think there is a way to alias the output column in T-SQL.

    But you can decide to code the presentation.

    But it depends how you are returning...

  • RE: Select statement

    This code will find the previous, current and next values in a run (a run is a sequence with gaps).

    If you pick the top or bottom value then only two...

  • RE: dynamic Case

    ikf

    I don't understand your post. Do you want a print-out of the code, or examples of cursors (there are lots on this site)?

  • RE: dynamic Case

    I think I understand this one, you want the names to appear as the column names and the values to appear under them - ie a cross-tab report- and you...

  • RE: Order by in Query problem

    You can use an identity field as mentioned or add a date column to your client briefcase - which you could then use for extra functionality like finding 'dead' briefcases...

  • RE: outer join problem - sql 92 syntax

    Try simplifying the problem by joining two tables in both ways and seeing if there is a divergence, then three tables and so on.

    Without data it is difficult...

  • RE: increasing number of bytes per row

    I thought I remembered this one, from SQL Server Magazine UPDATE, May 3 2001...

    * TIP: MAXIMUM ROW SIZE

    (contributed by Richard Waymire, rwaymi@microsoft.com)

    Q. How can I find...

  • RE: Scheduled package fails at getfolder(unc)

    I can't access the sql box because it is a virtual cluster in a secure location. The ip address that is used to access sql server doesn't point to...

Viewing 13 posts - 61 through 73 (of 73 total)