Jeff,

needless to say I had no intention to offend neither you, nor John. 🙂

Thank you very much for your answer, and that is the reason that i keep coming back...

So, thank you both for your concern these are my two approaches..

1) convert (datetime, avg (convert (float, (convert (datetime, [EMPLOYEE_ARRIVAL_TIME]))))) as AVG_ARRIVAL_TIME

2) DATEADD (MI, AVG (CONVERT (DEC(10,2), DATEDIFF(SS, REFERENCE_ARRIVAL_TIME,...

What you suggest is the second approach that i used and this approach produces different results than the first approach. You are right. My question is why is this the...

Lol.. thank you guys. Thank you for your time as well. Of course i have data for the july - august . Ill put a syntax like jason's and then...

guys, 1 of july to 30 of august does not exist as dates for our company when we choose academic year. WE ARE CLOSED! lol. These months do not...

Matt, thank you for your comments. However let me say this

a) if the management tells me the academic year is from 1st of September (2005) till the End of...

o Jason please let me tell you what i want in case i did not made it clear.

Suppose i am a user and run the report with period beeng normal....

Jason,

i do not restrict your query. I run your query as exactly you have given me.

the i have another query just sum of quantity for the year and that centre...

No this does not affect the query, all it does is that it selects the centre. But let me tell you something.

If a perform a sum for revenue_type=22 (just...

Jason hi,

the query you send me,

declare @period nvarchar

declare @centre nvarchar(4)

set @centre='0009'

set @period='A'

SELECT

TC_NUMBER

,REVENUE_TYPE_ID

,CASE

WHEN @period = 'A' AND MONTH(DATE_STAMP)...

Very impressed that you dealed with my problem! thank you very much..

Ill test it and let you know..

Thank you Jason!!!

Hi, your Idea rings a bell. Can you please analyze it a bit?

I would be greatfull! :-). (Nobody can spent the night in)

You all are correct guys. What you are saying it makes perfect sense, but i though i should give it a try in order to find the least possible...

Why zap them automatically with a cattle prod when you can do it manually yourself and get all the joy and excitement? 🙂

Come on mate, I am sure you...

ok, before i begin i suppose that a book can belong to MORE than one category. Otherwise you do not need the books_categorytable. Just add a colum in the books...