Matt Miller (#4) (10/14/2014)

---

First - one smallish comment: SQL INJECTION. This one's ripe for it. seeing the dynamic query concatenated with some input (and with the Web...

Thanks so much guys. Really appreciated.

Do I need to change when I send the commit if there is more than one statement? (Do I wrap the whole thing in...

Thanks Jack.

This looks like exactly what I was looking for.

I'll give it a test in a day or two.

Thanks again!

okay scratch that..

some of the code within our procs/views/etc references the server name

Our vendor is...

Maybe I don't understand your needs..but couldn't you create an SSIS package to create the bak then move it to wherever you want in the package.

You could then write a...

Will do. thanks.

Yep using NULL worked. THANKS!

got it

PH.PEHCHARGEDATE >= @Startdate and PR.PRGPAYDATE <= @Enddate

Thanks Guys.

Jeffery we are going the two domain route.

Thanks Erland. I think I have it figured out.

I used this:

http://support.microsoft.com/kb/918992

And it worked, but much to my surprise it didn't transfer everything correctly. It looks like it transferred all...

mickyT (8/22/2013)

---

Hi

Simplifying you query down, I would expect that you are seeing the following behaviour?

with simpleExample AS (

-- A simplified example of what I expect you are seeing from...

works good dwain.c

thanks

Great idea Bhaskar.Shetty

thanks kapil_kk