hi, try with .. select * from convert(fromdate,datetime,101)>='02/31/2006' and convert(todate,datetime,101)>='04/04/2006' and regards

jijo jose

hi, This is the complete query to get your output......... SELECT accountid=case when isnull(a.AccountID,'')='' then b.accountid else a.accountid end, symbol=case when isnull(a.Symbol,'')='' then b.Symbol else a.Symbol end , a.Fee, a.Price, b.Share, b.Dollar FROM tableA a FULL outer JOIN tableB b on a.AccountID = b.AccountID AND a.Symbol = b.Symbol order by accountid,symbol regards

jijo jose

hi, Hey...how others can db design upon your requirements .....:~ regards

jijo jose

hi, you can add identity column for these tables and join with this column. regards

jijo jose

hi, i dont understand the relation between Marks and Ctrl tables. regards Jijo

jijo jose

hi, I thought, you wanted to delete all the dubplicated one including original, Then do this in your query analyser......... 1 st step ---------- alter table table1 add [id] int identity 2nd step ---------- delete from table1 where [id] not in (select min([id]) from table1 group by col001) it will delete all the duplicate records from table1 regards Jijo :rolleyes: -- modified at 9:36 Thursday 29th March, 2007

jijo jose

hi, suppose col001 of table1 is the duplicated values.then the query "select col001 from table1 group by col001 having count(col001)>1" will get all the duplicate values so, the below query will delete all the duplicated records. "delete from table1 where col001 in ( select col001 from table1 group by col001 having count(col001)>1)" regards Jijo

jijo jose

hi all, I have a dll file named wpdes32.dll for DES encryption/decryption. I need to call this in Vc++ , i couldn't create .def file for this and only know the declaration of functions. How can i call this in vc++?? thanks and regards jijo jijo jose