Thanks for the detailed answer Grant.

What I think is any organization mostly tends to use either SQL server or PostgreSQL (or in case of both, % will be very higher...

Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6 month...

I apologize if am not able to put my question in better way but i was looking to get average of percentages in one query.

The original question is how to calculate average of percentages in most efficient way.

Hi Steve, thanks but what you are providing here is calculating percentage. My ask is to get an average of 4 month percentage (or 5 or 6 month depending on...

Is this for reporting? If you're using {SSAS Tabular, Excel, or PowerBI} then DAX is baked right in. "Use the force, Luke!"

The first book I read on DAX was...

Hello friends,

Made the new query. Here is the dim & fact tables:

Create table #dim1(attr1_id int, attr1_name varchar(100), createdate datetime default getdate())
Create table #dim2(attr2_id int, attr2_name varchar(100), createdate...

Helo friends, hope everyone is doing good. I am working on a project where I have a big fact table having data for 8 years and has around...

You have datetime columns - don't use between!

where businessdate between '2022-08-01' and '2022-08-31'

means return everything through '2022-08-31 00:00:00.000 (excludes that entire last day of...

You have datetime columns - don't use between!

where businessdate between '2022-08-01' and '2022-08-31'

means return everything through '2022-08-31 00:00:00.000 (excludes that entire last day of the month...

• This reply was modified 2 years, 2 months ago by  sqlenthu 89358.

Yes, parameters.

There's different school of thoughts over whether the identity column should be a candidate of clustered index or not (mostly in favour of having it as clustered index).

What's your generic...

Thanks a lot Scott. That helped. There's one more query which is not showing any issues but i doubt in future when the table size increases, it will start giving...

I was out because of Covid. Could you please help me with the dynamic query ?

Use the test data you were kind enough to post (nicely done there), here's an answer that uses a CROSSTAB.  If you actually DO want NULL to appear, just...