Force client components using a commmand line installation to diffrent location

Is it possible to force the SLQ 2005 Client Components to be installed into a diffrent location other than the default location?

What I'm trying to do is run the setup command though the command line to create an unattended client installation with all the client componets to a diffrent location that

Thanks, Any information or examples would be great!

There is a way to specify client component location is setup or on the command line but it can only be used for the first time SQL Server 2005 is installed on a machine. Once there is any product or instance of SQL Server 2005 on the machine this location cannot be changed. To specify the location on the command line you can use INSTALLSQLSHAREDDIR.

Note: there are still some components going under Program Files\Microsoft SQL Server\90 which location cannot be changed. But most of the client components is installed to INSTALLSQLSHAREDDIR.

For example:

setup.exe INSTALLSQLSHAREDDIR=D:\SQLTools ADDLOCAL=Client_Components,Connectivity,SQL_Tools90,SQL_WarehouseDevWorkbench /qb

ADDLOCAL lists all features you want to install. See template.ini in the same location as setup.exe for whole list of features.

for instance: How do I get the quantity of the last Date for every Location ?

Hello,

How do I get the quantity of the last Date for every Location ?
See example given:

select
[Measures].[Quantity] on columns,
(
nonemptycrossjoin(
[Location].[Location].[Location]
, [Posting Date].[Posting Date]
, 2
)
)
on rows
from
[Logistics]

This query will give me the following result:

Locations

Date

Quantity

Location A

2006-01-01

5

Location A

2006-01-05

3

Location A

2006-01-07

7

Location B

2006-01-01

2

Location B

2006-02-05

3

Location C

2006-01-01

2

Location C

2006-01-01

2

Location C

2006-01-02

3

Location C

2006-01-03

3

This is what I want

Location A

2006-01-07

7

Location B

2006-02-05

3

Location C

2006-01-03

3

Kind regards.

You should take a look at LastNonEmpty aggregation function in AS2005. It does exactly what you need.

|||Let me refine this with another example:

Date	Location	Horz. Group	Horz. Code	Vert. Group	Vert. Code	Item	Quantity
2006-1-1	A	6	1	5	1	I10256	1
2006-1-2	A	6	1	5	1	I10256	2
2006-1-3	A	6	1	5	1	I10256	3
2006-1-1	B	6	1	5	1	I10256	4
2006-1-3	B	6	1	5	1	I10256	5
2006-1-1	B	6	1	5	2	I10256	6

The actual supply-result for the year 2006 = 3 + 5 + 6 = 14 (this is correct)
The LastNonEmpty-result in AS2005 = 3 + 5 = 8 (this is not correct, eg. is not sorted by date as you can see but doesn't matter :o)
I actually wanna have the LastNonEmpty grouped by [Date],[Location],[Horz etc],[Vert etc],[Item] ?
How can I force the LastNonEmpty to do that ? Not only Time-related !?
I wanna see the correct supplies in my time-dimension on the level year or month or day :o)
Kind regards.