You'd need a self join in this situation but wouldn't it be better to have the region in a separate lookup table? Would be uch simpler to access the...

It's the same as doing a cross join (

SELECT DEkeyValue AS JobNumber, DEentryTypeID, DEenteredDate AS PayDay

FROM Diaryentry cross join workrequest

WHERE WRenteredDate BETWEEN '2005-04-03 00:00:00' AND '2005-05-20 00:00:00'

AND DEentryTYPEID='ENRPAY'

)

You'll need to...

It's not quite true... you can get only 1 value at the time, but you can use datediff to get the hours and then recall it to get the minutes......

I don't know if it's possile to draw shapes in reporting services... but you could always create a jpeg of a circle and then put a picture box on...

HTH.

You have to setup a job that checks periodically for the file arrival, then you can have that job start a dts package.

This could give you the time range to present in the select :

DATEADD(HH, DATEDIFF(HH, 0, TIME_STAMP), 0)

This does a group by on each our of each day... You'll have to either do some gymnastics on the server to get back the hour number into a...

Remove the /24 (in the select and group by)... it's just a mix of 2 ideas.

SELECT CAST(ROUND(SUM(ACCTSESSIONTIME) / 60, 2) AS DECIMAL(18, 2)) AS SessionTime, DATEDIFF(HH, 0, TIME_STAMP) / 24 AS Hour

FROM ACCOUNTING

WHERE...

I can't find anything on yahoo that would lead me to believe that this is possible. Nothing in books online either.

Can you post the statement and what you are trying to accomplish?

I had already came upon that link... but I'm not really the kind of guy to miss work for a movie...

Ya gonna need it... 3 days week-end here.

So it's time to log off now.

Ok... but I preffer being referred as Neo or Luke .