Does logic from the last response not point this out to you? I'm guessing: -

) + ' )'

I got this right by process of elimination. . . I thought it'd fail so decided to go with "it depends" :hehe:

If "error" had been an option, I'd have got...

Ah! Now I understand what you wanted! :hehe:

DECLARE @isLockOutPeriod BIT

SET @isLockOutPeriod = CASE

...

DECLARE @theDate VARCHAR(50)

DECLARE @startDate VARCHAR(50)

DECLARE @endDate VARCHAR(50)

DECLARE @month VARCHAR(15)

DECLARE @day INTEGER

DECLARE @year INTEGER

--Get the current date

SET @theDate=getDate()

--Set the month, day and year for the start

SET @month='January'

SET @day='1'

SET @year='2009'

--Set the startdate

SET...

Not sure I fully understand your requirement.

Are we trying to grab the year of the previous quarter? If so: -

SELECT CASE

...

Assuming I've understood you. . . this should be OK.

DECLARE @theDate VARCHAR(50)

DECLARE @startDate VARCHAR(50)

DECLARE @endDate VARCHAR(50)

SET @theDate='1 jan 2010'

SET @startDate='31 dec 2007'

SET @endDate='1 jan 2009'

SELECT CASE

...

Since this is a SQL forum. . . how about you post what the code is meant to do rather than just posting code. That way someone might decide to...

There will be a much better way of doing this than how I've done it. . . but this works

SELECT CASE

WHEN...

Ummm, the code you were given does what you asked for.

(cleaned up below)

--Create test data

DECLARE @CurDate VARCHAR(25)

SET @CurDate='1 jan 2010'

DECLARE @QuarterDefinition TABLE(

quarterid ...

Not a bad guide here.

--EDIT-- The more I look at your code, the more it looks right. Just tested it on my server and got the expected answer. So I suspect, the error...

Just so I understand. . . run this and tell me if it gives you the result you'd expect.

DECLARE @testtable1 TABLE(

id ...

PaulB-TheOneAndOnly (5/14/2010)

One way to do it reusing your code? How about derived tables? use your two queries as derived...

I'll just show the timesheets off. . . took me two days to work through all of the changes last time and that was a smaller project than this one.

Once I've gone over the scripts created, I'll be speaking to the boss about how much time it saved. . . fairly sure that the time saved equals far more...