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...

One thing I would recommend is that you should ALWAYS specify the length of your character data. If you don't it will assume the default length. Do you know what...

thall 8753 (8/8/2012)

---

Some background information is in order:

3rd -7th columns refer to tools that lots are processed through, in that order.

I need to be able to fill in the child's...

scottichrosaviakosmos (8/8/2012)

---

create table #abc(insertid int,cityid int,parentcityid int,cityname varchar(50),parentname varchar(50))

insert into #abc

select 1,10,11,'A','B'

union

select 1,11,12,'B','C'

union

select 1,12,13,'C','D'

union

select 2,10,11,'A','B'

union

select 2,11,13,'B','D'

union

select 2,12,11,'C','A'

Output:

Insertid Cityid Parentid ...

I took the liberty of using an online sql formatter to make this a bit easier to read:

DECLARE @DB_NAME VARCHAR(200)

DECLARE @SQL2 VARCHAR(MAX)

DECLARE DB_CUR1 CURSOR

FOR

SELECT [NAME]

FROM dbo.sysdatabases

WHERE (dbid > 4)

AND STATUS...