<div>
<div class="content wysiwyg-content">
Given the following table:<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PERIOD &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATA1<br />
A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20070901 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25<br />
B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20060501 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;77<br />
C &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20071001 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;35<br />
D &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20070901 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;24<br />
E &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20071001 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12<br />
F &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;20070930 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;84<br />
How can I convert PERIOD to its date format, and determine how many days it is from today's date?<br />
<br />
Desired results would be similar to:<br />
ID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DAYS &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DATA1<br />
A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;43 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25<br />
B &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;531 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;77<br />
C &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;35<br />
D &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;43 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;24<br />
E &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;13 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12<br />
F &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;84<br />

</div>
</div>


Given the following table:
ID	PERIOD	DATA1
A	20070901	25
B	20060501	77
C	20071001	35
D	20070901	24
E	20071001	12
F	20070930	84
How can I convert PERIOD to its date format, and determine how many days it is from today's date?

Desired results would be similar to:
ID	DAYS	DATA1
A	43	25
B	531	77
C	13	35
D	43	24
E	13	12
F	14	84


Convert char to date and subtract from today's date

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.