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.

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")...

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?

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...