<div>
Is your month column in this string format, or is it a numerical field in the database? Please provide your table definitions if possible, data types are important with these things.
</div>


<div>
It is a date type in sql. On my grid view I just display name of month that is all.
</div>


<div>
what is your data (give a sample), and what you need as a result (also post it here)
</div>


<div>
declare @now smalldatetime<br />
<br />
//set @now = getdate() &nbsp;-- for 2014 ytd<br />
<br />
set @now = dateadd(yy,-1,getdate()) &nbsp;--for 2013 ytd<br />
<br />
select @now, dateadd(yy, DATEDIFF(yy, 0, @now), 0)<br />
<br />
SELECT SUM(sales) FROM SalesTable <br />
WHERE salesdate BETWEEN dateadd(yy, DATEDIFF(yy, 0, @now), 0) AND @now<br />
<br />
HTH.<br />
<br />
(refer: <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c589041e-8971-4f64-93bc-ac370f14b2c0/year-to-date-quarter-to-date-and-months-to-date-sum-in-single-query?forum=transactsql" rel="ugc nofollow">https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c589041e-8971-4f64-93bc-ac370f14b2c0/year-to-date-quarter-to-date-and-months-to-date-sum-in-single-query?forum=transactsql</a>)
</div>


<div>
<div class="content wysiwyg-content">
How can I find out Year to Date of Quantiy and SalesTotal in SQL for current year and 2013? I am a sample below . <br />
It should returns like <br />
<br />
YTD, YTD of 2013, YTD 2014 VS YTD 2013<br />
<br />
<br />
Data sample<br />
Sales &amp;&nbsp;quantity for 2013<br />
<br />
Month &nbsp;Quantity &nbsp; Sales<br />
Jan &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $100 <br />
Feb &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$2000<br />
Mar &nbsp; &nbsp; &nbsp; &nbsp; 15 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $1500<br />
etc...<br />
<br />
Sales &amp;&nbsp;quantity for 2014<br />
<br />
Month &nbsp;Quantity &nbsp; Sales<br />
Jan &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $200 <br />
Feb &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$400<br />
Mar &nbsp; &nbsp; &nbsp; &nbsp; 30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $600<br />
etc... up to today's date (Nov 13, 2014)
</div>
</div>


How can I find out Year to Date of Quantiy and SalesTotal in SQL for current year and 2013? I am a sample below . 
It should returns like 

YTD, YTD of 2013, YTD 2014 VS YTD 2013


Data sample
Sales & quantity for 2013

Month  Quantity   Sales
Jan             5           $100 
Feb          20          $2000
Mar         15           $1500
etc...

Sales & quantity for 2014

Month  Quantity   Sales
Jan          10           $200 
Feb          20          $400
Mar         30           $600
etc... up to today's date (Nov 13, 2014)

Find YTD

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.