I am sorry, you dint get the full issue, may be i dint explain well, this may help

if the previous quarter is 4, then the year value should be current...

Thank you very much, will some one help me in this..

http://www.sqlservercentral.com/Forums/Topic923666-23-1.aspx

the same problem, but a small change required, please help me in this

Thank you very much..

In my Stored procedure i have written like this

DECLARE @isLockOutPeriod BIT

SELECT CASE

WHEN CAST(@currentDate AS DATETIME) BETWEEN @lockOutStartDate...

Thanks jvanderberg, you have answered part of my question, i need to set my start date and end date evn, by passing month, year, and date. Can you help me...

Thanks, i hope this will work, before give a try can u help to add a small thing, is that possible to generate the start date and end date dynamically...

Thank you very much, it works now

Can we add a small change to this query, so that i will be able to get year also. The logic is like if...

I am sorry, i dint think in that way

Here goes my code explanation

These two lines creates a normal date from the specification of

new GregorianCalendar(year, month, day of month). so...

Please some one help me in this regard fast..

Thank you very much

Thanks, very much it worked.. and also if it is in different server, do i need to add some more param?

Thanks it works for the date '1 jan 2010', it gives me quarter 4. But whne i give 1 dec 2010, it still gives me 4, which is suppose to...

Thanks once again Sunitha, it works, need small change

The first query works as expected, but the second query, i expect the previous quarter value

the below one has to give "4",...

Thanks Sunitha,

Before trying this query, i have some doubt, currdate is hard coded? is that not possible to get the system current date?

And also i found some hardcoding of 2010...

I have written like this in my procedure

ALTER PROCEDURE [dbo].[O2_SERVICES]

-- Add the parameters for the stored procedure here

-- Input Parameters

@msisdn VARCHAR(255),

-- Output Parameters

@lastQuartRewardState VARCHAR(255) OUTPUT

AS

BEGIN

-- SET NOCOUNT ON...

Actually i am writing a stored procedure, so i expect it to return a String from it..

Thats why