First of all: thank you for providing ready to use test data!! Well done! 😀

Would something like the following help?

;WITH cte AS

(

SELECT RelatedID

FROM #A

GROUP BY RelatedID

HAVING count(DISTINCT...

How would you sort the procs by creation date, as requested in the original post? :ermm:

Glad I could help! 🙂

Based on what you provided so far the cursor could be elminated by a single insert statement like this:

INSERT INTO XMLtemppatientMap(oldpatientID, newpatientID, oldfileID, newfileID)

SELECT patientID,'@newpatientID',fileID,NEWID()

FROM fileList

WHERE patientID = @patientID

AND (fileType...

I think the major issue is that you use the CROSS APPLY function in a way that forces SQL server to parse the xml string for each and every article.

I'd...

When adding the following three samples to your data, which one should be displayed (each one has values in two out of three columns)?

select 'fred', 'unsure', 33716, 'test@here.com','444.75.224.23', null

union

select 'fred',...

I wouldn't really use a while loop for it nor would I order by ordinal column position.

I'd rather go with a set based solution based on the Tally table concept...

Would the following work (untested)?

CASE WHEN [DOB] = '1899-12-30 00:00:00.000' THEN NULL ELSE [DOB] END

It sounds like your database structure is far away from being normalized...

Instead of looking for a way to update those 4 tables I strongly recommend to redesign your database to...

The percentage sign is misplaced. Therefore it's treated like

SELECT @Query%

Try

AND sdest.[text] LIKE ''%' + @Query +'%''

I'd talk to the folks that are responsible for the script that adds the column each day to give me another column [row_total] that would add all previous columns. If...

I'd like to repeat what I stated before:

Please provide table definition, sample data (in a ready to use format) and expected output as described in the first link in my...

Since you already started using "left" and "right" terms in your table you might want to consider using those columns as holding the data as per the nested set model....

What is the business rule for the values for Introducer,LeftMember, and RightMember?

Yor sample do not show an "easy" pattern...

Example: ID=2 has Introducer=10 but is LeftMember of ID=1.

Edit: Thank your...

Several issues:

1) please provide sample data in a ready to use format

2) include expected result set

3) show us what you've tried so far and where you get stuck

For details reagarding...