CODEWITHSUNDEEP
sqlsql-servert-sqlreporting-services
choloboy
choloboy

Reputation: 815

Input parameter for report in SQL

WHERE      ((100 * FreeSpace / Capacity) <= 20),               -- error on this comma
           SystemName = @p_ServerName

Does anyone know what could cause the error? And if the code is the right way to do what I am trying to accomplish?

Upvotes: 1

Views: 31

Answers (1)

Tommy Ivarsson
Tommy Ivarsson

Reputation: 605

Shouldn't the comma be an AND?

WHERE ((100 * FreeSpace / Capacity) <= 20) AND SystemName = @p_ServerName

Upvotes: 1

Related Questions