Yep... that would work,...

Fixed that... thanks for the observation... I always hate coverting working code into instructional code... I mess it up almost every time :hehe:

Now you know why I don't let images and other blobs into may databases... too much of a hassle. I just store the names of files in the database...

I know... I'm a sick man... I usually have a primary key and an alternate key... except for a relatively static state or country reference table, I don't like natural...

If making RAC open source would stop your spamming, I'd be happy about that. 😛 And, your insults are a great way to drum up business :w00t:

Just curious... how...

WHERE = NULL will not work unless you make a pretty uncommon (some consider it "dangerous") change to the ANSI NULL settings of the server. NULL is not "nothing"...

Look again... you're not getting what you think you're getting... run this small demo to see why...

[font="Courier New"]DECLARE @Params VARCHAR(100)

SET @Params = 'abcdefghij[ImportDate=12345678901234567890'

SELECT SUBSTRING(@Params,PATINDEX('%[ImportDate=%', @Params)+13,19)[/font]

...did you...

I'm curious... what did you need this for?

Not sure what you're using to do the move, but can you split the job? Trying to move ore even UPDATE more than 1 or 2 million rows at...

It's easier than that... lookup STUFF in Books Online...

David McFarland (10/22/2007)

---

Seriously, I have always considered you a fair arbiter, simply based on posting history, and had never once questioned where you'd come down when faced with actual...

Thanks, Matt...

I'd be doing a full install on a box that already has the Developers Edition of 2k on it and I'd be installing the Developer's edition of 2k5... do...

Matt... all good points and thanks for the experiments you did... Man, I gotta take the time to install the Dev version of 2k5... then I can run my own...

Heh, yep... I've been there as well... puts the DBA between a rock and a hard spot.

I guess all you can do is wait, then. When it gets bad...

HEH!! Now, THAT's entertainment 😀