get multiple return value in stored procedure in sql server -

get multiple return value in stored procedure in sql server -

i have stored procedure this:

alter procedure [dbo].[mobiledevice] @platesourcecnt integer, @platecategory integer begin declare @splatesourcecount integer, @splatecategory integer, @splatecode integer select @splatesourcecount= count(ps.psid)from platesource_tbl ps if @splatesourcecount <> @platesourcecnt begin select psid,ps platesource_tbl deleted=0 end else begin homecoming 1 end select @splatecategory=count(pcat.pcid) platecategory_tbl pcat if @splatecategory <> @platecategory begin select pcid,pc,psid platecategory_tbl deleted=0 end else begin homecoming 2 end

end

here platesource_tbl count 13, if pass value @platesourcecnt =13 getting homecoming value 1 time sec select query not working. if pass other parameter 13 @platesourcecnt getting both working. wrong stored procedure? can multiple homecoming value in 1 stored procedure?

no cannot homecoming 2 times , 1 homecoming take out,

instead utilize select 1 homecoming 1 , select 2 homecoming 2

or declare 2 variables @return1, @return2 @ end of proc select @return1 'return1',@return2 'return2'

sql sql-server stored-procedures