Mary,
Thanks again but now I'm getting the TRANSFORM error.
[quote]SYNTAX ERROR IN TRANSFORM STATEMENT
-Frank...
hobbson
Last Activity: Mar 12 '07, 06:10 PM
Joined: Mar 1 '07
Location:
-
Mary,
Thanks very much for the assistance. When I copied your SQL statement over the existing statement, I got the following error.
Cannot have aggregate function in WHERE clause ((ACTIVE_GRID_L OCATIONS.SITE_C ODE="12h" Or ACTIVE_GRID_LOC ATIONS.SITE_COD E="9h") And DEVICE_SPECS.MF R="sun" And Device.Disposit ion Like "act*" And Count(DEVICE_SP ECS.DEVID)>100) .
Any...Leave a comment:
-
NeoPa,
When I copy your SQL statement over the existing SQL statements for the query I get a "Syntax error in TRANSFORM statement" reply.
Thanks,
-FrankLeave a comment:
-
Crosstab Query and Specifying Selection Criteria
I have a basic crosstab queries that counts the models of each type of server device in a data center. What I'm trying to do is restrict the crosstab query from returning counts for devices that are less than a specifc number....say 100 for exampe.
So I want my query to display server models where there are 101 or more.
Here is SQL statement.
TRANSFORM Count(DEVICE_SP ECS.DEVID) AS CountOfDEVID
...
No activity results to display
Leave a comment: