You can't use a variable name in a PIVOT list.

Post some sample data together with a description of what you are trying to achieve.

One could always specify both:

SELECT DISTINCT

C.Title,

C.FirstName

FROM Person.Contact C

GROUP ...

Complex question, but see the following two-part blog entry by Paul Randal - it contains a lot of very good information about loading data quickly, especially the effect of batching...

Using a variation on Lowell's idea, and assuming your dates are US format:

SELECTinput = T.monthyear,

the_month = MONTH(CA.the_date),

the_year = YEAR(CA.the_date)

FROM#test T

CROSS

APPLY(

SELECTCONVERT(DATE, REPLACE(T.monthyear, '/', '/01/20'), 101)

)

CA (the_date);

Excellent technical advice on The Thread today. Thanks all.

gheinze,

Can I ask *why* you want to block query 2? It seems an unusual requirement. Why would it be bad for query 2 to run without blocking in...

According to my wife, I am not capable of simple multi-tasking anyway 🙂

Oliiii (10/4/2010)[hrIt looks like it knows that even though the record is held by an exclusive lock, it hasn't been modified yet so is not yet dirty and can then...

jcrawf02 (10/4/2010)

---

You should have carried them...

Right well that's different - now you are using the isolation level correctly.

The point of the row-versioning...

Seems fair 🙂

BrainDonor (10/4/2010)

---

How much is GST increasing by? We're planning a tour of both islands for next year and had all of the hotel, fuel bills and suchlike budgeted. If we...

I can imagine. Luckily I am no sort of fitness devotee, so...

Yes, they have confirmed SHA2 will be present in Denali:

http://connect.microsoft.com/SQLServer/feedback/details/585006/improve-hashing-support-hashbytes-improvements

For the time being we have SQLCLR integration, which means...

Grant Fritchey (10/1/2010)

---

Personally, I wouldn't be happy with either plan in terms of performance. I'd try to get rid of the key lookup as well. Possibly add the columns to...