Yeah I thought this was an interesting problem as well :). I am glad I had the right idea, just not enough experience with rCTE's to get the solution. My...

Thanks Jeff your solution worked just fine! Well, with the exception on our side of making a clean 'current' data map of items but I solved that as that was...

Cold Coffee: ITem 10 is the current most item that has data in the invoice table

I will create seperate scripts one for summing everything up that is 'current', and...

Here is the code that creates the sample data

IF (SELECT OBJECT_ID('TEMPDB..#FakeItems')) is not null

DROP TABLE #FakeItems

CREATE TABLE #FakeItems (Item_Code nvarchar(20), Superseeds nvarchar(20))

GO

INSERT #FakeItems

SELECT 'Abc8','' UNION ALL

SELECT 'Abc9','Abc8' UNION...

I will put along some sample data here today. Sorry this is not the only critical thing I have to do today! 😀

I can put together some sample data and...

Thank you for posting this article as I am sure it is useful to many.

I am confused however as I have been doing this since 2005 and it still looks...

So I am to wake up at 2am every morning and manually remove a user from the security roles and re-add them at 5am when everything is done? Doesn't sound...

The Trigger code is great for limiting access to sql server and reporting services, but it does absolutely nothing for the data cubes. I can still log in and use...

Single User mode does not work as my ETL process is parallel and fails because it connects to the database multiple times to run multiple scripts. Also, single user mode...

Lowell that sounds like a good solution.

It is only one database. Well the main datawarehouse is one database but I imagine if I put the report server database in...

Yeah I need to cut users off and block them for that time frame.

Wouldn't restarting the service do it, then I could activate that Trigger?

Will that block Cube users?

Also if they are already logged on, that wouldn't kick them off would it?

Yeah that sounds about right. That is my range and I have 7 years experience so that stands to reason :-D.

I am in no hurry to move though, I...

Oh man if I could move to Kansas I would be there in a heart beat 🙂

It seems to me most places are pushing the $80k-90k range give or take...

Jeff Moden (1/5/2012)

The "range" isn't necessarily an obstacle and that's been my point all along. Cut the bull and ask for what you truly believe you're worth compared to...