morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code is what...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of...

Because you already a print command in your code. In the snippet I provided I replace the exec with print because executing your dynamic code is what was causing the...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying...

morepainot (8/8/2012)

---

Sean Lange (8/8/2012)

---

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect syntax near...

morepainot (8/8/2012)

---

I have a print command at ever end. When I test the code its kicking back to this part of the code saying incorrrect syntax near '('. I dont...

There seems to be no real rhyme...

thall 8753 (8/8/2012)

---

Sean,

First, I would like to thank you for taking the time to answer my post.

I have attached expected output in an excel spreadsheet. In the expected tab, I...

No offense but that doesn't exactly help. Try adding a print command before you execute your dynamic...

Have you used the debug code I posted several posts ago and keep asking if...

morepainot (8/8/2012)

---

What am I missing in this dynamic sql?

BEGIN

SET @nSQL = '

IF NOT EXISTS (SELECT * FROM '+ @SourceDatabaseName + ' .INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_SCHEMA = ''dbo'' AND

TABLE_NAME...

I would suggest a single script with a go between each batch. It is far less prone to error than using a whole bunch of files and trying to remember...

You're welcome. The problem is you can't use variables in object names like you were doing. Glad that worked for you.

Lynn Pettis (8/8/2012)

---

I realize that the idea is to write a trigger to accomplish allowing multiple nulls but a single unique non null value, however, this is SQL Server 2008...

joshphillips7145 (8/8/2012)

---

Ok so I switched it back to an after trigger and changed up my join but still cannot get it right, I know it has to be very...