Database

andyharman wrote:

Can you post some of the code up here

Begin Transaction

Declare @tblCategory Table (CategoryID BigInt)

Insert into @tblCategory(CategoryID)
Select A.CategoryID from Shop A Where ProductName = @pProdName

If exists(select categoryId from @tblCategory)
begin
  Declare @tblLocalities Table(CategoryID BigInt, LocalityID int)
  Insert into @tblLocalities (categoryid,localityid) 
  select B.CategoryID, B.localityId from ShopGroup B, Shop A
  where A.CategoryID = B.CategoryID and A.ProductName = @pProdName
  
  If @@rowcount > 0
  begin
     Update Shop Set Ranking = 2 where categoryID in 
     (select t.CategoryID from @tblLocalities t)
   end
end
If @@error > 0
Begin
  rollback transaction
end
else
begin
  commmit transaction
end

Mike Dimmick wrote:

Yes, inserting or updating a lot of records will take a lot of time, particularly if running other queries concurrently against the same records

Mike Dimmick wrote:

Management Studio assumes you're more interested in the results than in a speedy response and doesn't time out

beklo.com/rameshgoudd wrote:

Subject:Re: sql,query very urgent

beklo.com/rameshgoudd wrote:

very urgent