Always a good thing to read http://www.sommarskog.se/dynamic_sql.html when it comes to this topic.

Hm, I'm not sure if I follow you here. Consider this:

SET NOCOUNT ON

DECLARE @TTT TABLE

(

     THE_ID INT NOT NULL

     , Name varchar(50)

)

INSERT INTO @TTT VALUES(1,'A');

INSERT INTO @TTT VALUES(2,'BB');

INSERT INTO...

That's because you use CHAR instead of VARCHAR. CHAR is fixed length no matter how many characters you actually entered.

From my understanding complicates this things. If you backup up the log after a full or differential backup (rather than before), you need to restore this log additionally when you...

Perhaps you might be better off posting this to http://www.dbforums.com/f8 or

http://www.idug.org/ (I think they also host a mailing list)

I'm no fan of dynamic sql, but in such cases it in superior to static sql. Have a look here http://www.sommarskog.se/dyn-search.html

That's your opinion and I respect it. Others might think different.

However, I also read his postings. I don't agree with him on many points, but actually there is no need...

what i do always find entertaining is that he NEVER actually offers any advice

Just out of curiosity, do you actually read what he writes?

Couldn't you users just hit Strg+1 in Excel? This is merely a presentational issue. Once you've formatted the sheet, it should be okay.

Hopefully this is the end of this line in the thread.

Did you really think so?

My whole point was that there is not built...

What about having a separate date table and joining against this one?

Hm, why is everybody picking on Joe? Maybe because he is who he is? Right now I guess almost everybody here knows who Joe Celko is and also knows his "style"....

It says look at a list and returnthe first non-NULL value, casting it to the highest datatype of the expressions in the list.  It is a member of the CASE...

This is the by far most complete link to BLOBs and SQL Server, that I know of: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

As the above post is from the old forum software, here's what...

Well, even if it doesn't break a thing, at best you're running an unsupported system. I wouldn't call Microsoft PSS with an issue with such a system. Not everything that...