on 05-24-2017 3:25 PM
Dear Experts ,
I am using odbc connection in report , Just i want to change the date time column value in "YYYYMM" format and count the no of record . I am using below query in command , where i am getting error "Unsupported scalar function" . Please suggest .
select count(CONVERT(VARCHAR(6), closed_at, 112)) as monthyearcount, CONVERT(VARCHAR(6), closed_at, 112) as monthyear from change_request group by CONVERT(VARCHAR(6), closed_at, 112)
You don't have a "From" table in the command. How is it supposed to know where to get the data from?
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.