Interesting, def a little shorter code-wise....no performance increase though...

yep, you're exactly right.

it's measuring how many cases are in each of those listed steps, at a point in time when I run the query.

for each casenum, the 'at_id' field increments. So the record with the highest 'at_id' value for each casenum will contain the most recent step.

What I wanted to do was find...

Thanks Chris, I changed the sample data to return results. (can't figure out how to get that one 'wink' out of the code though.)

John, you are correct, I am only...

It's a 3rd party vendor app, unfortunately, so I can't modify it.

I found the solution in case anyone else has the same issue. It's the last post listed here:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=855663&SiteID=17

thanks JLK. i was actually pointing to the wrong table. it's working.

thanks Lynn.

The expression I needed under Arguments was : " e " + @[User::FileName] + " -oc:\\dep\\unzip -aoa"

Appreciate the reply.

I'm trying to unzip each file in a directory to another location but can't seem to get it to work. It's the free zip tool 7zip. I'm entering the...

Thanks!!!!

The last suggestion worked:

AND convert(varchar(30),dateadd(mi, -1, s.PunchOutDate),114) >= si.dtShiftStartTime

Appreciate the help big time!

well the time punch and schedule data is broken into separate days, so the days don't overlap. I can probably just use the 1440 i minute bucket table I have. There...

Serqiy, just making sure I'm following correctly, when you say S.ID, T.ID...where would these values come from? From Schedule and TimePunch data or elsewhere? I'm really interested in your solution....

All minutes in a schedule is every minute for every day of the year? not just per day?

Thanks I fixed my mistake. Here it is below.

-- ================================================

-- usp_UpdateDataRefreshLog

-- ================================================

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Create date: 06/19/2007

-- Description: Updates the DW Refresh Data

-- =============================================

ALTER PROCEDURE usp_UpdateDataRefreshLog

 @TableName varchar(30)

AS

SET...

Yes, I'm sure many others have encountered similar data issues as well. I'd be very interested in their methodology to solve this issue. Appreciate how helpful you've been. Thanks.

-Pat