I did it in a hurry, sorry. please find the attached insert scripts..

Hi,

I've generated scripts with data for 4 tables, please find the attached sql script files..

Hi,

I didnt get what exactly you asking me for? Should i send scripts for 3 tables with data or what?

I'm someway nearer to the solution, When i changed my query...

Please find the sample data screen attached herewith from CandidateInterview table, where we can see the no:of candidates applied for a job for particular status..

Hi,

Please find the below screen which displays the resultset for the above join.. you can see the column selectedcandidates there with count which is not correct.

Hi All,

I'm able to build the query shown below, But the record in the table is not getting updated 🙁

DECLARE @passedXML xml

DECLARE @CandidateInterview TABLE (CandidateInterviewID uniqueidentifier,

...

Hi,

Thanks for the reply..

Can you please let me know how to overcome this, i want to know from your practises because you are SQL DBA..

Also you suggested me to use...

WayneS (10/26/2010)

---

Okay, let's simplify it just a bit more.

1. Put the data directly into an XML variable, instead of a varchar then converting to XML.

2. Use a CTE instead of...

Hi,

Without Looping also the query worked perfectly.. Thanks alot..

My doubt is if i get some 10,000 ID's in my XML, Will this kill performance??

One more thing, In case of...

Thanks for your time,

Btw i understood the query.. It worked great!!

Thanks alot man..

chuckneerg (10/26/2010)

---

Can you provide more details on what your trying to do?

I get what your code is doing but there are some logical issues with it...

The idea of you wanting...

GSquared (10/25/2010)

---

If I understand you correctly, you'll have to shred the XML and then use that to generate a delete statement. That's pretty straightforward.

Which version of SQL Server are...

Hi,

Thanks for the reply..

We are using SQL Server 2008. Which one is the best method to bulk delete the records? Can you please let me know if you havin any...

FraToLa (3/22/2010)

---

Hi,

you can solve this problem by using dynamic SQL.

In the first step analyse all existing values and add them to a result string including comas and quotation marks like...