nitin.varshney (9/27/2012)
When It is executing in Production, it is giving the performance impact.But the data populated in table variable is having approx 4000 records only.
You need to figure out which SP area is creating issue there might be pother issues like index missing , queries not acc to indexes or vice versa , amount of data. unproper data filters etc..study the execution plan
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)