Phil:

This got me the desired result:

convert(varchar,left(DATENAME(month,DATEADD(day,cl.Hours/cs.HoursPerDay-1, cs.StartDate)),3),0)

Thanks for taking the time to look at this.

David

Hi Phil:

OK..so I created the user defined function you gave me yesterday in the user defined function section of the db. Then, I inserted:

select dbo.fn_ReturnMonth(datepart(month,getdate())) as Mth

into the...

Hi Nivedita:

Thanks for the post. Where would I find the getdate() function? I don't see it in the stored procedure. Like I said, I am a novice and am probably...

Hi Phil:

Thank you very much for your taking the time to reply. First of all, please understand that I am a novice with sql. I took over this website and...