Mike John (9/11/2014)

---

One other thing to check,

In the script that CREATES the stored procedure, have you by chance got a call to the same stored procedure.

Something like

create procedure ...

crookj (9/11/2014)

---

Ed Wagner (9/11/2014)

---

TomThomson (9/11/2014)

---

djj (9/11/2014)

---

BWFC (9/11/2014)

---

SQLRNNR (9/10/2014)

---

Sean Lange (9/10/2014)

---

SQLRNNR (9/10/2014)

---

Is...

michaeleaton 36224 (9/10/2014)

---

Hey, so I have the following SQL Query:

SELECT COUNT(DISTINCT CustomerID) AS ActiveCustomers, DATENAME(MONTH, PaymentDate) + ' ' + DATENAME(YEAR, PaymentDate) AS [Period]

FROM dbo.[Order]

WHERE DATENAME(YEAR, PaymentDate) > 2012

GROUP BY...

cbernardes (9/10/2014)

---

Sean Lange (9/10/2014)

---

Ahh gotcha. OK, back on track. Let's use your Schools table as an example. My former comments about normalization would apply if this is your real table...

Ahh gotcha. OK, back on track. Let's use your Schools table as an example. My former comments about normalization would apply if this is your real table but we shall...

cbernardes (9/10/2014)

---

Sean Lange (9/10/2014)

---

The biggest issue you have is that you have a base table and audit table but there are no columns to record the time something happened. This...

TomThomson (9/10/2014)

---

Yes, generally he does. However he apparently hates agreeing with anyone in a forum even more, because he's been pushing YYYY-MM-00 format for a month in one of...

GilaMonster (9/10/2014)

---

Sean Lange (9/10/2014)

---

Steve Jones - SSC Editor (9/10/2014)

---

WayneS (9/10/2014)

---

Sean Lange (9/9/2014)

---

I think I should be able to make it for the afternoon sessions. The last game should be done...

Ed Wagner (9/10/2014)

---

Sean Lange (9/10/2014)

---

Steve Jones - SSC Editor (9/10/2014)

---

WayneS (9/10/2014)

---

Sean Lange (9/9/2014)

---

I think I should be able to make it for the afternoon sessions. The last game should be...

SQLRNNR (9/10/2014)

---

GilaMonster (9/10/2014)

---

Sean Lange (9/10/2014)

---

Steve Jones - SSC Editor (9/10/2014)

---

WayneS (9/10/2014)

---

Sean Lange (9/9/2014)

---

I think I should be able to make it for the afternoon sessions. The last game should be...

Both 😉

Steve Jones - SSC Editor (9/10/2014)

---

WayneS (9/10/2014)

---

Sean Lange (9/9/2014)

---

I think I should be able to make it for the afternoon sessions. The last game should be done a little before...

The biggest issue you have is that you have a base table and audit table but there are no columns to record the time something happened. This means that your...

ezapa001 (9/10/2014)

---

Hi Friends,

I'm trying to write a query to validate the data.

Here is the scenario:

1. The table has Three columns 1.ID, 2.Sqno, 3. Adj

2. The values for adj are (0,1,2)

Case1:...

Here is the entire beast. This is more than just these two with a UNION ALL. That query is wrapped in another query. Your comments about the origin of this...