See, if this helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=16769

The formatting is a bit strange, since it was originally written in the former forum software here

Hm, I would call it a bit of article recycling.

Without...

You're welcome

Here's an answer from Paul Randal, which might clear things up a bit

http://groups.google.de/groups?hl=de&lr=&selm=eUDrwctNEHA.2820%40TK2MSFTNGP10.phx.gbl

Some of the finest SQL heads around have contributed to this article:

http://www.sommarskog.se/arrays-in-sql.html

Although it's a quite long article, it might give you some ideas.

Hey, you're short of words today

Could it be something like this?

select au_lname from authors a1

inner join authors a2

on a1.au_lname = a2.au_lname

That the above...

Here's an explanation about SQL Server and binary data in general. It might give you some ideas:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

To me it looks that when you have a column named ProjectNum and store there a wild mixture of strings, numbers, and combinations, you might need to revise your data...

Don't make me feel

< snip and switch to my online dictionary>

embarrassed

</snip>

Could it be you've tried this via Enterprise Manager?

If so, you might want to have a look at ALTER TABLE blahblah DROP COLUMN. The syntax is explained in BOL.

Oh, and regarding your temp table question. That might be a valid alternative. However, don't create it inside the dynamic sql batch. It will be gone since the dynamic batch...

The error message is pretty much self-describing. Change the variable type from varchar (I guess it is) to nvarchar

Here's a complete example how to use the result of sp_executesql. Try...

Okay, that's acceptable.

I guess you would be lost without an instrument that could deal with missing information in that clientel anyway.

Deutschland, Deutschland, uber alles.... Wie gehts?

Not so happy with this anyway, but that's another story.

I'm used to search in Google.de. But I think it's the same as when you...

Now, if you got all information collected you should be able to use DBCC PAGE like this:

DBCC TRACEON(3604)

DBCC PAGE (11 < or db name >, 3, 168217, 3)

The undocumented DBCC...