hi again today have a problem, i have an HQ database with 180,000 items. I need to transmit to all SO stores and i use the Worksheet 260 to download the items in the stores. But, when the store starts the sincronization around 45 minutes before to hq client start to procces the Worksheet and give me a error about the TIME CONECTION (The wait time was ended), and give me this: UPDATE Item SET TagAlongItem = ISNULL(A.ID,0) FROM #Temp JOIN Item ON #Temp.HQID = ItemHQID LEFT JOIN Item AS A ON (#Temp.TagAlongItem0A.HQID) AND (A.HQID 0) SELECT @@ROWCOUNT AS REcorsAffected.
Although this, the items were loaded in my SO STORE. I tried with around 10,000 items, and there's no problem.
My question is, are too much the quantity of Items??