The BOL definitely does not explain it as per the outcome.

I will call it a bug as well.

Run the stored procs individually ?

Hi trimjib

That looks much better and a lot easier to maintain, thanks!:-)

Hi Noel

Thanks for sharing your script. It reminded me of a time I needed to do something similar.

I have taken the liberty of modifying your code. If I add or...

Unfortunately I do not understand the language of the article but surely you can use the REPLICATE function to populate your pipe symbols...

e.g.SET @exec1 = 'update a set progreso=replicate(''|'','+@c+'),descrip =...

ah, that explains it..

Thanks Charles

Hi Charles

I get this error..

Invalid object name 'sys.dm_sql_referenced_entities'.

hehehe.. , so far ...I have no idea...

I just like the odd script that is off the beaten track

😛

to expound a bit further...

...one might not use the script it...

I really liked your calendar idea, so I amended it a bit for my use..

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[calendar2print]') AND type in (N'P', N'PC'))

DROP PROCEDURE...

I vote for tabs - less key strokes 🙂

How sure are you that parameter @SurveyCode contains the correct value when calling the SP?

Hi Vinay

What or where is Vch_UserData and Vch2_Shared?