Return a value from a Function

Expand Post »

Dear all,
Sorry, if this Thread is wrong room

.

I want to return a field value from a table, so I created a function like this :

MS SQL Syntax (Toggle Plain Text)
CREATE FUNCTION dbo.CheckStatusTrx(@TransNo Varchar(20))
RETURNS varchar(20)
AS
BEGIN
   DECLARE @Flag Numeric(1)
   SELECT @Flag = Flag, CreatedBy, ApprovedBy FROM TrxTD WHERE TransNo = @TransNo
   IF @Flag = 2 RETURN 'REJECTED'	   	
END
CREATE FUNCTION dbo.CheckStatusTrx(@TransNo Varchar(20))
RETURNS varchar(20)
AS
BEGIN
   DECLARE @Flag Numeric(1)
   SELECT @Flag = Flag, CreatedBy, ApprovedBy FROM TrxTD WHERE TransNo = @TransNo
   IF @Flag = 2 return 'REJECTED'	   	
END

but, I got this error :

MS SQL Syntax (Toggle Plain Text)
Msg 141, Level 15, State 1, Procedure CheckStatusTrx, Line 6
A SELECT statement that assigns a value TO a variable must NOT be combined WITH data-retrieval operations.
Msg 141, Level 15, State 1, Procedure CheckStatusTrx, Line 6
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Help me, what should I do?

Thanks

Similar Threads

What would you return for a string function? in C++
What's wrong with the return of this function call? in C++
Replacing return() function in PHP
unable to return values from function in c++ in C++
unable to return values from function in c++ in C++

Kusno

Reputation Points: 11

Solved Threads: 17

Junior Poster

Offline

191 posts
since Aug 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Big problem with table

Next Thread in MS SQL Forum Timeline: Import XML to SQL

DaniWeb Message

Cancel Changes

User Name
Password