I did and it ran for a LONG time. Over 20 minutes. I had to stop it. :-/

GSquared (4/7/2009)

---

I can't test this, so I'm not sure if it'll work, much less whether it will be faster, slower, etc., than the current version. Can you test it...

19 minutes...

So far,...

Chris Morris (4/7/2009)

---

Try this, Donato:

DECLARE @Startdate DATETIME, @Enddate DATETIME

SELECT @Startdate = convert(datetime, '02-APR-09' + ' 03:00:00', 101),

@Enddate = convert(datetime, '02-APR-09' + ' 20:00:00', 101)

--

SELECT itl.user_id, au.notes, au.shift,

--

sum(update_qty...

I get: Column 'd.loginTime' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Good point.

Anyone have any other ideas in...

I wish there was a tool out there that analyzed your queries and syntax and made suggestions on how to improve upon it.

OHHH! Ok. Sorry...

Chris Morris (4/7/2009)

---

As Grant and GSquared have pointed out, there's abundant scope for improvement in this query, to make it fast and to make it pretty. Here's the first query...

Chris Morris (4/7/2009)

---

As Grant and GSquared have pointed out, there's abundant scope for improvement in this query, to make it fast and to make it pretty. Here's the first query...

I have made the CREATE TABLE scripts for now... I can post those and then get sample data over. Would that help?

Like I said... Being new at this, I am not sure what the best way is to do this. I just know it runs VERY slow. A little...

Thank you for you response.

This is code left over from the person I replaced. However, I am not an SQL person per se... So, that being said, I'm...