I have the following vba that creates a query in a test Access database. I have two multiple select list boxes. The issue is, i want to be able to select multiple items from “Me![State]” and none …
Tag: sql
MS ACCESS SQL Join Subquery
I have two tables: newparts, storedparts I insert the parts of the newparts, which are not jet in the storedparts into the storedparts: This is working fine so far. Now the Problem: Table storedparts is getting so big that the programm is taking too Long for the join process. My solution: Just compare the newparts not to all parts of
MYSQL Add working days to date
I want to add 5 days to the provided date, but the calculation must skip weekends. I already know how to add 5 days without skipping weekends: SELECT DATE_ADD(`date_field`, INTERVAL 5 DAY) As …
Create Table From Query Access VBA
http://www.techonthenet.com/sql/tables/create_table2.php I have a very complex query that pulls in information from ~10 tables, I’d like to then print those results to a table. Here’s my attempt: Where [DATA OUTPUT TABLE] is intended as the new table name and [Data Export] is the name of the query. Answer Almost immediately found the answer: http://www.w3schools.com/sql/sql_select_into.asp
SP2-0552: Bind Variable “NEW” is not declared
I am trying to learn pl/sql triggers. I am trying to create a simple trigger by tracking tutorial http://www.tutorialspoint.com/plsql/plsql_triggers.htm but I got below error. I searched on the …
Hide characters in email address using an SQL query
I have a very specific business requirement to hide certain characters within an email address when returned from SQL and I have hit the limit of my ability with SQL to achieve this. I was wondering if someone out there would be able to point me in the right direction. Essentially, my business is asking for the following: test@email.com to
SQL exclude wildcard from WHERE
We’ve got a query on SAP which has some potential to cause problems. Somebody put the wildcard (%) into the prompt and of course everything got clogged up. Is there a way to disallow the wildcard in the WHERE, maybe with a CASE or something? The only other alternative I could come up with was to only select the top
Set empty strings (”) to NULL in the whole database
In my database are many text columns where values are empty strings (”). The empty strings need to be set to NULL. I do not know the exact schemas, tables and columns in this database or rather I want to write a general solution which can be reused. How would I write a query / function to find all text
SQL Server stored procedure summing one field with parameter input from C#
Stored procedure has multiple functions. Step One: I need to retrieve an int from a table, SUM it with an @int variable that is user entered. Then store that value back into the same column it was retrieved from. I.E. We have one, we order one, add one because we now have two because that item is already in inventory.
How to keep DropDownList1 selected value after postback?
I have two DropDownLists. Once a DropDownList1 value is selected, DropDownList2 will populate based on Dropdownlist1. But after the page refreshes, the dropdownlist1 selected value is changed to the …