Mabe this will help :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=285646

I'm not sure I'm following here.  Don't you want to save the output FROM the exec statement in @StrCnt?  AFAIK this takes an output parameter that doesn't seem to be...

Nothing else (for the command).  For the input/output parameters you can also use numeric datatypes.

None that I know off.  I already did this in a dts but it was basically the same code as above.  This code basically writes all the select statements you...

search this site for sp_executesql and output parameters. You should find what you need.  The one draw back is that you have to use nvarchar which limits you to 4000...

Please not that this search only for columns which contain text.  You'll have to change the first query (systypes table) to allow to search for number columns..

This is how I do it FROM VB 6.

Private Sub SearchAllTextColumns(ByVal sDbName As String, ByVal sFind As String)

On Error GoTo Gestion:

    Dim MyRsCols As ADODB.Recordset

    Dim MyRsCount As ADODB.Recordset

    Dim...

And it shouldn't work that way either.  I'd strongly suggest you read the 3 articles when you get a few hours of free time.  However to solve that particular solution...

Something's not adding up here.  If you can make the print statement execute [without altereations] then it should also work in the EXECUTE().

What do you mean exactly by putting the...

Then going in the shows table and set the right code in there.  Then the data will be correct and the view will show the good results.

The description of the show is wrong for a single show.  Or the description is always wrong (for any show)?

How many distinct groups of columns can be selected from this table?

I can't remote debug this from you.  But I can tell you how I'd do it :

Replace the EXECUTE (@StrSQL) statement to

PRINT @StrSQL

Then copy / paste the results from the message...

I'd strongly suggest you rethink the design.  This query is supposed to be very simple!!

The error is too severe to be trapped.  As soon as the error is found, the execution is stopped, the error is sent to the caller and that's the end...