One thing more- I want to create a third column with the result of the expression cdu_SLA_OK/Total

SELECT COUNT(cdu_slaok) AS Total , SUM(CASE WHEN cdu_slaok...

ok i made on adapation and it worked fine.

Tkanks a lot!

Hi,

Ok, assume it´s not a boolean ...

i just wanto to count one set if A='X' and the total set

No, I dont want to sum  want to COUNT, the type is char   ‘0’ ‘1’ ‘A’…

Hummm,

I’m sorry I didn’t understand the cast part. Why convert the type ?

I just want to select the total...

Hi,

The error is:

insert into aks_le2.dbo.artigos

select * from aks_le.dbo.artigos where numartigo='1900'

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'aks_le2.dbo.artigos'.

Hi David,

Thanks for the Tip.

I'm running the following query:

select

SUBSTRING(texto,CHARINDEX('src="',texto,CHARINDEX('<IMG',texto))+5,

 CHARINDEX('"',texto,CHARINDEX('src="',texto,CHARINDEX('<IMG',texto))+5)-

 CHARINDEX('src="',texto,CHARINDEX('<IMG',texto))-5)

from artigos

where texto like '%img%'

She returning 236 rows , but ends with an error:

(236 row(s) affected)

Server: Msg 536,...

Ok, i understand J

Mike,

Here are the results DBCC SQLPERF(LOGSPACE) :

DB name           Log size...

Thanks for you replies.

I have ran the update usage command and now the values are as folows:

Thanks for your replies.

Bill,

Should i use DBCC SHRINKFILE with the TRUNCATEONLY argument to release...