Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rweinstein
Starting Member
3 Posts |
 Posted - 2004-04-16 : 11:55:50
|
| I am adding a column to my fact table to count the number of occurrences in another field. For example, I will enter a '1' in my new field named 'Count' whenever the 'Type' field has 'Meal'. What I am doing is counting the number of meals in the system so I can add up all the costs and divide by the count to get average cost per meal.The problem is that I don't want to count every line item. I only want to input a '1' in my 'Count' field for each meal per day. I am unsure how to do this. Here is what I have:case when T1."Type" = 'Meal' then '1' else null endI tried using "and max(T1."Date")" but it was not working.Please help me develop this SQL so that I only have one count per day.Thanks. |
|
|
|
|
|
Help with an SQL statement