Why are you looping? What RDBMS are you using?

Koen Verbeeck (8/5/2014)

---

Migrate from Oracle to SQL Server? Do I...

To search within SSIS packages that are in the file system, I use Notepad++ with the "Find in Files" option (Ctrl+Shift+F). It'll find if the text is used in the...

To have a good explanation on how to do it, read the following article: http://www.sqlservercentral.com/articles/T-SQL/63681/

And remember that MAX() is an aggregate function that you can use on strings.

You are on the right track with your last sentence. Here's how you could do it. I'm leaving your option and an additional one.

--Your option

SELECT *

--DELETE

FROM Vend_Comp

WHERE ID NOT IN...

I'm not sure, but I believe that this is the fast scalar function I was talking about. http://www.sqlservercentral.com/Forums/FindPost1222341.aspx

Sean Lange (8/5/2014)

---

Luis Cazares (8/5/2014)

---

Maybe this thread can give you some ideas. http://www.sqlservercentral.com/Forums/Topic1531616-392-1.aspx

There's another option that uses a scalar function which seems to be faster but I'll have to find...

Please post DDL and sample data as insert statements so we can have something to test on. You should post expected results based on that sample data.

Otherwise, I'm not sure...

Maybe something like this?

WITH SampleData(id, date, value1, value2) AS(

SELECT 1, '21040605', 'Yes', 'No' UNION ALL

SELECT 1, '21040606', 'No', 'Yes' UNION ALL

...

Maybe you culd read Part 2 of the Cross Tabs and Pivots series. 😉

http://www.sqlservercentral.com/articles/Crosstab/65048/

Maybe this thread can give you some ideas. http://www.sqlservercentral.com/Forums/Topic1531616-392-1.aspx

There's another option that uses a scalar function which seems to be faster but I'll have to find it.

Hi Renee,

Welcome to the forums. You're quite new, so I'm explaining some best practices when posting. You explained your problem almost clearly enough but I'm not sure if your priorities...

The SET statements are session specific (unless someone corrects me). That means that if you set identity_insert on, you can only use that option in that session and other sessions...

Hi Daniel,

The problem in this case is not about splitting but about joining the values.

Another problem is that you're using a multi-statement table valued function that uses a recursive...

Just don't forget to turn IDENTITY_INSERT off for the table after you finish your load. 😉