Loading

How to Update Using Two @Temp tables in sql

Kasuni Abegunawardana

I have two temp tables called @Temp and @RegTemp

select * from @Temp t1

inner join

@RegTem t2 on t1.ID= t2.ID

and t1.FinancialMonth=t2.CMonth

order by FinancialMonth, AccOrder,AccLevel

Here I have combined those two tables and now I wanna do this update using those two tables how can I do that

I know this is wrong. Please give any solution to do this

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Kapil Singh Kumawat8y ago
Hello,
Why you are using table variable as the scope is only till the execution of the statement.

You can use the temp table using # like #temp1 its better approach in your case and scope is till the end of session