oh k thkz jack so its not that easy to do that ...k thkz a lot

can i know what is checksum what does it do i tried in msdn but i couldnt understand the exact us of that i tried some examples but i didnt...

thkz miller ...got it

but lowell i havea ques

select cast (39504.5023 as datetime) as abc ,getdate() todaydate

abc ...

thkz lowell gotch u ....n thkz to all of them...

declare @dt datetime

set @dt = '1900-01-1 00:00:00.000'

select cast(@dt as float)

----------------------

0.105555555555556

(1 row(s) affected)

here how is the time calculate is it seconds of the day or...

but whats the logic is it the number of days from 1990 yr is that the one i jus want to know that logic ....

thkz but did it works how abt time is it the same way is it in second of the day or what format is that ???

i believe u can have mutliple destinations from source ...one to success dest and the other to failure dest ifrom source redirect all the failure rows to failure dest...

when i jus click modify on my column and change the datatype to datetime it says

- Warning: Data might be lost converting column 'Invoice Date' from 'nvarchar(50)

i tried...

the datatype in the table for my column is nvarchar(50)...so how would i convert it to datatimestamp or that format of output

i have already imported the data so how can i jus make changes now thats what i want bcoz i have struggled to inser the data so i dnt want...

thkz a lot to everyone i made it atlast by all of ur help....but i got the date in Mar 13 2000 12:00AM format but i need to update it...

actually i need to do some transformations to a column and insert that i coudlnt do that so i did some transformations separately i inserted into new table so i...

let me make it clear i had imported the data into sql server table 'nydrive' which has the invoice date as 100083 format now how should i convert all...