I got it. We have KeyWord "@@NESTLEVEL" to find out the level of the Procedure.

For Exapmle:

CREATE PROCEDURE innerproc as

select @@NESTLEVEL AS 'Inner Level'

GO

CREATE PROCEDURE outerproc as...

Jeff,

Quater means QUARTER in given DATEPART. Hope you understood me.

To the extension of the above, How to get, to Which Quarter the  above Range Belong to in the same date Range i.e, '01/01/2006' AND '10/02/2007' ?

0 -90      1st Qauter

91...

Thanks for your Valuble time and Help Christopher, Jeff Moden and Farrell Keough.

I tried the Query I got it.

The Query is

declare @num1 int

declare @num2 int

set @num1 = 1

set @num2 = 1

select (case when @num1 > @num2 then @num1 else @num2 end)

Yes I got it.Thanks for taking time to reply......

Can we Write a Query to find the Max Number of two given numbers?  If so please help me

Thanks for your Reply Veeresh. It's working fine

Thanks for ur Relpy.

it's related to our Business so the Code should not be revealed. Can you give me a detailed explination about proc?