there are 2 tables .
dbo.SIS_Data and dbo.Venkata.
the fields are
dbo.SIS_Data: dbo.Venkata
SID SID
Fname Fname
MI MI
Lastname Lastname
DOB (declared in datetime) DOB(declared in nvarchar(50))

I am working with sql server 2005.
I need to insert the values of dbo.Venkata into dbo.SIS_Data.
but dob has different data type.
we need to use the convert or cast function.the format of dob in dbo.Venkata is ddmmyyyy and we need to change the format to yyyymmdd in order to insert it into dbo.SIS_Data.

so please help me ot withe the query.