hey BPH

iam not sure whether i understood u correct!

check the following code and tell me if its ok?

select * from reg1

collegeid   deptid      regis      

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

2001        1           101

2001        1          ...

hey sridar

could u plz explain how u solved the pblm.i did not understand. i get error when i did the same

thanx

Rajiv.

hey jenniferhu

i dont know what iam telling is valid...but again what strikes me ,iam telling it:

while declaring a parameter to b an output parameter, does n't the direction is to...

hey Sukhoi

since ms access is that of Microsoft..i think\syntax would b similar to that of sqlserver!

this is jus my interpretation.not sure!!

if u want some sqlserver joins:

select * from table1 join...

hey Andy

i would like to know is it possible to call the system functions such as"bcp" from sqlserver 2000 itself.?

and also how can we create our own extended procedures?

plz help...

Hey sukhoi

i too had the same doubt..

but is n't there a concept called "concurrency"?

i too dont know much....plz let me also know the solution to this pblm!!

thanx

Rajiv.

hey riga

its really a interesting question...

i dont think u can do that once the scope of the temp rable is over. u please do let me know the actual answer.

thanx,

Rajiv.

hey milovan

iam not sure whether u have solved ur pblm.

i did not understand ur question. cursor are for row level processing. if u could elaborate ur doubt i might try...