Viewing 15 posts - 946 through 960 (of 3,221 total)
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...
October 10, 2011 at 7:12 am
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...
October 9, 2011 at 4:45 pm
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 ...
October 9, 2011 at 2:13 pm
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,...
October 7, 2011 at 6:51 pm
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...
October 7, 2011 at 6:19 pm
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...
October 7, 2011 at 1:02 pm
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
October 7, 2011 at 10:31 am
honza.mf (10/7/2011)
bitbucket-25253 (10/6/2011)
And better yet, no one whining and whimpering about "gimme my points".Don't you miss it? And even no complaints on wording and explanation. :hehe:
...
October 7, 2011 at 6:28 am
SQLRNNR (10/6/2011)
So far so good - everybody has answered correctly thus far. 6/6
And better yet, no one whining and whimpering about "gimme my points". So far a nice...
October 6, 2011 at 9:10 pm
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...
October 6, 2011 at 7:50 pm
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...
October 5, 2011 at 7:56 pm
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...
October 5, 2011 at 5:40 pm
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...
October 5, 2011 at 5:25 pm
Viewing 15 posts - 946 through 960 (of 3,221 total)