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

kevmck (7/30/2012)

---

Basically - I need to match the person to the tier based on some user defined rules. These rules would be along the lines of tier 4 is...

Are you trying to figure out which tier a person should belong to? In other words this sounds like you are trying to write a GetPersonTier function or something like...

Abu Dina (7/30/2012)

---

Thanks for this Sean. You are right about the badly written query but for now I'm trying to work out if the approach adopted by the previous developer...

Well of course but it was rather fun to write in...