OLAP

Hi Al
Can anyone please point me to articles on OLAP, I'm looking for articles with some walk-thru examples
I have used OLAP with Star Schema, but never explored beyond that, really want to get a real feeling for possible options/features on OLAP :-
Any help appreciated
ThanksYou could probably start at MSDN
http://search.microsoft.com/search/results.aspx?View=msdn&p=1&s=1&c=4&st=a&qu=olap&na=30
"Prasanna" <anonymous@.discussions.microsoft.com> wrote in message
news:2DBF734B-367F-4680-A48D-98A40B4BDF10@.microsoft.com...
> Hi All
> Can anyone please point me to articles on OLAP, I'm looking for articles
with some walk-thru examples.
> I have used OLAP with Star Schema, but never explored beyond that, really
want to get a real feeling for possible options/features on OLAP :-)
> Any help appreciated.
> Thankssql

OK to use one stored procedure for inserts and updates?

I have seen a couple examples where the person used ONE stored procedure (call it SaveOrder) was used for both Inserts and Updates. This would be opposed to having a InsertOrder and UpdateOrder. I'm assuming there was some branching code in there to determine whether the record already existed or not.

My question is this: Is this a good practice? It seems like it might save some duplicate coding.

Just looking for some opinions-

Thanks,

Jim

its ok....

if exist...update

else insert

|||Hi,

I would alway prefer a more granular solution rather than a monolithic approach. Otherwise procedure could get (depending on your code) hard to read and debug.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thank you both-

Jim

sql