Smalldatetime

Nice indeed J

It´s better now, however date1 and date2, can also be on Sundays and Saturdays…

Thanks Ken !

Ok. Thanks!

I have identified the origin of the error, it’s when for example I have an hour like ‘9:53’ instead of ’09:53’  I think  the datediff...

Ok , i have corrected the char(12) , nerveless I still get the same error

I agree with you it must be a problematic...

Ok i found the problem, now it works :

select  cliente, processo, cdu_slaok from processos where dataabertura >='2006-01-01' and

cdu_fechado='1' and

--cliente=any

--cliente exists

cliente in

(

SELECT cliente

FROM

 processos where cdu_fechado='1'and dataabertura >='2006-01-01'and

cliente not in...

Great. The statement works just fine.

Now I want to use the result of this query as an input to select certain rows ..a subquery….

Result of

SELECT SERVERPROPERTY('productlevel'),

SERVERPROPERTY('productversion'),

SERVERPROPERTY('edition')

SP4 8.00.2039 Enterprise Edition

SELECT cliente, COUNT(cdu_slaok) AS Total , SUM(CASE WHEN cdu_slaok = '1' THEN 1 ELSE 0 END) AS SLA_OK,

CAST(SUM(CASE WHEN cdu_slaok = '1' THEN 1 ELSE 0 END)AS DECIMAL)*100 /...

SELECT cliente, COUNT(cdu_slaok) AS Total , SUM(CASE WHEN cdu_slaok = '1' THEN 1 ELSE 0 END) AS SLA_OK,

CAST(SUM(CASE WHEN cdu_slaok = '1' THEN 1 ELSE 0 END)AS DECIMAL)*100 /...

Changed the last column to "PERC", but is still get the message:

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name 'PERC'.

Server: Msg 207, Level 16, State 1, Line...

And if i want to compare the value for total , for example total > 80 ?

If i do so i get an error... it...

Yes. Thanks!

same problem

i get .0