Viewing 4 posts - 856 through 859 (of 859 total)
You have to loop through the dates, personal preference is a WHILE loop. below is a stored procedure where you can pass the string all or a specific customer...
March 2, 2012 at 4:01 pm
after trying to figure out what was going on i stayed up and watched the zip files be created at 3 am. and after a face palm realizing the...
March 1, 2012 at 2:02 pm
in the sample data each role only has one userid associated with it. however the problem gets larger as more userid's are associated with each role as the min...
February 23, 2012 at 1:03 pm
cengland0 (2/22/2012)
Can't this be accomplished by a simple query like this:
select
productID,
min(EventTime) as StartTime,
max(EventTime) as EndTime,
RoleName
From [YourTableNameHere]
Group by
ProductID,
RoleName
That would work however there are userid's that repeat, so the min...
February 23, 2012 at 12:40 pm
Viewing 4 posts - 856 through 859 (of 859 total)