SELECT datename(DAY,trandate) as Months,SUM(TOTALMARGIN) AS TOTALMARGIN,SUM(AVAILABLEMARGIN) AS TOTAVLBMARG INTO #DAYWISECLIENTMARGIN FROM tableA WHERE TRANDATE BETWEEN 'apr 1 2012' AND 'APR 30 2012 23:59' group by datename(DAY,trandate) ORDER BY datename(DAY,trandate)
date TOTALMARGIN TOTAVLBMARG 1 100000 10000 2 2000 30000
date month year totalmargin totalavlbal
SELECT DATEPART(year, getdate()), DATEPART(month, getdate()), DATEPART(day, getdate());
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)