Making a Stored Procedure in MS-SQL 2000

Hi,

Sorry, this is a very easy question. I have to create a stored
procedure in a SQL SERVER Database.

I have read lots on MSDN about the syntax of this stored procedure :
ie.

CREATE PROCEDURE spGetContctDetails
AS
-- get everything out of contact table
SELECT * FROM tblContact

but I cannot find anywhere how to actually add this procedure, so that
it is accessable in my VB.NET program.

What I am asking is : what screen do I type this into? Is it Query
Analyzer, if so where?

Its got me oh so confused. When I've got time i'll read all about SQL
Server, but for this morning I need to know how to simply add that
Stored Procedure to my database.

Thanks LOADS for any help.Type the CREATE PROCEDURE code in Query Analyzer. You can then execute
the proc from VB using the ADO command.execute method for example.
--
David Portas
SQL Server MVP
--

making a dimension smart

Hi,

We have a cube with a client dimension which has lots of rows and about 60 attributes.

The table looks like this

ID, first name, infix, lastname, street, housenumber, postal code, city, gender.

The users want to see all the attributes..

Analysis server is making calculations on every attribute.

The users are only intrested in ID, city and gender but they don't want to loose the other attributes.

How can I tell analysis server that it should not make calculations on the first name, infix and lastname, street, housenumber and post code?

I tried setting the attribute IsAggregable to false but that didn't work.

Any suggestions ?

With regards,

Constantijn Enders

If you don't want the data to aggregate, set the AggregationUsage property to None in the Attributes tab, in the Dimension window (possibly the bottom left window) under the Cube structure tab in VS.

C
|||

what type of calculations you do?

usually you do calculations in numeric values...

you can set aggregation to none...

give more details...

Regards