Viewing 15 posts - 51,991 through 52,005 (of 59,072 total)
chris.compton (3/7/2008)
It is my understanding that...
March 7, 2008 at 8:15 pm
The assembly (dll) just calculates the companies holidays.
Curious... did you know that a T-SQL function will likely run just as fast here and a properly formed Calendar table will out...
March 7, 2008 at 4:13 pm
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...
March 7, 2008 at 4:07 pm
All right smarty....He's pointing at the BOL entry for OPENQUERY...
Heh... truth be told, I didn't even look once he said it was in Spanish.
March 7, 2008 at 4:02 pm
Ray White (3/7/2008)
IE I would like 0.4567 vs .4567; The only way I can think of doing this is to...
March 7, 2008 at 3:57 pm
robertafricker (3/7/2008)
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...
March 7, 2008 at 3:50 pm
...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...
March 7, 2008 at 3:26 pm
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?
March 7, 2008 at 3:17 pm
Heh... it's the SQL gods telling you that you should solve the problems in T-SQL instead of writing a CLR 😀
March 7, 2008 at 3:14 pm
ScottPletcher (3/7/2008)
Well, I guess it's nice to see that there are still places where low standards prevail and former govt employees can find actual work.
Low standards? Former Govt employees?...
March 7, 2008 at 3:10 pm
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. ...
March 7, 2008 at 3:00 pm
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.
March 7, 2008 at 2:48 pm
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...
March 7, 2008 at 2:43 pm
Wow this thread reminds me of my last interview. I was asked what is the fastest way to clear a table.
BWA-HA-HA-HA!!! Oh, the poor fools that last asked me...
March 7, 2008 at 2:22 pm
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...
March 7, 2008 at 1:15 pm
Viewing 15 posts - 51,991 through 52,005 (of 59,072 total)