Friday, June 12, 2015
How to get Monthly Data in Sql Server
year(Addeddate) as [year],left(datename(month,Addeddate),3)as [month],
AmountPaid as Amount
) as s
FOR [month] IN (jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, [dec])
) AS PVTTable
if you have some suggestion, question, request on
How to get Monthly Data in Sql Server.
Please use the comment box to express your views.
Disclaimer: The code samples and API available at www.sourcecodehub.com are available
absolutely free. You are free to use it for commercial as well as non-commercial
use at your own risk, but you cannot use it for posting on blogs or other tutorial
websites similar to www.SourceCodeHub.com without giving reference link to the original
article. All the code samples and API provided by the authors are solely their creation
and neither the author nor the site are responsible if it does not work as intended.