No there will be so many dates in this way but ishall query jus past 7 days data...

Hey phil....its not like we are not using the 5th column ....we shall change the schema in the destination with 5th column ..but before that it at all the...

okay even thought i have select * from tbl1 .....it should not fail right ...correct me if i am wrong....

for example ...

i have atable tbl1

step1

col1,col2,col3,col4---oracle source

query select...

yeah got it...

hansi really good stuff ...thkz bro

Thanks Gardain for ur reply i dont have access now i shall check it out tomm and let u know...

but i have a doubt this query would make the total...

jeff i have another issue could u help me out with that ....

http://www.sqlservercentral.com/Forums/Topic593360-338-1.aspx

Thanks is advance

Grabber i tried that way... it did not work for me ....anyway i got that resolved by jeff post...

Thanks Jeff first sol works well......

jeffrey...

if i consider 112 and take char(6) then io shall get 200810 i mean yyyymm

but i need to order by date....will i get that ...

create table #abc

(

id int,

date datetime,

status

)

insert into...

Thanks evryone ....and THANKS Gail i got it now...

adi i tried that but u know what its not showing up 000609876159 in not like but its totally numeric.....

hey adi..

when i ran this query with like even i got '000609876159' which should be in not like

select Col1

from YourTable

where YourCol not like...

hi evryone...

now it makes me more confusing than before....

select isnumeric('3edf2') when i tried this it showing as 0 ...wats the reason for this...why is isnumeric('3d2') showing as 1...plz do...

Jeff...thkz for the response could plz clarify this....

so how should i consider it .....

select isnumeric(order_number+'.do') from tbl1..

is this the syntax...

i dont understand this query

SELECT ISNUMERIC('3D2'+'.d0'), ISNUMERIC('3E2'+'.d0'), ISNUMERIC('1,000'+'.d0'), ISNUMERIC(CHAR(13)+'.d0'), ISNUMERIC(CHAR(9)+'.d0')

when...