Probably the code fails in following block:

SET @resultMessage = 'ticketID ' + CAST(@ticketID AS NVARCHAR(200))

+ ERROR_NUMBER() + '. ' + char(13) + char(10)

+ ERROR_MESSAGE() + '. ' + char(13) +...

Hi Vishal,

You're using variable @sqlstring now, but it's not necessary (it makes the code harder to read). But if it works it works...

Still, I believe it can work as follows:

FETCH...

Change the "PRINT @sqlstring;" part in "EXEC (@sqlstring);" or copy/paste output (Message tab) and exec.

You can solve it by using a cursor, like this:

DECLARE @sqlstring VARCHAR(MAX);

DECLARE @s-2 VARCHAR(1000);

DECLARE @cur CURSOR;

SET @sqlstring = '';

SET @cur = CURSOR LOCAL FOR

SELECT DISTINCT 'EXEC(''ALTER TABLE [' + ss.name...

Sorry. Did not read the complete post. I´ve deleted my answer.

Hopefully this will clarify the problem:

So, use quotes. But...

Don't press F5 too often or it will break 😉 Glad I could help.

I think the problem occurs here: firstname=substring(name,1,charindex('+',name)-1)

Whenever there is no "+" in the name column, the command will look like substring(name,1,-1).

Check existance of "+" first, before using the substring function.

If the tbl_Details.UpdateDate is NULL, the result will be NULL also. If tbl_Details.UpdateDate is an empty string, the result will be 1 jan 1900.

Try: Convert(datetime,CASE WHEN tbl_Details.UpdateDate = '' THEN...

The way I read it: Execution time is 31ms instead of 41000ms. That's a big difference! 😀

I dont't know the datamodel, but perhaps you can remove the DISTINCT in the CTE for further optimization?

Read this article by Hugo Kornelis to get some answers: http://sqlblog.com/blogs/hugo_kornelis

Perhaps you can try this one?

WITH AccessDenied( CardIdentifier ) AS

(

SELECT DISTINCT CardIdentifier

FROM

CardCollection...