So your process is going to insert rows into the original table? And then you are going to select all the rows from the table regardless of which Customer IDs...

I am a little late to this one but...

Your desired output does not come close to this.

CustID 1...

The reason for the error has been identified.

However nobody really addressed this question. Honestly I see a lot of things not necessarily...

Try running your code in an empty database. There are dozens of errors. It would also be preferred if you can use IFCode shortcuts (over on the left when posting)....

Your post is pretty sparse on details but I think you should look into cross tabs (rows into columns). I have two links in my signature about this topic. If...

CELKO (7/31/2012)

---

>> From Front End I select some checkboxes it comes to database with comma separation like '1,2,3'. <<

Check boxes? There are no such things in SQL You missed the...

Glad that we could help. We all have those facepalm moments. 😀

You can do it like this using cte's so you don't have to change your underlying data structures.

CREATE TABLE #MapIDs

(

WonkyID CHAR(8) NOT NULL,

Client VARCHAR(50) NULL,

Identifier1 VARCHAR(12) NULL,

Identifier2 VARCHAR(20) NULL,

CONSTRAINT...

You are welcome.

Next time you think about writing a loop,...

rummings (7/31/2012)

---

I tried to execute:

Delete From Survey_Response

I received:

Msg 547, Level 16, State 0, Line 1

The DELETE statement conflicted with the REFERENCE constraint "JOB_TICKET_surveyResponse_FK". The conflict occurred in database "WHDProd", table...

You absolutely do NOT need a loop for this. You need to group by the columns that can contain your duplicates.

select Name, StorageRef, COUNT(*)

from YourTable

group by Name, StorageRef

having COUNT(*) >...

I believe a recursive cte is what you are looking for. If you want some more specific help you need to post some details. Take a look at the first...

erics44 (7/31/2012)

---

Sean Lange (7/31/2012)

---

That somewhat depends on how that person is viewed in...

The splitter that Lynn mentions is awesome at splitting strings. However it sounds like you are looping in the front end to get the selected values? Assuming that you are...

That somewhat depends on how that person is viewed in the department/company. If...