SQLMaister (1/30/2015)

---

Can someone post a reference from any SQL Standards book or academic research or similar work that states that SELECT COUNT(1) is the standard or intended method or syntax...

SQLMaister (1/30/2015)

---

I don't get it. There are thousands of ways to get the correct answer, but why make it complicated? There is only one correct standard SQL method. SELECT COUNT(*)...

TheSQLGuru (1/30/2015)

---

I had a client GO OUT OF BUSINESS because of this exact flaw (triggers that don't handle more than one row)!!! And I TOLD THEM IT WOULD HAPPEN...

Jeff Moden (1/30/2015)

---

Heh... agreed. There's a lot to be said for all of that and not suggesting a move. Just suggesting that you'd make a better DBA than...

Chad Caswell (1/30/2015)

---

Thank you both for your help! I can't believe we missed this. Problem solved and we are up and running once again. For future reference, this page (http://www.mssqltips.com/sqlservertutorial/2911/working-with-triggers/)...

Jeff Moden (1/30/2015)

---

Sean Lange (1/30/2015)

---

Jeff Moden (1/29/2015)

---

Sean Lange (1/29/2015)

---

Gosh I am humbled to...

Anju Renjith (1/30/2015)

---

create table tblxmldata

(id int, xmltext varchar(max))

insert into tblxmldata values(1,'<associatedText><value type="PO">GTT taken</value></associatedText>')

insert into tblxmldata values(1,'<associatedText><value type="PO">Check sugar today please</value></associatedText>')

...

Chad Caswell (1/30/2015)

---

Hello,

We have an UPDATE trigger that is failing. This seems like a basic task - we want to write a record to a separate tracking table when our...

Jeff Moden (1/29/2015)

---

Sean Lange (1/29/2015)

---

Gosh I am humbled to be grouped with those...

Richard Warr (1/30/2015)

---

Michel Steiner (1/30/2015)

---

Under which conditions can count(*) be slow? I'm trying with a 5TB DB, several tables having millions of rows and always get the answer in less...

bugg (1/30/2015)

---

Mark Cowne (5/3/2012)

---

Join to a numbers/tally table

SELECT s.ORDER_NUMBER, s.PRODUCT_ID, 1 AS QTY, s.VALUE/s.QTY AS VALUE

FROM @SPLITROW s

INNER JOIN master.dbo.spt_values t ON t.type='P'

AND...

bah...didn't realize this article was a repost and replied to a comment that was a year and a half old.

Hi and welcome to the forums. We can help but you didn't actually post a question. You said the values are wrong. What should they be? What are they now?

For...

montserrat.deza (1/29/2015)

---

Hello I am trying to use this logic into a query:

Select P.S,E.S,E.R

from Pack P(nolock)

join Exp E on P.Id=E.O

on E.R is null

...

Gosh I am humbled to be grouped with those two in such a...