This query is throwing an error on firebird, how to resolve that error? SELECT EMPNO,SAL FROM EMP E where EMPNO = (SELECT MAX(DEPTNO) FROM DEPT D WHERE E.ENAME NOT like (SELECT …
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 …
Can’t retrieve data from Access DB query to my VB program
So this is my code so far… I have 2 DateTimePickers in which the user selects the first day of the week and the last day of the week, once selected these two I want to calculate the hours worked on each day and add them so I can display the amount of hours worked of the interval of days