Absolutely... and that, in fact, your suggestion would definitely be the best way to solve the problem, but someone wanted me to demo using DATEDIFF as both a filter and...

Yep, true enough... I've made the same recommendation to others, myself.  It's a great example of why you need a primary key, though...

-------------------------------------------------------------------------------------------------------------------------------

  |--Compute Scalar(DEFINE: ([Expr1004]=datename(month,...

Try something like this (defaults to tab delimited for Excel)...

BCP "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" QUERYOUT Authors.xls -c -S"yourservername\instancename" -Uyourusername -Pyourpassword

John,

I didn't take the time to convert some of my old code to your specific example but the following code is a good example of a "dynamic crosstab".  Since the...

You could also embed the OSQL command in a Batch file that could provide instant gratification as to the outcome...

Sure, Dennis... having a bit of a lack of sleep going on myself, here's an example using the Northwind database...

    USE NorthWind

DECLARE @Year CHAR(4)

    SET @Year...

Concur... doesn't sound like the Developer ever heard of the IDENTITY property of a column.  Using the IDENTITY property does have some other uses, as well... think of it as...

I just gotta remember to read the last page  ... Serqiy already made a similar suggestion.  Guess a concurrence never hurts though...

This will successfully convert characters in the DD/MM/YYYY format into a DateTime datatype without much fanfare...

CONVERT(DATETIME, yourstringdate, 103)

Here's an example you can try...

DECLARE @ddmmyyyyString CHAR(10)

    SET...

I dunno... 6 bytes, 4 bytes, 8 bytes... for me, I'd still be tempted to use DateTime just because of all the things you can do with DateTime functions without...

I agree... BCP is a great tool especially when you learn how to use the format files.  You could also try a simple OSQL call using the SELECT of your...

Here, here! I second the thought!

Thanks for the offer, Ken... we're all set.

Great article!  And, I didn't like the Merge Into function anyway...

Jesper, thanks for pulling me off the ceiling... you're the best.