Search results for query: *

Here is the table structure. How can I display the data into one column (Access) grouped on User_ID and Group columns (see Expected Result) Group DT ACCESS USER_ID TAG 01/01/2019 U JOHNS TAG 01/01/2019 R JOHNS FIR 01/02/2009 R SAMS Result: Group DT...

How do I replace a specific word in a string using SQL Example: This is a test for school. Replace the 'TEST' with 'BOOK' - This is a BOOK for school.

Changed Exec with Call and this surely did the trick..

I now encounter this error message. Issue with calling the SP: Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00900: invalid SQL statement

Please note I am able to add a simple SELECT statement in the sQL string and it works fine and I am also able to run the SP via PL/SQL however I cannot execute the SP... I

For some reason I cannot execute this Stored procedure VIA ASP. Here is my code: <% dim db_conn db_conn = "Provider=MSDAORA;Data Source=Pilot;User Id=USer1;Password=SecretPassword;" set conn = server.createobject("adodb.connection") set Cmd = Server.CreateObject("ADODB.Command")...

That is an excellent idea... Let me give that a try... Stay tuned...

We have a ticket system with a SQL Server backend. We want to grant a developer READ ONLY access to a specific table however we need to have additional security. We dont want the developer to have access to all the contents of that table. Is there a way to limit what type of data the user can...

I am trying to determine the Active Directories username when loading the ASP page... How can I do this?

Amount Amount Date 123 1/1/2010 4500 2/5/2010 5500 3/5/2010 5678 4/5/2010 10000 6/6/2010 2500 8/8/2010 3500 12/8/2010 5000 13/8/2010 Expected Result: 3500 12/8/2010 (first record (date of highest amount +2 record) 2500 8/8/2010 (first record...

Before and after based on Amount Date (Col2)

Hello, How can I query: 1) Return the Highest Amount (col1) and return both Amount (Col1) and Amount Date (Col2) 2) Return the two records before that Amount Date (Col2) from Item 1 3) Return the two records after that Amount Date (Col2) from Item 1 There should be 5 records total: The...