Viewing 15 posts - 1 through 15 (of 87 total)
Interesting, def a little shorter code-wise....no performance increase though...
July 1, 2008 at 2:07 pm
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.
July 1, 2008 at 10:45 am
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...
July 1, 2008 at 10:37 am
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...
July 1, 2008 at 9:00 am
It's a 3rd party vendor app, unfortunately, so I can't modify it.
June 30, 2008 at 5:42 am
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
October 8, 2007 at 2:20 pm
thanks JLK. i was actually pointing to the wrong table. it's working.
August 22, 2007 at 1:26 pm
thanks Lynn.
The expression I needed under Arguments was : " e " + @[User::FileName] + " -oc:\\dep\\unzip -aoa"
August 22, 2007 at 8:37 am
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...
August 20, 2007 at 4:22 pm
Thanks!!!!
The last suggestion worked:
AND convert(varchar(30),dateadd(mi, -1, s.PunchOutDate),114) >= si.dtShiftStartTime
Appreciate the help big time!
August 9, 2007 at 4:23 pm
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...
June 20, 2007 at 2:15 pm
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....
June 20, 2007 at 10:20 am
All minutes in a schedule is every minute for every day of the year? not just per day?
June 20, 2007 at 9:47 am
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...
June 19, 2007 at 2:48 pm
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
June 19, 2007 at 12:35 pm
Viewing 15 posts - 1 through 15 (of 87 total)