I am migrating my postgres database to MS SQL Server 2005. I had some sql queries that used for reporting module in my application.
These queries contains fields of data type "interval" in postgres. Also it has sum and avg aggregate functions on these fields.
I searched for equivalent functionality in MS SQL Server 2005. But it seems that aggregate functions like sum and avg in MS SQL Server 2005 works either with int, float,decimal,money and not with datetime rather time.
I would like to know how can I do this. Also is there any equivalent function to justify_hours in postgres
Thanks in advance. Any help appreciated.
View Complete Post