Viewing 15 posts - 52,651 through 52,665 (of 59,064 total)
rdijk (2/5/2008)
isn't this a little easier??CREATE Function GetMonthEnd(@Date DateTime)
Returns DateTime
AS
RETURN dateadd(d,(day(@date)) * -1,@date)
END
Heh... only when you actually make it return the correct answer 😉
February 5, 2008 at 4:12 pm
I got this example from Sergiy... it totally changed my mind about the use of Float. Pay particular attention to the difference between the 3rd and 4th column in...
February 5, 2008 at 3:59 pm
If the process has the correct criteria to keep rows from being updated more than once, then you could SET ROWCOUNT 1000000 and loop until @@ROWCOUNT returns zero...
February 5, 2008 at 3:35 pm
It IS a cool solution... Wasn't so good in the performance department on my machine, though... it took 29 minutes to do the million row example on my machine... correlated...
February 5, 2008 at 3:30 pm
You bet, Toni. Thanks for all the feedback code you took the time to write and test. Everone learns something new when good folks, like yourself, do just...
February 5, 2008 at 12:55 pm
Roger that... heh, yeah, ran into the NVARCHAR thing you speak of which, of course, didn't work worth a hoot. Pretty much squared away, now. Thanks again for...
February 5, 2008 at 12:38 pm
Well, I'll be dipped... that did it, Matt. Thanks a load :w00t:
February 5, 2008 at 12:09 pm
No... didn't think that would matter... Thought that was just for compares. I'll give it a try.
February 5, 2008 at 11:47 am
Does the client allow you to use temp tables?
February 5, 2008 at 5:17 am
The problem is with the data and BCP/Bulk Insert... it doesn't like it when the format changes like with some rows having a quoted first field and some not (because...
February 5, 2008 at 4:08 am
Sure... using slightly different method...
--Create a linked server.
EXEC sp_addlinkedserver txtsrv, 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'c:\temp', --<<LOOK!!!! CHANGE TO DIRECTORY WHERE FILES ARE AT!
...
February 4, 2008 at 9:26 pm
Viewing 15 posts - 52,651 through 52,665 (of 59,064 total)