Viewing 15 posts - 52,876 through 52,890 (of 59,064 total)
You bet, Jeremy... thanks for the feedback. Just remember... if you have lots of data, BCP with a format file will absolutely scream compared to this concatenation method.
January 16, 2008 at 12:27 am
Crud... guess I need to start another rant! This forum won't allow me to post a "backslash-n" even in the code window. Line 188 of the BCP format...
January 16, 2008 at 12:16 am
Well.... I should have known better... as soon as I saw that it was a Government agency, I should have known that the record layout they provided wasn't going to...
January 16, 2008 at 12:08 am
David.Poole (1/15/2008)
LICH (1/15/2008)
Also "Analyser" should be "Analyzer"
Not if you're British it shouldn't.
Well, at least not until we've had a couple of "P's & Q's" 😀 Got beer? :w00t:
January 15, 2008 at 7:12 pm
Of course... but I guess I'd rather keep it professional (or at least try to salvage some semblance of professionalism on my part after my initial outburst) by not citing...
January 15, 2008 at 7:05 pm
That would be the one... they're pretty smart making it a new datatype... will actually keep 23:59:59.997 code from breaking... unless it's used on the wrong column type.
January 15, 2008 at 5:57 pm
Heh... glad someone occasionally gets a laugh out of those... 😛
More on the serious side... the "Bat with a nail in it" is actually a metaphore for what I do...
I'll...
January 15, 2008 at 5:24 pm
Right idea but no need for the loop...
SELECT CAST(varchara AS CHAR(10))
+ CAST(varcharb AS CHAR(255))
+ CAST(varcharc AS CHAR(50))
...
January 15, 2008 at 4:58 pm
GSquared (1/15/2008)
January 15, 2008 at 4:45 pm
Wouldn't this be easier?
SELECT CASE
WHEN @Nbr > 0 THEN @Nbr
...
January 15, 2008 at 4:41 pm
Govind (1/15/2008)
January 15, 2008 at 4:34 pm
Spot on, Matt.
I'll also add that SQL Server seems to have "tipping points" depending on the size of the table being updated, etc. What I mean by that is...
January 15, 2008 at 4:24 pm
GSquared (1/15/2008)
Jeff Moden (1/14/2008)
January 15, 2008 at 4:18 pm
Heh... the DBA should know enough to keep from having to set auto-grow to 1.5GB 😉 DBA should setup an alert of sorts when the size of the database...
January 15, 2008 at 6:07 am
sp_helpdb is not what I need although I wish that I could read the code for it!!
That part is the easy part... execute the following code with the results in...
January 15, 2008 at 6:03 am
Viewing 15 posts - 52,876 through 52,890 (of 59,064 total)