harri.reddy (9/13/2012)
(2) If i define variable global variable in my stored proc doesnt it appear inside another stored proc.(nested)
Perhaps because SQL doesn't have global variables?
For the first, why don't you create such a table, run both queries and see which, if either, is faster?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability