Can be FIXED when surrounded with BEGIN..END statements: -

for e.g., my procedure name in Oracle is dp_tfr, then I will write like below: -

BEGIN

dp_tfr;

END;

below methods will...

HI James,:-)

select dbo.greatest_('1099,1,2,3,9,10') greatest

surprisingly the Result is 9

However logically the return value should be 1099.

even for below results are surprise

select dbo.greatest_('1199,989') greatest, dbo.greatest_('1199,9') greatest1

result should be 1199,119 however returned...

Below two functions are very Similar to least and greatest functions in oracle.

1. SQL Code for least: -

GO

/****** Object: UserDefinedFunction [dbo].[least] Script Date: 08/23/2012 00:53:38 ******/

/*Author:...