The problem is in the logic of your trigger. You need to write code that can handle sets of data instead of single rows at a time.

When you do...

sharonsql2013 (5/23/2014)

---

I am trying to calculate data for 30 and 90 Days .

When I do a select SUM(Charges) Charges, Count(PName) Person from Prod

where Pname like 'Mike%'

and Days< 90

It gives me...

Steve Jones - SSC Editor (5/23/2014)

---

GilaMonster (5/23/2014)

---

Steve, can anything be done about shrills like this:

http://www.sqlservercentral.com/Forums/FindPost1573887.aspx

He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and...

LOL. Apparently I need to endorse my SSC friends more on LinkedIn.

Maddave (5/23/2014)

---

Thanks. That doesn't work unfortunately and still performs just as badly.

Just talking this problem over on this forum, I think I have solved it by using a temporary...

Sure...the title of your thread pretty much gave you the solution.

SELECT ID,

MIN(InternalReference) as MinInternalReference,

MAX(InternalReference) as MaxInternalReference

FROM code

WHERE ParentCode = 'M222'

Why not use NULL instead of a derived value?

As I asked previously,...

No need to apologize about the names to me. The are painful but you are the one who has to...

Can you try to explain more clearly the desired output? Do you really have orders created yesterday that were completed more than 40 years ago? This would be a lot...

Can you post the code you are working with?...

StarterProgrammer (5/23/2014)

---

I want to fill the two tables at the same time but I don't know how to do that, It's not many to many relationship I think , they...

antonela (5/23/2014)

---

Hello everybody,

I have to export the records of a table in a .txt file but in a strange way (in a column). For example I have this table with...

Can you post your sample data in a consumable format? Create table and insert statements.

viresh29 (5/23/2014)

---

Hello Folks,

I am using SSIS to load raw files into database. In my files I have columns Date which has format

1/1/2010 12:00:00 PM.

I want to load this...

And looking for just

is probably not good enough depending on the source of your data. You also need to find <br /> and <br/>