I'm not sure what you mean by "Count".  you should use DTS as part of your ETL process...this allows incremental and full processing.

cl

Yikes...that's a scary piece of code.  I shouldn't try to help (because you didn't post the DDL...tsk tsk).

Where are you joining to "addrline b"...in the subquery or in the main...

All data access in .NET is done through ADO.NET...that's how you get the variables through from the form to the database, then the database records back out to the web...

I think he's asking if he should re-process the dimensions every time he reprocesses his cube, for performance and accuracy reasons.

Accuracy is not affected by not re-processing dimensions, as...

That's because the text in the forum does not match the text in the actual editorial (sent in the 5/5/2005 email). 

I like this...

Your code looks fine to me...

I set up something similar in SQL, for when I wanted to move files from the SQL command line:

--------------------------------------------------------------------

create proc MoveFile

  @Source varchar(255),

  @Dest varchar(255),

  @isDebug...

Move visas AND more education....

An open society will prevail over a closed society in the long run.

survival of the fittest.

That which does not kill us makes us stronger.

Borders are just...

What you are describing sounds suspiciously like "Shared Source":

http://en.wikipedia.org/wiki/Shared_source

This is supported by a number of large companies, like IBM, Microsoft, Novell, BEA, etc.   Really, AT&T was the first to...

are many different ways to do a job and architect.

You are correct in this...there are many...

Another recommendation:

Don't use "select into".  Or use:

Select top 0 Into Dest from Source

Insert Dest

select * from Source

Here's an excellent article from Joe Celko on nested sets:

http://www.intelligententerprise.com/001020/celko.jhtml?_requestid=123193

Not that you shouldn't go and buy his book, too. 

You're absolutely right, john...my bad.

In fact, why the heck are there pictures on the internet at all?  It was all great when it was just text; much less bandwidth needed...

Yeah...pretty funny.  I really don't think anybody was seriously considering it, just poking fun. 

(chant) "I am a nice shark, not a mindless eating machine....Fish are friends, not food." 

Hilarious...

Word...we could have a "uses cursors when sets will do" tag, then mod them down in discussions. 

Grant you, I do have a few loops in my code ("While" loops instead...