Sql function to get the max value from @temp table

Question

Hi, Need to build one function by pass parameters and create one temp temp inside that to store fetched values and finally return the max of column values from that temp table as output EX: fn_test (@P1,@P2) declare @temp (val 1, val 2) insert into @temp (1,2) insert into @temp (3,4) select max(val1) from @temp -- as output and return Thanks Sathish

Puneet Kankar · Answer

Please check below link select max (Col1), min (Col2), MAX (Col3), MIN (Col4) from YourTable https://www.sqlservercentral.com/Forums/1244655/Selecting-Max-and-Min-Rows-in-one-SQL-Statement

sathish · Answer

Here how to select max and min DOB as return value

Puneet Kankar · Answer

Use table value function like given below. https://blog.sqlauthority.com/2011/08/26/sql-server-tips-from-the-sql-joes-2-pros-development-series-table-valued-functions-day-26-of-35/ https://logicalread.com/sql-server-table-valued-functions-mc03/ CREATE FUNCTION GetBornBetween ( @YearAfter AS DATETIME, @YearBefore AS DATETIME ) RETURNS @People TABLE ( Name VARCHAR ( MAX ), Gender VARCHAR ( MAX ), DOB DATETIME, Job VARCHAR (10) ) AS BEGIN INSERT INTO @People SELECT name , gender, DOB, 'teacher' FROM teacher WHERE DOB BETWEEN @YearAfter AND @YearBefore RETURN END

sathish · Answer

Thanks Kankar .. But incase I need the return output with 4 values like max(val1),min(val1),max(val2),min(val2) ... how to be proceed

Puneet Kankar · Answer

CREATE FUNCTION fnven_info (@YourNumber1 int , @YourNumber2 int ) RETURNS varchar(15) BEGIN DECLARE @temp TABLE ( YourNumber int ) insert into @temp(YourNumber) values( '1' ) insert into @temp(YourNumber) values( '2' ) RETURN (select max(YourNumber)from @temp) END --call function --select dbo.fnven_info(1,2) Try above code.