Viewing 2 posts - 1 through 3 (of 3 total)
I found the solution to this problem using the new aggregation Functions in SQL Server 2005. Thank you SQL Server Magazine (June '06)!!!
I used the OVER clause with PARTITION BY my_company_id to...
June 30, 2006 at 12:47 pm
#647061
Sure. Let me try it another way:
Our "Account" Dimension is actually named "Domestic Companies". They import/export various commodities and there are some 450,000 distinct members which are, for this scenario,...
June 28, 2006 at 2:12 pm
#646487