xml solution and function solution ex, calling scalar funtion i had . apart from these if any thing is there then pls tell me so that i stop finding...

Hi, this is test data , I am not into working on production & Thanks alot for the answer ,would be nice if you could test too with the...

Do you have a non-Production version of the database that you can test this on? You really need to do that, I think.

How can I ensure for example that rows...

Presumably, you are using SSDT to do the SSIS development? You can deploy from there. You can also deploy using PoSh, which is what I do in our CD environment.

You...

Your syntax is nearly right, but not quite. You will have to explicitly name all of the columns, except for the IDENTITY column, which will take care of itself as...

Is the Id column an IDENTITY column?

That is a statement, not a question. It's similar to me saying: "I am not a turnip".

we tried to upgrade to 2019, but unfortunately, MS has put some restrictions like they have converted scalar functions to inline function by default and that throws an error...

As usual, code not formatted and no question is asked.

BUT even if you DO get it on your screen, there are a LOT of typos in it which makes it impossible to copy-paste into SSMS UNLESS you want...

Ah yes, that's much easier to read now, on my brand new 20-metre-wide screen.

Such a shame you're on 2012. It's time to upgrade! In 2017+, this solution works:

WITH r1
AS (SELECT R
         ...

Have a look at this link.

In order to use CommandTimeout, it seems you will first need to create an OdbcCommand and push your query through that.

I answered this question yesterday. Why are you asking it again?

Use single quotes for literals, not double quotes.

Date literals should be in the form 'YYYYMMDD'.