Can someone tell me why this is not executing properly. No error
 messages, just no rows returned. I need to have an output parameter
 and a return value.
 Thanks in advance
 Julie Barnet
 CREATE PROCEDURE dbo.sel_LookupChar
 (
 @.Lookup_Value NVarChar(30),
 @.Lookup_Field NVarChar(30),
 @.Lookup_Table NVarChar(30),
 @.MyOutput nVarChar(100) OUTPUT
 )
 AS
 Declare @.SqlStr VarChar(1000)
 Select @.SqlStr = "Select " + @.MyOutput + " = " + @.Lookup_Field + "
 From " + @.Lookup_Table + " Where " + @.Lookup_Field
 Select @.SqlStr = @.SqlStr + " = '" + @.Lookup_Value + "'"
 Exec(@.SqlStr)
 return @.@.rowcount
 GOUse ' not " for string delimiters.
Also, try PRINT @.SqlStr instead of EXEC, and show us the result.
"Julie Barnet" <barnetj@.pr.fraserpapers.com> wrote in message
news:438e1811.0308270858.4563cc29@.posting.google.com...
> Can someone tell me why this is not executing properly. No error
> messages, just no rows returned. I need to have an output parameter
> and a return value.
> Thanks in advance
> Julie Barnet
> CREATE PROCEDURE dbo.sel_LookupChar
> (
> @.Lookup_Value NVarChar(30),
> @.Lookup_Field NVarChar(30),
> @.Lookup_Table NVarChar(30),
> @.MyOutput nVarChar(100) OUTPUT
> )
> AS
> Declare @.SqlStr VarChar(1000)
> Select @.SqlStr = "Select " + @.MyOutput + " = " + @.Lookup_Field + "
> From " + @.Lookup_Table + " Where " + @.Lookup_Field
> Select @.SqlStr = @.SqlStr + " = '" + @.Lookup_Value + "'"
>
> Exec(@.SqlStr)
> return @.@.rowcount
> GO
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment