Dear Sujitkar
R u using where condition in your Query??? And that too on table r???
As your join Query seems fine.
Regards,
BhumikaNT
Last Activity: Jul 27 '09, 12:01 PM
Joined: Jul 2 '09
Location:
-
Option 1
If you want to merge these 2 tables,
Steps:
1. Alter table table1 (means, change designing of Table1) and add columns of table2 (i.e. smarks & sresult).
2. Write update query using join.
Update Table1
set smarks=t2.smark s
sresult=t2.sres ult
from table1 t1 inner join table2 t2 on
t1.sid=t2.sid
3. "drop table table2"...Leave a comment:
-
You need to use cursor for the same. Which will fatch @ProductID value from your table and these 2 queries of yours will fine with all the Product.
Rgds,Leave a comment:
-
I think, u need to write SP with Cursor. Where u can give where condition with COALESCE statement. If u want to use COALESCE function only..Leave a comment:
-
How r u executing this SP?
Pls provide exec Statement...
As the statement written over here is not matching with your SP name in which u r facing problem.Leave a comment:
No activity results to display
Leave a comment: