I tried your full code, I have the same error:

[Err] 42000...

thank for reply.

I tried your last code but I have error in variable "@CountOfEmp":

DECLARE @CountOfEmp INT = (SELECT COUNT(*) FROM [dbo].[names]);

WITH GroupsOfWeeks AS (

SELECT *

...

You have right, I'm sorry... 🙂

The output of last query -adding a WHERE clause before ORDER BY that excludes holidays- is wrong because excludes the first nine valid dates of...

Yes, I tried and this is the output wrong you see:

WITH GroupsOfWeeks AS (

...

dwain.c (12/24/2012)

---

My first suggestion to you would be to remove the tbl_ from your table names as I find that convention totally annoying. You're not programming C or C#...

Yes, Sir.

In my case I counted 50 weeks in a year

divided by 5 workers = 10 weeks each because for two week for year is vacation.

1. I need...

J Livingston SQL (12/24/2012)

---

cms9651 (12/24/2012)

---

thank you for reply.

one of five people have to work a full week, while others are off.

everyone has to work the same number of weeks for...

thank you for reply.

one of five people have to work a full week, while others are off.

everyone has to work the same number of weeks for year.

know what I mean?

thanks a lot for help!

The rule for the sorting is mat geographic NAME.

MAW = My Area West

MAE = My Area East

MAC = My Area Center

MAS = My Area South

Eugene Elutin (9/6/2012)

---

The MAT column will be ordered randomly, but Tot will still come as a last one per DVD.

I agree, that setup needs clarification about Total: is it already...

Luis Cazares (9/4/2012)

---

It's explained in this article: http://msdn.microsoft.com/en-us/library/ms187746(v=SQL.105).aspx

However, let me try to explain it, but read the article as well.

You had a decimal(10,2) value which can contain any value with...

Luis Cazares (9/4/2012)

---

Do you know why did it worked? It's important for you to understand what happened...

thank you for help now working !!!!

ChrisM@Work (8/28/2012)

---

SELECT

CASE

WHEN (GROUPING([MAT]) = 1) THEN 'Tot'

ELSE [MAT] END

AS MAT,

--[myNUmber]

COUNT (*) AS [myNUmber]

FROM (

SELECT DISTINCT

CASE

WHEN LEFT (TZZ, 2) IN ('1D','1F') THEN 'MAO'

WHEN LEFT (TZZ, 2) IN ('1G','1H') THEN...