1.

Insert all the row into one temporary table as mentione abone in another post.

should keep the identity column in the #T table

2. Now start a while...

Hi,

why don't you use a while loop here?.

select @maxrow = max(id) from #T

SET @row = 1

While (@row < @maxrow )

Begin

select x, y,... form...

Nice question. got a good knowledge. thanks:-)

I am not understanding, why you are using dynamic sql string?

If My understanding is correct, you need to set the arguments in the where clause based on the parameter value....

BEGIN TRY

-- Some code

END TRY

BEGIN CATCH

IF @@TRANCOUNT > 0

...

Thanks for the question.

The default value for the @date1 is NULL.

Please see below proof. If I am commenting the 'set statement, I am getting @date1 as NULL.

declare @date1 smalldatetime

--set...

Good question. Really appreciating. It giving importance to Union , Truncate in Transaction.

🙂

The IN operator used in the query is very nice. Thanks.

Thank You.

Reji P R

Hyderabad

Thanks.

While working with this type of comma seperated string, first we need to split the string with the help of table valued function.

We can pass the comma deliminated string as...