It's quite easy to accomplish this task. The slowest part is to recreate the DDL and sample data. This time I did it on a CTE, but you should take...

It's not that complicated, but it seems like a very bad...

Take a look at this articles and return if you still have questions 😉

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 -...

Here's one idea, but I have no idea if it will fit your needs or if it will perform fine

WITH option1 AS(

SELECT 1 AS column1,

...

For more information, I recommend you to read the following articles that would even allow you to return a variable number of columns.

Cross Tabs and Pivots, Part 1 – Converting...

You missed the point, the OP didn't want...

Let me give you an example by simplifying your code.

DECLARE @id INT

SELECT @id= max(id) + 1

FROM TABLE

INSERT INTO TABLE (

id

,country

)

SELECT

n

,'Germany'

FROM dbo.Tally

WHERE n BETWEEN @id AND @id <= 1002261

You wouldn't...

So, you basically want to generate IDs with the same value X number of times?

For that, you can check The "Numbers" or "Tally" Table: What it is and how it...

Something like this?

http://www.sqlservercentral.com/articles/Data+Generation/87901/

Now I am concerned. Do you really need to delete Patient information?

If it's just to show the names, then this might help.

WITH Unique_PT AS(

SELECTPT_LST_NAM + CASE WHEN ALS_FLG = 'Y'...

Something like this? or am I missing something?

SELECT *

FROM OneTable a

FULL

JOIN OtherTable b ON substring(a.ANUM,4,10) = substring(b.ANUM,4,10)

...

Without sample data to test, I might be giving you the wrong solution but with the previous mentioned articles you should be able to fix it or ask specific questions.

SELECT...

You should take a look at these articles

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

The condition is to get the rows that don't exist on either table using the FULL JOIN. I took a shot at guessing ANUM wouldn't be nullable or at least...

I can't understand the problem. You say there are no rows where IsResSchedule = 1 , but the code for the new sample data shows 2 rows with IsResSchedule =...