Viewing 15 posts - 4,981 through 4,995 (of 5,502 total)
To get the result in XML format, use a normal select clause and add FOR XML AUTO to it. It will convert the result to one type of XML format.
Since...
September 12, 2009 at 11:32 am
I really do understand that most of the people who survived the terror just by some sort of coincidence (or destiny or whatever you'd like to call it) are not...
September 11, 2009 at 4:08 pm
Martin Davies (9/11/2009)
Select top 4 locationfrom Locations
where location >= 'A2'
"ORDER BY location" should be added to this query.
Otherwise results may be unexpected.
September 11, 2009 at 1:16 pm
Hi,
Edit: Please disregard. Andrews solution (see previous post) is much easier and performs a lot better.
it's a little more complicated in SS2K (at least in terms of readability), but not...
September 11, 2009 at 12:54 pm
First of all, thank you for providing DDL together with obviously carefully designed sample data! Good job!
Following please find a proposal that will give you -almost- the expected result (Throughput...
September 10, 2009 at 4:57 pm
Would you please provide some sample data to test against together with your expected result?
For details on how to post those data please see the link in my signature.
It's some...
September 10, 2009 at 1:49 pm
duplicate post.
discussion already started here
September 10, 2009 at 1:30 pm
Once you start explaining why you need to do it would you please support your explanation with some sample data to make it more understandable and -maybe- to give us...
September 10, 2009 at 1:17 pm
Assuming your column [dbo].[imitmidx_sql].[activity_dt] is of a char(10) type, it should be more efficient to use
SELECT CONVERT(CHAR(10),GETDATE(),101) instead of the replace and convert functions.
However, you should think about storing...
September 10, 2009 at 1:13 pm
Duplicate post.
Please continue here . (It's the link to the 2K8 forum, where this question obviously belongs to).
September 10, 2009 at 1:04 pm
Dave Ballantyne (9/10/2009)
Select WeekNo = datepart(week,datecol),
Mon = sum(case when datepart(dw,datecol)=2 then Sales else 0 end),
...
September 10, 2009 at 12:52 pm
I'm just going to repeat what I posted before, just a little more focussed:
Straight from BOL again:
varchar [ ( n | max) ]
max indicates that the maximum storage size...
September 10, 2009 at 12:16 pm
duplicate post.
please continue discussion here .
September 9, 2009 at 3:52 pm
Viewing 15 posts - 4,981 through 4,995 (of 5,502 total)