Is there a way to get fractions?

Found the issue. I was selecting * in the primary stored procedure so it was returning two datasets and that one is the initial one. Commented that out...

Jeff Moden (11/12/2009)

---

Heh... I have an odd personal preference... I don't like languages that require semi-colons or line continuation characters. It seems that they should all be smarter than...

Jeff (or anybody),

Because the data is being stored in a SQL Server 2000 database, but we also have a working 2005 version on a different server, would there be a...

I still do need help with it. We have had continued IT "fires" at the plant with some fiber networking issues and I have been keeping busy with other...

Thanks again. I was not thinking about the version that we are using. When the time comes, I hope it is not going to be a big pain...

Again, thanks for the help with this, however I just ran into a couple of issues that I might be able to work through. Unfortunately when I ran this...

Thank you very much for this. I have not been able to review it yet as we are having other IT issues that are taking my time. But...

Jeff, I really appreciate this help. Here it is with the CartonCopy included:

IF OBJECT_ID('TempDB..#tempGlue','U') IS NOT NULL

DROP TABLE #tempGlue

CREATE TABLE #tempGlue

(

ScheduledDate datetime,

Shift char(1),

CaseCode char(10),

CartonCopy char(10),

Scheduled int,

StartDate datetime,

CurrentGluedPieces int

)

SET...

Jeff, wondering if you were still able to help with this. I have had a busy couple of days, but I will be revisiting this project this afternoon.

Thanks,

Brad

The reason that there might be two different values is due to another column that was not included called CartonCopy. A product (CaseCode) might have two or even three...

Jeff,

Thanks for the reply. I reviewed your article and took the time to create the temp table and insert the data there. Here it is:

IF OBJECT_ID('TempDB..#tempGlue','U') IS NOT...

Okay, here it goes:

The raw data for just one case code (02725). The actual raw table contains close to 500 rows with different case codes:

ScheduledDate ...

Thanks Steve for the reply. I enjoy reading your editorials every morning. Anyway, basically what I need to do is to "aggregate" or accumulate the value from Scheduled...

Thanks so much! That seemed to work.