View previous topic :: View next topic
|
Author |
Message |
Ron Klop
New User
Joined: 28 Sep 2012 Posts: 28 Location: holland
|
|
|
|
Hello
The example beneath is somewhat simplified.
I have a table called DIM-month, containing information about months. It contains the next columns.
Month-key
Year
Month-number
Month-name
I also have a table DIM-day. It contains the next columns.
Day-key
Date
Month-key
Weekend-indication
Holiday-indication
Now I added two columns to DIM-month.
Number-weekend-days (this is the aggregation for a specific month of number of records in DIM-day where weekend-indication = Y)
Number-holiday-days (this is the aggregation for a specific month of number of records in DIM-day where holiday-indication = Y)
How do I update these two columns for every row, every month in DIM-month without using a cursor (in for instance a Cobol program)?
So in a single SQL?
Thnx
Ron |
|
Back to top |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
Try this:
Code: |
Update DIM-month A
Set Number-weekend-days =
(Select Count(*)
from DIM-day B
Where A.Month-key = B.Month-key
and B.Weekend-indication = 'Y'
); |
Similar query can be run for holiday days.
. |
|
Back to top |
|
|
Ron Klop
New User
Joined: 28 Sep 2012 Posts: 28 Location: holland
|
|
|
|
Dank
dit werkt |
|
Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008 Posts: 2010 Location: USA
|
|
|
|
Ron Klop wrote: |
Dank
dit werkt |
"Ich weiss nicht was soll es bedeuten..."? |
|
Back to top |
|
|
|