Superb training. The voice was familiar... "Hitchhiker's Guide to Sql Server Profiler?"

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...

Ok, I worked out all of the syntax and this compiles and gives me the results I want:

WITH OneYearByVendor (Vendor,Yr,TotalBags)

AS (Select

[Vendor...

Kewl!

Two things...

If I sum the bags in my CTE, should I change it to this? (Note "[TOTAL_BAGS]")

WITH OneYearByVendor as (Select

DatePart("Year",[Date Ordered])

...

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...

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...

Very impressive!

Apparently I need to get to know Window Functions... I have another situation where this will apply.

"With"

"Over"

"Partition By"

"Coalesce"

"Window Functions"

Yeesh. This old dog has got a lot of new tricks...

This is an export to Excel as a .csv (I have it working, so this is purely academic)...

DOCTOR TABLE

DOCTORID, NAME

OFFICE TABLE

DOCTORID, ADDR, CITY, STATE, ZIP

SPECIALTY TABLE

DOCTORID, SPECIALTY, LASTCRED

I need to...

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...

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...

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!

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...

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...

Yeah, I am only concerned with a single row at the moment. I suppose I need a where clause.

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).