Hi Bradley Jacques,

Yes, this works. Thank you.

Cheers

Linus

Hi Bradley Jacques,

Thanks for assisting me.

I need to take report on project allocation for the last 10 months from the current month. So, for each of the last 10 months,...

Also,

If I need to pupulate a temptable Month, ProjectCount for last 10 months from current month, how can I do.

For Eg : January 10, February 15, March 1, etc.

Thx,

Linus

Go to...

Hi Chris,

u r right & the double quotes created the problem... thx for the help!...

Thx,

Linus

Can anyone help to find the syntax error in this query?

@query = 'select empID from EducationDepartment where DateDiff(hh, checkInTime, getdate()) > 2 and userPriority = 1 and status != "closed"'

Thx,

Linus

Thanks friends, & it worked!