select 
   cast (
      cast(Table1.[Year] as varchar(4))
      + left('0'+cast(Table1.[Month] as varchar(2)),2)
      + case 
        when patindex('%[^0-9]%',left(ltrim(Table2.[Desc]),6)) = 0 and len(Table2.[Desc]) >= 6 
            then substring( ltrim(Table2.[Desc]), 3,2 ) 
      end
   as datetime)
from
   Table1 inner join Table2 
      on Table1.JoinColumn = Table2.JoinColumn   

quote:

---

Originally posted by sunitabeck

When you want to pick data from two tables, you need something to relate the two tables to one another. If you have such a join column that you can use, then may be this is what you are looking for? I called the join colum as "JoinColumn" in my example below:

select 
   cast (
      cast(Table1.[Year] as varchar(4))
      + left('0'+cast(Table1.[Month] as varchar(2)),2)
      + case 
        when patindex('%[^0-9]%',left(ltrim(Table2.[Desc]),6)) = 0 and len(Table2.[Desc]) >= 6 
            then substring( ltrim(Table2.[Desc]), 3,2 ) 
      end
   as datetime)
from
   Table1 inner join Table2 
      on Table1.JoinColumn = Table2.JoinColumn   

---

quote:

---

Originally posted by DonAtWork

Does table 2 have the actual whole date you are looking for, but in varchar? Asking because that is what you example shows. If so, just convert the item in table 2 to a date (checking if it would be valid of course).

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

---