Nah. Not knowing how to spell the product will get your resume in the doors...

...and AGAIN...

I wrote a chapter for Tied In: The Business, History and Craft of Media Tie-In Writing.

It's currently available in ePub versions and Kindle (see .sig for links).

Soon to...

Glad I could help. Let me know if you have any other questions on this subject.

Actually, the substring function should be SUBSTRING(name,1,2) == "ab".

If you use a single = sign, SSIS assumes you are assigning a value to...

Chris Morris-439714 (7/16/2010)

Not strictly true. A good example of RBAR would be performing a running...

Just an FYI:

Earlier, I was seeing 3 duplicate numbers when running your original NewID() solution. Repeated runnings seems to generate between 0 - 5 duplicate numbers with no discernible pattern...

And perhaps you should test your own code too?

Yes, I...

Glad I could help.

Ah. Yes. Pivot does require aggregation. Sorry. I didn't realize that's what you're doing.

Hmm. Now I'm wondering if there's a way to trick Pivot into doing an aggregation that isn't...

Bleargh. I had a feeling that was going to be the answer.

Oh, well. If I hadn't asked the question, there would have been an alternative. @=)

Thanks, Gail.

So many potential solutions. I like Steve's solution stuffed in a sub-query and broken out into separate columns. Then just do a count in the outer query and group by...

Column List in the SELECT part of the...

Do a search on phrase "Dynamic Pivot". See if that helps you out. Then post back on this thread with further questions about it.

Glad I could help. Let me know if you have any more questions regarding this issue.

Well that depends on where the .exe file is located. If it's on a UNC or Share drive, you just need to add the proxy account to that path's Security...