Viewing 12 posts - 1 through 12 (of 12 total)
This is on our test system, not production, they have no access to production. Our test system mirrors production though and so the rights are inforced.
Mike
October 6, 2004 at 4:01 pm
Nice!
You are exactly correct. I have a noparam stored proceedure they just have to execute. Takes about 3 sec. I will slap them for you! They are complaining because our...
October 6, 2004 at 3:58 pm
Sorry,
Here is a bit more detail. Our developers have rights to create Stored Procedures but cannot control what rights are assigned to them. We have a table that defines rights...
October 6, 2004 at 3:40 pm
I thought of that, but the scheduled execution is not an option. We have some very specific security definitions on our Stored Procedures and I need to set a...
October 6, 2004 at 3:29 pm
I thought of that, but the scheduled execution is not an option. We have some very specific security definitions on our Stored Procedures and I need to set a bunch...
October 6, 2004 at 3:09 pm
Jeff,
Thanks for the information. I quess I should have included some additional information, sorry. We will have no direct access to the VAX and they are strictly ftping the raw...
April 2, 2004 at 1:21 pm
Thanks all, the staging table is what I am currently doing. I was just wondering if there was a better way of if I was missing something. Thanks for the...
January 7, 2004 at 9:25 am
Thanks David,
That is exactly the way I currently have it structured. I read the columns in and do a for loop running the sql each time through the loop. I...
August 2, 2003 at 3:58 am
Nevermind, I ran the table through a dts to make it a bit more relational, created a view that included a prof bit based on the key table calculation and...
May 18, 2003 at 3:48 pm
Thanks a bunch,
That was exactly the problem. I joined it to a table with multiple rows, when it should have been joined to a table one level higher in the...
April 17, 2003 at 9:56 am
Ok, I got the averages by creating both a SUM measure and a count measure for each score (reading, math,writing) I then created a calculated measure for each score in...
April 11, 2003 at 2:04 am
Thanks a bunch, I am well on my way. I have a cube with everything I need but averages. I have sums. You mention switching the aggragate functions to averages,...
April 11, 2003 at 1:25 am
Viewing 12 posts - 1 through 12 (of 12 total)