Hi Steve,

Have you had any luck with that example project.

It would really help me out if you wouldnt mind sending it.

Thanks a lot for your help,

Jules

that would be great please send it.

is there a way of listing the available switches for an .exe in dos?

the other switches like /qb are not valid either?? i tried doing it with a .ini file...

yes set up begins when /seeting and path is omitted. Which setup program is it i has msdns developer edition

Steve,

thanks alot for this

have a look at the reporting services forumn if you have a chance

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=299248

Any help greatly appreciated,

Jules

start /wait "F:\ENGLISH\SQL2005\DEVELOPER\SQL Server x86\Servers\setup.exe" /settings "C:\Documents and Settings\Administrator\Desktop\SQLInstall.INI" /qn

when i run the batch in a cmd window "/settings" is an invalid sqitch comes up.

F is the DVD drive.

Any...

="WITH MEMBER [Measures].[ParameterCaption] AS '[Broker Contact].[Full Name].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Broker Contact].[Full Name].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Broker Contact].[Full Name].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Broker Contact].[Full Name].ALLMEMBERS ON...

Thanks very much for this it seems to compile this code ok but cant run it.

After i select the first parameter( which then would filter the available values for the...

Thanks very much for this the it seems and to compile this code but cant run it.

After i select the first parameter( which then whould filter the available valuse for...

Thanks very much for your help but i am very new to MDX so am not quite there yet.

when i add the = sign at the beginning of the...

you need to get an idea of how many different hold types there and then use a cross tab structure. Something like

max(case when hold = 'credit' then hold else ''...

in case anyone is interested i solved this by using the sql2005 rank() function

create view testview

as

select

thing, type,

rank() over (partition by thing order by thing, type)as Ranking

from test

Nope shouldnt need to.

Replication should really be DBA responsibilty as its her who wil get it in the neck if the data is missing currupt etc.

This kind of denormalisatin is a bad idea. You should calulate it 'on-demand' rather than storing the value in your DB.

If you must store this as a column you...

whats wrong with it?

Does it error or update the data incorrectly?

Please post an example.