Are you guarantteed to have only one record inserted into the table [dbo].[Temptable] at a time or is it possible that multiple records could be inserted by a singe insert...

So, is there an outer loop in this trigger? What I am trying to get to is that you should provide the entire definition of the trigger, not just...

hxkresl (7/1/2011)

---

Lynn, thanks for replying. I think you meant 'the code looks good'. Yes, and it seems very straight forward yet it's not working. Other than the composite...

alhayalara (7/1/2011)

---

Hi Lynn, thank for your attention.

Pasted the code

set @ID = (SELECT TOP 1 ID FROM TempTable WHERE Name = 'Products')

set @NewMD = (SELECT TOP 1 NewCol2 FROM TempTable WHERE...

alhayalara (7/1/2011)

---

I have a trigger that updates product tables across more than 80 databases. Somehow the trigger hits a timeout error after about 50 databases.

We are speculating that this could...

filipeesch (7/1/2011)

---

I'm not doing simple updates. Its a logic that a simples SQL command dos not resolve.

In oracle ican do a foreach expression, like this:

FOR( row IN (SELECT * FROM...

Just curious, but did you ask...

First, instead of posting a piece of the function try posting the entire function for us to see.

Second, please tell me how this fragment is supposed to work,as I am...

Here is another article that provides some guidance on deleting large number of records: Deleting Large Number of Records[/url].

Read the second article I reference below in signature block regarding asking for assistance with performance problems. Follow the instructions in that article and people will be more willing...

Based solely on the table definitions provided your looks code. As you noted, however, there is a difference in the data. Since we don't have access to your...

wayne.mcdaniel (10/25/2010)

---

Probably more likely that the one...

I have to agree with Jeff in many respects. I would chose to use a different term, however, when it comes to the DBA and ownership of the production...

Ninja's_RGR'us (4/29/2011)

---

Ian-440692 (4/29/2011)

---

I tried saying I worked with computers, but had so many requests to fix printers or help set up wireless networks that I changed and now I...

Maybe, but with limited resources (money) you do what you have to with what you can afford.

With SQL Server 2005 I used...