<div>
<div class="content wysiwyg-content">
I have two columns DATEUNIT and NUMOFDATE 
 
The data shown in these columns varies, example 
DATEUNIT &nbsp; &nbsp; &nbsp; &nbsp; NUMOFDATE 
W &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 
M &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 
Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 
 
W = Weekly 
M = Monthly 
Y = Yearly 
 
I would like to have all the data shown in Weeks 
I am looking for a query that I can run in the SQL Sever that will change the NUMOFDATE values to weeks dependant upon the current DATEUNIT 
ie where is shows 1 year to 52 week, 2 years to 104 weeks 
 
So the example above would show 
DATEUNIT &nbsp; &nbsp; &nbsp; &nbsp; NUMOFDATE 
W &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 
W &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13 
W &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;52 
 
Gordon
</div>
</div>

I have two columns DATEUNIT and NUMOFDATE

The data shown in these columns varies, example
DATEUNIT         NUMOFDATE
W                        4
M                        3
Y                          1

W = Weekly
M = Monthly
Y = Yearly

I would like to have all the data shown in Weeks
I am looking for a query that I can run in the SQL Sever that will change the NUMOFDATE values to weeks dependant upon the current DATEUNIT
ie where is shows 1 year to 52 week, 2 years to 104 weeks

So the example above would show
DATEUNIT         NUMOFDATE
W                        4
W                        13
W                        52

Gordon

SQL Sever Query

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.