var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can I GROUP BY aggregate Function (Like SUM)
I column that calculated at run time in insert , can i gruop by this column,the new one that not exist yet
yes, with a derived table, but why would you want to?
please show an example, using sample data to illustrate
this is my case:
i have a table with a column datetime (I use to record time of calls) , i want to create table that hold data for each hour, so i round the column and want to group by this column in the same time
you can round a datetime? please show your query
This is the Query of round datetime
You can change [hour] to day , minutes , second , etc...
DATEADD(Hour, DATEDIFF(Hour, 0, cdrCallDate), 0)
yes, you can GROUP BY that expression
and you cannot use second, it causes an overflow
thanks man for this information