patrick.palmer (3/25/2013)
The filed has multiple dates in it. The 20050307 was just an example. Now all the dates say 2005-03-07???
The following was showing you a way to convert a date represented as an integer into a date:
-- SQL Server 2008 answer:
declare @MyDate int = 20050307;
select cast(cast(@MyDate as varchar(8)) as date);
It was up to you to figure out how to use it in your query.