Viewing 15 posts - 16 through 30 (of 53 total)
That workaround will be fine - thanks a lot for the help. I figured drill-through isn't available as the volume of data returned could exceed the max row count...
November 16, 2011 at 4:11 am
Not sure if you might find something here:
October 5, 2011 at 2:59 am
Thanks Lutz. Appreciate the help. - you helped where google and BOL etc. failed!
Jason
----
October 5, 2011 at 1:11 am
Could this be it?
http://www.g-productions.nl/index.php?name=sp_dump_dtspackagelog
October 4, 2011 at 8:01 am
I park about a 20 minute walk from the office - why? To avoid punitive parking charges of approximately £130 per month! And it gives me a little exercise...
September 1, 2011 at 2:35 am
Assuming you want NULLs for products not sold or returned, try something along the lines of:
select pt.id_product,
...
June 6, 2011 at 2:00 am
Wow . . . 22 pages. That'll keep me off the streets tonight.
Thanks again Jeff. I'm pretty certain this is a technique I need to understand -...
March 15, 2011 at 7:21 am
Thanks everyone for the replies.
Lutz . . No, the table structures can't be modified. I'm a BI analyst, so only have read access to the tables, so have to...
March 15, 2011 at 2:18 am
I checked the 'Forums' list before I posted and couldn't see a 2K forum. I've just checked again and there isn't one listed. There is an 'Older versions' forum but...
March 14, 2011 at 10:18 am
Hi Drew, Therein lies a small problem. I'm using a 2000 server, so can't use ROW_NUMBER as it's 2005 syntax!
. . . Jason
March 14, 2011 at 9:45 am
Thanks Jeff . . . it was puzzling me a bit, but makes sense now - the technique isn't using MAX in its classic sense.
However, I still don't think this...
March 14, 2011 at 1:48 am
Hi Lutz,
I get the concept of using CASE for pivotting aggregations (and use it regularly), but my query isn't an aggregate query, just a simple select. So I can't...
March 12, 2011 at 2:39 am
Thanks Jeff - really interesting article. I kind of agree with you in the 1st paragraph - I'd rather not be doing it, but someone wants the 'comments' concatenated...
February 28, 2011 at 2:31 am
Thanks for the pointer, Lutz. I've searched SSC as suggested, and it seems that the XML functionality is only available in SS2005 and later. Unfortunately, although I'm using...
February 23, 2011 at 12:26 am
Thanks Guys.
The logs are generated in-house would you believe :-P, so I will be
asking that they are improved through use of delimiters, but I've been tasked
with stripping out the...
August 14, 2009 at 1:32 am
Viewing 15 posts - 16 through 30 (of 53 total)