Search results for query: *

Yes I read those before I posted. Here is the original sql I wrote that I need to parameterize in Excel that MS Query is not capable of handling graphically which disallows the use of parameters according to the help. select z.customer_id, z.invoice_id, z.invoice_date...

I can swap the P1 for a ? and it still doesn't work in excel but works on SQLPlus. I just used P1 to illustrate parameter. Now if I don't use Microsoft Query and setup the ADO connection with a macro it works just fine. Trying to figure out why I can make it work one way and not the other.

I created a pipelined function in Oracle that runs perfect and returns the data just as I need to have it setup to start running calculations in Excel. I use the Microsoft Query tool and it tells me it can't add my table. The SQL is very simple: SELECT * FROM...

Thank you. I appreciate it.

We have a manager who setup reoccurring meetings with lots of attendees that is no longer with the company. Is there a way to remove those meetings from everyone's calendars without having to log in as them and delete them one at a time? Appreciate the help. Thank you in advance Cassidy

Thank you. Always can count on the answer here. I have been overwhelmed in my life personally and professionally as of late. If you want to catch up offline or on facebook let me know. Cassidy

Basically I am wanting to know how you would take a query that has say 15 rows and turn that into one row comma delimited. The problem I am trying to solve is that I have a work order order that feeds multiple sales orders with different desired want dates. When I prioritize the work order in...

I need to be able to place a filter on a specific table in my 2005 database that when particular users make a request it filters the results so they don't receive information they are not privileged to. Is there a database trigger or stored procedure that I could put in place that would allow...

Correct. there are actually 8 or 9 apps that use the users account to authenticate then it switches to this account to actually process the information. Not the best practice but it is what it is and I have to work with it.

It is protected by a password but problem is that we can't change the password due the impact of the application. One of the authorized users has changed jobs so that has made a need to restrict access by a different means. Does that make sense?

I have a need that when a user tries to log into an Oracle account, in my case an account named SYSADM, that it validates the OSUSER is one of the approved users to use that account. Is this possible with a logon trigger? Thanks Cassidy

I am curious though. The above error to me is acting as though there is an after trigger or something on the database that is has an error in it. I would think it would be permission denied if it were a permissions issue. Would that be the case?

I gave sysadm the privledges using: grant dba to sysadm; Thanks. Cassidy

Something changed in my database that I am unaware of. That change now impacts my ability to create and drop users. I can create and drop users just fine as long as I am using the sys account. The second I use my account that has been granted dba permissions I get the following error...

It works like a champ. Unfortunately my problem exists for another reason. Ah well was worth a shot. Thanks for the direction. Cassidy

Thank you. Cassidy

I thought that might be the case. Is there a way to apply row level security to the table on a delete? Then append a where clause to the delete statement so it never sees the rows? Thanks Cassidy

I have no control over the vendor that wrote the application with the bad code or the ability to make it right. The only fix I have is to make sure the problem code is stopped before it does damage. I can not send an error back to the application because it crashes it. I am trying trying to...

Thansk. Take me a bit to try it out. I will let you know my luck. Thanks Cassidy

I have all my archive logs and would like to create a new database rolled back to a point in time. Is this possible? If so do you have any advice or sites showing how to do that? Thanks Cassidy