Viewing 15 posts - 1 through 15 (of 34 total)
Superb training. The voice was familiar... "Hitchhiker's Guide to Sql Server Profiler?"
February 2, 2010 at 7:55 am
Threads can be rated. I rated this 5 stars because there is a lot of instructive stuff in this. It has been helpful to see techniques for expanding a simple...
November 6, 2008 at 4:10 pm
Ok, I worked out all of the syntax and this compiles and gives me the results I want:
WITH OneYearByVendor (Vendor,Yr,TotalBags)
November 3, 2008 at 2:26 am
If I sum the bags in my CTE, should I change it to this? (Note "[TOTAL_BAGS]")
WITH OneYearByVendor as (Select
November 2, 2008 at 4:18 am
I need to create a report of bags ordered this year compared to last year, by vendor.
Since I need to create a report, I'm thinking I need a view, from...
November 1, 2008 at 9:59 pm
Let's see if I get this...
WITH [I'm going to create a Temp table that will be available to my main query...]
Spec as (Select *, Row_Number() Over ["Over" says I'm going...
November 1, 2008 at 9:16 pm
Apparently I need to get to know Window Functions... I have another situation where this will apply.
Yeesh. This old dog has got a lot of new tricks...
November 1, 2008 at 8:47 pm
This is an export to Excel as a .csv (I have it working, so this is purely academic)...
DOCTORID, ADDR, CITY, STATE, ZIP
DOCTORID, SPECIALTY, LASTCRED
I need to...
November 1, 2008 at 5:29 pm
Well I did it, but with multiple selects (selected from the address file and did a fetch on each address for the other stuff (ie: Specialty1, Specialty2...), which I programmatically...
November 1, 2008 at 11:33 am
I got this worked out.
I drive the query off of the address file (so they list vertically) and for each record I do another select and, in a loop, make...
October 28, 2008 at 6:48 am
Thanks for the answer.
I apologize for the dup posts. I can't seem to avoid it. And I tried to delete it twice, but it would not delete!
October 27, 2008 at 8:16 am
It is non-intuitive to me that triggers are batched. That is, it appears that if you update 5 records, the 5 updates are done, then the 5 deleted and 5...
October 14, 2008 at 9:44 pm
Now, I know someone is asking, "What if I need to process each row?". If this were posted on a forum I would ask, why? What is your desired result...
October 14, 2008 at 8:23 pm
Yeah, I am only concerned with a single row at the moment. I suppose I need a where clause.
October 14, 2008 at 6:26 am
That was it, Matt. Thanks. That and the fact that I was missing some periods. Thanks! (I don't know how to mark this as the answer).
October 13, 2008 at 9:48 pm