Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jromero63

    Store Proc where parameter is SELECT column

    Terry, that did the trick! Thank you all very much for your guidance and support! Kudos to this awesome site!
  2. jromero63

    Store Proc where parameter is SELECT column

    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...
  3. jromero63

    Output in local variable from dyanamic sql execution in sqlserver 2000

    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...
  4. jromero63

    Store Proc where parameter is SELECT column

    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)...
  5. jromero63

    Store Proc where parameter is SELECT column

    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...

Part and Inventory Search

Back
Top