thanks, i thought so, but i wasn't sure, whether it will work,

anybody knows about webservices

i have a website, which is in asp, i want to extract/send data to website,

i...

it is available on microsoft.com

really cool, i did not knew this

i will try whatever u said below, but

500 100

501 10

502 20

in the case u mentioned it should reflet

500 130(100+10+20)

501 30(10+20)

502 20(only 20)

this is what should appear

if u dont understand my question pls ask, but this is the query iam trying to write and needs help

thanks,thanks

thanks man, this really looked impossible

this thing is not very proper, if he tells me to find max 15th record, then how u gona do it,

suppose max 240th record, then ?

if the schema of 2 tables is different then it is advisiable to

connect the database through an ado, then collect the recordset and insert data in the required...

i have heard there are direct functions in oracle for this,

is there no such facility in sql2000?

do i need to the things only that r sugested above suppose iam 6th...

ok,

all this disscussion was really great, but what is the final outcome, if some 1 asks me how will u solve this problem

in an interview what should i answer...

u should have mentiond thats they no 2 persons will get the same resultset

i guess what u r trying to ask, tht 2 people have the same records and each one updates records, then there wud be a probelm is int?

wht u actually...

i love cursors please use cursors

functions can be used in queries to return a value based on some parameter orwithout parameter

but we cannot use stored procedures in queris