Don't know of any coherent place dedicated to just doing crosstabs or just to dynamic SQL... there's a lot of really bad examples that use cursors, as well.  But, if...

Don't think you need a cursor... see the oversimplified example at the following...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=319791

I strongly suspect that your example data is missing something, but the following will do for what you have... lemme guess... spreadsheet output?

--=======================================================

--      This is just setting up...

Since none of the methods are likely to use an available index when used in a WHERE clause, try this one...

--=============================================================

--      This section of code is just setup...

Why not just email the HTML that sp_MakeWebTask creates?  When they double click on it as an attachment, it'll come up just fine.

Sure, sure.... but we both know that they don't always comply... yep, it's crap but sometimes (like in the telephone reseller business) they send you crap just to make your...

Hasn't yet, Serqiy...

Heh... Pele, huh?

Anyway, I agree... if you are in control of the source of the data, then "store all parts of names in databases separately".  However, the story changes a...

They don't have a switch for it so....

bcp "SELECT 'Pub_ID','Pub_Name','City','State','Country' UNION ALL SELECT * FROM Pubs..Publishers" queryout publ_out /c /t , /r \n /Sservername /Uloginname /Ppassword

You could do...

The free trial version would certainly work but... why don't you spend the $64 for the Developer's version so you don't have to worry?  And, why doesn't Borland Interbase support...

Then, don't add columns to an existing table... make a new table that has all of the necessary columns (I'm thinking temp table here) and copy the data from the...

>>After you finish with it start with his original name: "Jean-Claude Camille François Van Varenberg"

Leave it to Serqiy to know something like that

Temp tables do NOT always write to disk if they are small... do see Q4of the following URL which I've now posted 3 times in this thread...

http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k

... which...

Oh, no, no, no.... don't use BETWEEN... it's a form of "Death by SQL".   First, 23:59:59.999 will be rounded up to the next day and you will get all of the...

Praveen,

I've been asked many times to improve the performance of "a server"...

Yeah, overall server tuning and correctly adding appropriate indexes and deleting unused...