After correcting the obvious errors in your code as posted to:

create procedure GetReport 999

@SpoolID int

AS

declare @sql nvarchar(4000)

select @sql = 'select extrasql from reportspool where spoolid='+CONVERT(VARCHAR,@SpoolID)

print @sql

--exec (@sql)

Executing...

Your welcome.

Now if that is value passed to your SP, so be it. If it comes from a column in a data set, I would suggest that you develop...

First of all, for now and future use get yourself a copy of the Microsoft ASCII character set.

http://msdn.Microsoft.com/en-us/library/4z4t9ed1(v=vs.71).aspx

Note that the following are non displaying characters:

ASCII

Value ...

To help those who want to help you with a tested solution, please, please post the table definition, sample data both in a easily consumable manner. To do so,...

Besides all the other good suggestions you have gotten, I find the following to be useful in deflecting a specific salary.

It is not wages alone that counts, it a combination...

To get a tested answer, please post your tale definition, some sample data and required results. To do this in a readily consumable manner pleas click on the first...

Try read this:

http://technet.microsoft.com/en-us/library/bb510625.aspx

It gives an example of the code required to basically perform a merge without using the MERGE statement. It might assist you

...

And better yet, no one whining and whimpering about "gimme my points". So far a nice...

NIce question to end the week ...

You might read this blog posting by Kimberly Tripp, it may be very useful for you. It also contains some T-sQL code that could be used as you...

Nice straight forward question

For those of us in the IT world, today is a sad day. Apple announced at 8:51 PM that Steve Jobs passed away as a result of loosing his...

If you would post your table definitions, sample data in a readily consumable format, you increase the chance of someone assisting you with a tested answer.

To do as...

Now this will do what you say you need, BUT note that it will NOT correctly handle

1. Line numbers greater that a single digit

2. Purchase...