Viewing 13 posts - 61 through 73 (of 73 total)
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...
May 29, 2003 at 8:52 am
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...
May 29, 2003 at 8:38 am
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...
May 27, 2003 at 7:00 am
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...
May 27, 2003 at 6:41 am
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...
May 27, 2003 at 5:37 am
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...
May 27, 2003 at 5:21 am
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...
May 27, 2003 at 5:11 am
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)?
May 22, 2003 at 2:45 am
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...
May 19, 2003 at 4:27 am
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...
May 12, 2003 at 4:50 am
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...
May 12, 2003 at 4:26 am
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...
May 12, 2003 at 3:41 am
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...
July 16, 2002 at 9:58 am
Viewing 13 posts - 61 through 73 (of 73 total)