Viewing 15 posts - 17,671 through 17,685 (of 18,926 total)
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...
May 25, 2005 at 7:02 am
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...
May 25, 2005 at 6:47 am
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......
May 25, 2005 at 6:36 am
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...
May 24, 2005 at 2:42 pm
You have to setup a job that checks periodically for the file arrival, then you can have that job start a dts package.
May 24, 2005 at 12:58 pm
This could give you the time range to present in the select :
DATEADD(HH, DATEDIFF(HH, 0, TIME_STAMP), 0)
May 24, 2005 at 12:57 pm
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...
May 24, 2005 at 12:54 pm
Remove the /24 (in the select and group by)... it's just a mix of 2 ideas.
May 24, 2005 at 12:52 pm
SELECT CAST(ROUND(SUM(ACCTSESSIONTIME) / 60, 2) AS DECIMAL(18, 2)) AS SessionTime, DATEDIFF(HH, 0, TIME_STAMP) / 24 AS Hour
FROM ACCOUNTING
WHERE...
May 24, 2005 at 12:31 pm
I can't find anything on yahoo that would lead me to believe that this is possible. Nothing in books online either.
May 24, 2005 at 7:59 am
Can you post the statement and what you are trying to accomplish?
May 24, 2005 at 7:42 am
I had already came upon that link... but I'm not really the kind of guy to miss work for a movie...
May 21, 2005 at 8:35 am
Ya gonna need it... 3 days week-end here.
So it's time to log off now.
May 20, 2005 at 2:20 pm
Viewing 15 posts - 17,671 through 17,685 (of 18,926 total)