vidya-391318 | SQLServerCentral

vidya-391318

Forum Replies Created

Viewing 7 posts - 1 through 8 (of 8 total)

RE: query to get time periods

ok... i think i got it...
thanks a lot for your help....

June 8, 2007 at 1:28 pm

#711789
RE: query to get time periods

thanks... for the help,...
i also need to get the total count for a day
and the max and mean wait times
MAX
(DATEDIFF(SECOND

June 8, 2007 at 1:14 pm

#711787

RE: query to get time periods

i want to do something like this...but for a date... i want 1 record

select

CONVERT(VARCHAR(10),...

June 8, 2007 at 12:55 pm

RE: query to get time periods

suppose... in the table... for 01/01/2007 there are 50 records

and the time taken to process is the difference between dteNative and dteDocProcess

so i want to display data based on the...

June 8, 2007 at 12:34 pm

RE: why does this return different count

thanks for the quick reply

but this is my question

this is the query i have on my older version of SQL

select count(*)

from nameaddr_ac addr,...

April 11, 2007 at 4:47 pm

RE: help needed in query....

thanks everybody

April 11, 2007 at 3:29 pm

RE: help needed in query....

comments is not a column,... i just added it just for the sake of explanation

thanks

April 6, 2007 at 11:34 am

Viewing 7 posts - 1 through 8 (of 8 total)