The valua is FLOAT of the column

ChrisM@Work (5/21/2013)

---

What are typical values for SUM(nUsed_Min) and SUM(nSize)?

Your query is easier to read if table aliases are used:

SELECT TOP 10

d.nDeviceID,

d.sDisplayName,

sgroupname,

sDescription,

dPollTime,

MIN(nUsed_Min) AS Min_use,

MAX(nused_Max)...

These colmn most be shorter:

MIN(nUsed_Min) AS Minimaal_gebruik,

MAX(nused_Max) AS Maximaal_gebruik,

SUM(nSize) AS Totaal_Schijfruimte,

Can you tell me what you mean with your anwser? (Make a SQL syntax plz)

TNX A LOT it works 🙂

Up to my next Qeustion 🙂

No it dont help. Its say the follwoing thing:

Msg 1035, Level 15, State 10, Line 28

Incorrect syntax near 'CAST', expected 'AS'.

He aspect a AS () something.

When i use that it...

I get this error first:

Msg 102, Level 15, State 1, Line 28

Incorrect syntax near '>'.

With the syntax of yours.

The I fix it with this syntax:

(CAST(SUM(nUsed_Min) AS FLOAT(2)) / CAST(SUM(nSize) AS...