Thank you for all of your guidance and examples on using sp_executesql. I've applied the changes as detailed below and I do get a resultset back. However, I can NOT execute any other commands after my call to EXEC sp_executesql. Am I missing something?
ALTER PROCEDURE sp_JLR
@Period_ID...
Thank you for all of your guidance and examples on using sp_executesql. I've applied the changes as detailed below and I do get a resultset back. However, I can NOT execute any other commands after my call to EXEC sp_executesql. Am I missing something?
ALTER PROCEDURE sp_JLR
@Period_ID...
Hi SQLBill,
Thanks for getting back to me as soon as you did.
Your assumptions are correct. The data stored in the field that I am querying is NUMERIC(25,15). @SQLCommand is a VARCHAR containing my built SQL string command.
I've even tried the following:
DECLARE @SQLCommand2 varchar(200)...
Hi all,
I've been having a hard time writing a store procedure in MS-SQL 2000 and was wondering if I am going about it all wrong.
In all store procs that I've seen that take parameters, these parameters are commonly used as values for i.e. a SELECT WHERE clause. In my case, one of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.