Grant Fritchey (4/27/2015)
TheSQLGuru (4/27/2015)
Igor Micev (4/27/2015)
You can use the NOLOCK hint for srno without worries because u're reading an identity value.Can you please explain that statement Igor??
Yeah. I'm unclear on it too.
Sorry I'm replying late. I actually wrote it from my phone and was trying to be short.
I meant this
declare @srno int
select @srno=srno from Entry_Jangad_Lot (NOLOCK) where Kapan=@Kapan
and Lotno=@Lotno
and Position='CURRENT'
based on
3) blocking by other activity (I go with this by default for a 60K row tale without any other information)
from The SQL guru's post.
Igor Micev,My blog: www.igormicev.com