DECLARE @User_ID int

SELECT @User_ID = UserId

FROM inserted

It should be that simple. Translating the integer user id into a name is another story that depends on where you keep that...

I'm going to give up until I see SQL Server relax some of the constraints on recursive CTEs. I either can't use an aggregate or can't make multiple...

I guess I'm going to have to let my cat out of the bag, as you're the 2nd person to mention the TSQL Challenge #22. However, my reason for...

CLR is prohibited on the server in question, but even so, I'm not entirely sure that's true, as each iteration further limits the record selection until finally there aren't any...

Actually, that concept is exactly what I'm hoping for - just eliminating the addition of any records from the PREFS table on each iteration unless there's only one record for...

Nice idea on the windowed aggregate. Unfortunately, I don't see how you can use that kind of count to return a single record when you need to count...

Matt,

I really thought I had it licked when I read your post. I added a ROW_NUMBER() function (alias RN) based on your post to the original selection table,...

Within a stored procedure, you don't DECLARE the parameter variables - those will exist because the procedure exists. Testing the code outside of the procedure will require the...

Well... let's see... I can't tear out the base logic from the actual code, so the best I can do is this:

Assume you have a table with...

Your last comment might be the key... You won't be able to insert multiple records with the same Id, as then you'd be violating the primary key. ...

How about using reporting services (SSRS)? I would like to think that each of the individual MDX queries could be a data source, but check it out for yourself...

Why can't you just add a specific login to a given report's security?

Steve

(aka sgmunson)

:-):-):-)

patr (4/17/2008)

i know to give the system level security by assigning a role but...

If you can get any one column in MDX, can you then output that to a temp table, and then use T-SQL to gather from the temp tables created?

Steve

(aka sgmunson)

:-):-):-)

bikerdadHLV...

Have you tried using the SA account ?

Steve

(aka sgmunson)

:-):-):-)

One thing you can count on is that any folder that needs to be accessed by someone will require that the individual have access to the entire path that leads...