Shykin Novice
Joined: 06 Aug 2012 Posts: 1
|
Posted: Mon Aug 06, 2012 9:09 pm Post subject: Query Builder not placing Virtual Attributes into GROUP BY |
|
|
I'm working on making a query like this using:
SELECT country, COUNT(DATE), COUNT(DATE2), CAST(DATEPART(yyyy, DATE) + CAST(DATEPART(mm, DATE) AS VARCHAR)
FROM TABLE
INNER JOIN TABLE2 ON TABLE.PK = TABLE2.PK
GROUP BY country, CAST(REST OF THE STUFF)
However the easy query keeps forgetting to put that CAST into the group by. Is there anything I'm doing wrong or any suggestions as to why it wouldn't put that custom field into the group by clause. Does it have the ability to figure that out? |
|