I don't get it.

the script is great, but if you have to physicaly move the files your self anyway, than wouldn't just

stop the db, detach files , move them...

Hi JK, I would like to put in my 2 cents here 🙂

I do not agree with you that US is lagging behind everyone else in usage of UPC....

you are most definitely can use AND/OR condition in the ON clause 🙂

I have been using them forever...

also you can use an AND in MATCHED stmt.

Like so:

MERGE T...

well this seams to work very well

"NOTE" that I am matching the records based on "sort of"

hash made up by concationations of same columns

from TableA and ...

SSC -- please disregard my post with all that crazy function of mine 🙂 it was designed for something else and I just tried to adapt it for...

well the issue is not the start date but the end date.

"31/12/2004" is not a valid date in SQL server unless the server default is set to a locale(location...

I didn't noticed before, but in your reply with "that now works"

you are not only changed select from using between to new notation

but yut you also changed the...

I tihnk the issue is that you are mixing date formats for dates

I have noticed in my past encounters with between operator

is that if you give date format that...

where it is true that Journaling needs to be enabled on the table for it to be updated, it is not correct to say that table is read-only.

I have...