a service pack question...

background: sql2k
I have a quick question about sql sp3a.
when i apply the sp3a, is that just for the sql or for analysis service
as well?
if i have ananlysis services installed, do you need to apply the sp3
for analysis service seperately (in MSOLAP|install|setup on the sp3a
CD) or sql sp3a will take care of it? thank you.> I have a quick question about sql sp3a.
> when i apply the sp3a, is that just for the sql or for analysis service
> as well?
No.

> if i have ananlysis services installed, do you need to apply the sp3
> for analysis service seperately (in MSOLAP|install|setup on the sp3a
> CD)
Yes.

> or sql sp3a will take care of it? thank you.
No.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

A question about association rules

Hi

I am doing the Market basket analysis for a retailer using association rule. The whole data set is huge which contains grocery, clothes and books etc. If I want to check out the relationship between several different clothes brands, (e.g. LEVI'S and adidas), should I just remove all the grocery and books transactions, use the subset which only contains clothes transactions to re-run the association rules? Is this gonna work?

Thanks in advance!

You can create differents data source views (dsv) as a support for a model desired. For the dsv you can build the apropriate view in SQL Server that select that several different clothes brands (in WHERE clause). You don't have to remove any transaction.

Gigi Ciubuc

www.sqlserver.ro

|||Great help, thanks a lot.

A query to get n values from one column

I have a query which join 5 tables say my result is
Warehouse ProductName Features Price Manf
I just need to make some analysis and need to select any 5 features
from Features column for each productname. There can be 10 - 50
features mentioned in the table with features.
Say my result it like only for productname and features column
which come from diff tables. Here I am getting more than 5 features
I need to reduce that to 5 for each. So how do I do this.
Productname Features
AAAAA 12
AAAAA 145
AAAAA 23
AAAAA 34234
AAAAA 234234
AAAAA 32234
AAAAA 134234
AAAAA 21
AAAAA 14
AAAAA 556
BBBBB 19
BBBBB 23
BBBBB 6
BBBBB 1
BBBBB 2
BBBBB 11
BBBBB 15
BBBBB 12
BBBBB 6
BBBBB 4
Also very important this need to be done is how do i avoid repititions
and do the cross- tab join and make only one row for one product name
and get the result like this
Productname Features
AAAAA 12, 45, 234, 256, 25677, 24223......
BBBBB 12,121, 144, 58885, 8888, 99999....
CCCCC 111, 144, 2333, 22333, 22221......Please search the archives of this newsgroup to see if there is any
alternatives. For instance, check today's thread "comma delimited list".
Anith