sql server - getting error while RETURN two statement - sql function -

sql server - getting error while RETURN two statement - sql function -

alter function [dbo].[udf_getexpensedetails](@empid nvarchar(50)) returns nvarchar(max) begin declare @expamount nvarchar(max) declare @expname nvarchar(max) if (@empid <> '') begin select distinct @expamount = se.expenseamount, @expname = me.expensename tbl_admin_supplierempexpense se, tbl_master_expense me se.empid = @empid , se.expensename = me.expenseid , se.status = 'p' end homecoming @expamount,@expname end

error : wrong syntax near ','.

you can not homecoming more 1 values function. if want multiple values, create table-valued function.

see here http://technet.microsoft.com/en-us/library/ms191165.aspx , illustration included

sql sql-server function stored-procedures