[facepalm]

D'oh! It's Friday and I'm tired. Thanks for pointing out the stupid mistake....

Jeff -

I just wanted to jump in and say Thanks! I went out of town last week so I was never able to follow up on this. ...

Nice! Thanks!

Nevermind. Found answer:

"At any time, only one table in a session can have the IDENTITY_INSERT property set to ON..."

...almost there. Almost. Any idea as to why I can only do this once in my Stored Prod?

For example:

SET IDENTITY_INSERT pnd_Product ON

SET IDENTITY_INSERT pnd_Customer ON

Msg 8107, Level 16,...

Thanks! Will give it a shot.

Thanks everyone. After some trail an error, I was able to create a SP that does most of what I want it to. It's a whopper as it...

That sounds like a plan! Could you please explain how you "i script out the DDL differences between the developers' version, and production"?

Thanks a million!

Could you elaborate on scripting out the FKs and then readding them?

OK. Thanks. Hope you're right. Will know soon enough.....

I'll post back what I came up with and welcome feedback. Hopefully within the hour.....

I was actually leaning towards a temp table....I will give it a try.

I do not but I can ask the "mainframe" guys. Thanks for the help.....

This one is giving me a lot of grief!!

Check this out:

SELECT

CASE

WHEN ISDATE([InspectionTime]) = 1 THEN

CONVERT(TIME, [InspectionTime], 114)

ELSE

[InspectionTime]

END

FROM Inspection38

"InspectionTime" is a field that will contain some bad data (invalid...

I just realized that the source database is SQL 2008 although the destination is 2012. Oh boy....looked online some more and it seems TRY_CAST or TRY_CONVERT is not an...