chris.compton (3/7/2008)

---

I would be interested in hearing about a re-test of the VarChar(7000) vs. VarChar(Max). (which I don't have time to do or I would)

It is my understanding that...

Curious... did you know that a T-SQL function will likely run just as fast here and a properly formed Calendar table will out...

I missed that in Adam's post (too much of a hurry). He's absolutely correct.

Only problem is, this is an SQL Server 2k post... Adam's solution uses VARCHAR(MAX) which isn't...

Heh... truth be told, I didn't even look once he said it was in Spanish.

Ray White (3/7/2008)

---

I would like to retain a leading zero on decimal output.

IE I would like 0.4567 vs .4567; The only way I can think of doing this is to...

robertafricker (3/7/2008)

---

Hi Jeff,

Thanks for weighing in re: Lynn's rewrite. Now, it makes more

sense to me, that hanging "IN" was throwing me off!

I'll be sending through some far meatier examples...

...or... if you just want the names of the objects so you can go look at them...

--===== Find name of proc, view, function, etc containing text in DDL

SELECT DISTINCT...

If it's a one time thing only... why not change the text window to use tabbed delimiters and tell it to save to a file?

Heh... it's the SQL gods telling you that you should solve the problems in T-SQL instead of writing a CLR 😀

Low standards? Former Govt employees?...

Sure, you can use LEFT 10 to do that... but stop just for a minute... you've not told us why you want to overwrite the ID with the Description. ...

It sounds to me like the DateDebut column is a VARCHAR column and could be in the dd/mm/yyyy format instead of the format you're expecting of mm/dd/yyyy.

Hold the phone... how do you know that the only things that start with VA are VA- as in Virginia... never do an update of this nature without first doing...

BWA-HA-HA-HA!!! Oh, the poor fools that last asked me...

The reason why you have to do it with Dynamic SQL is because it will not allow you to do formulas in the query. The Query must be "hard...