How about you first try to fix the things we have already noted for you in what you originally posted? I pointed you to a logic error that I...

As it is, I really need to check the forum of question before I post. Really sad when I post a SQL answer in an Access forum.

john.arnott (4/29/2009)

---

Jack Corbett (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is his...

Try something like this:

SELECT DISTINCTROW JKTime.PayrollWeek, JKTime.Mechanic, JKTime.JobID, JKTime.TimeType, Sum(JKTime.Time) AS [Sum Of Time]

FROM JKTime

GROUP BY JKTime.PayrollWeek, JKTime.Mechanic, JKTime.JobID, JKTime.TimeType

HAVING (((JKTime.PayrollWeek)=#1/1/2009#));

You will need to change the date for PayrollWeek

Sorry, I didn't realize this was Access when I posted the query. Don't know enough about Access to help at this point. Let me do some research and...

Give this a try:

CREATE PROCEDURE ...............

@LanguageID Int,

@Type Int,

@DateStart DateTime,

@DateEnd DateTime

AS

BEGIN

SET NOCOUNT ON;

with ClientExitCount(

ClientUrlID,

...

I think this is what you are looking for:

declare @PayWeek int;

set @PayWeek = 1; -- just a value for illustration purposes

select

jkt.Mechanic,

sum(case when...

It's simple why you wouldn't want to do that. First of all the data types VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) are blob data types that can hold up to 2...

I'd like to see a little more, including the DDL for the tables, some sample data for the tables (in a readily consumable format, not like how you posted the...

Which is...

Gaby Abed (4/29/2009)

---

GilaMonster (4/29/2009)

---

tosscrosby (4/29/2009)

---

Lynn Pettis (4/28/2009)

---

You know, I can think of some one else that, IMHO, ranks right there with our favorite White House window washer, and here is...

That is dependent on how and where you use the SQL functions in the WHERE clause.

GSquared (4/28/2009)

---

I don't watch TV, so I have absolutely no clue what...

Bruce W Cassidy (4/28/2009)

---

[font="Verdana"]This morning I had an idea. After I had had a bit of a sit down to recover from that novel feeling, and to reassure myself...

Albatross ...