hmbtx (3/27/2011)

---

Ron:

Yes, Craig's code satisfied my requirements?

If it is okay, I would like to add one additional question based on Craig's solution and that is how can I change the...

Lynn Pettis (3/26/2011)

---

Okay, poll time. How many of you are getting tired of Celko and his high horse?

I may be wrong, but I think I could count on one...

Double post, please send all comments and concerns to this thread.

Jeff Moden (3/26/2011)

---

I'm not 100% sure but it seems to me that I remember a post somewhere where it said that it does matter especially for GUI related code that...

hmbtx (3/26/2011)

---

Craig:

That is it! Works perfectly.

Thanks for your help as I would not have ever figured this out on my own.

I am sorry that I did not provide you with...

This runs against your sample.

SELECT

a.activity_code,

--a.[Description],

a.register_count,

drv.line_count

FROM

A_Header AS a

JOIN

( SELECTali.Activity_Code, COUNT(*) AS line_count

FROMA_Line AS ali

GROUP BYali.Activity_code

) AS drv

ONa.activity_code = drv.activity_code

where

drv.line_count <> a.register_count

order by

a.activity_code

hmbtx (3/26/2011)

---

I am copying your script and pasting it into Query Analyzer and running it there.

I made the change as you suggested (see below) but now I get the following...

*FACEPALM*

I'm blind, sorry. It's currently stating FROM table FROM (SELECT ...)

Yeaaah... turn that into FROM table JOIN (SELECT...)

2 Q's:

1) Are...

That's good to know. FYI, you posted in the 2k8 forum. You wanted the 7,2000 one that's further down in the list....

WayneS (3/26/2011)

---

Search this site for detecting gaps and islands - you're going to be interested in the islands.

(Posting tip: when posting dates, include a "SET DATEFORMAT DMY" so that people...

happycat59 (3/25/2011)

---

I believe that the data is actually stored on 3 disks...2 have the actual data and the 3rd has the exclusive OR of the other 2 disks. Using...

I have to work through this weekend so I finally get around to swinging by here, and you guys are plotting the end of the community as we know it....

The timing on this re-print couldn't be better. Thanks!!!

Perhaps, but not 25,000 points...