Easier said than done when we get hammered for not providing the answer the OP expected when we did answer the question.

mar.ko (8/12/2015)

---

Well guys, not one of you provided a solution.

There are two:

1) ISNULL(@ColDefaultVal,'-')

That variable was the one preventing the PRINT from executing.

2) RAISERROR ('ColDflt=%s',0,1,@ColDefaultVal);

This is even better as it indicates...

pietlinden (8/11/2015)

---

The problem is that you have to remove the duplicates before you insert the batch of records.

This is one option:

insert into table_2 (col1,col2,col3)

select DISTINCT col1,col2,col3

from table_1 t1

where not exists...

Libby (8/11/2015)

---

I have a situation where our stored procedure inserts records from table_1 to table_2 when they don't already exist (uses the EXIST statement) on that table. If table_1...

I think we scared him off.

Give this a try.

select distinct

mt.field1,

ca.field3

from

dbo.MyTable mt

cross apply (select stuff((select ',' + mt1.field2

...

Suggestion, post the DDL for the tables, sample data for the tables, expected results based on the sample data provided.

What an attitude.

mar.ko (8/11/2015)

---

WHILE @@FETCH_STATUS = 0

BEGIN

FETCH NEXT FROM C_tables INTO

@ColName

,@ColOrdPosit

,@TabSchema

,@TabName

,@ColDataType

,@ColDefaultVal

;

PRINT @ColName + ' ' +STR(@ColOrdPosit) + ' ' +@TabSchema + ' ' +@TabName + ' ' + @ColDataType +...

Ed Wagner (8/11/2015)

---

Lynn Pettis (8/11/2015)

---

Ed Wagner (8/11/2015)

---

Alvin Ramard (8/11/2015)

---

Ed Wagner (8/11/2015)

---

Sean Lange (8/11/2015)

---

Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a...

That is actually what I suspected but wasn't sure.

Can't place the movie or show...

Ed Wagner (8/11/2015)

---

Alvin Ramard (8/11/2015)

---

Ed Wagner (8/11/2015)

---

Sean Lange (8/11/2015)

---

Ed Wagner (8/11/2015)

---

The silver spoons need to be ordered again. Better get at least a case.

Here's a quote I don't think...

Grant Fritchey (8/11/2015)

---

SQLRNNR (8/11/2015)

---

Grant Fritchey (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 -...

SQLRNNR (8/11/2015)

---

Ed Wagner (8/11/2015)

---

Sean Lange (8/11/2015)

---

Grant Fritchey (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names...