I cannot seem to get this IF statement to step into the Call Expiry part it goes to the else therefore I can only assume there is something wrong with my condition. I’m trying to fetch the contract status from an access table Investment Data WHERE Customer Number is the Customer Number on the current sp…
Tag: sql
Get the lowest Score of each distinct Name and distinct Group
Need to get the lowest Score of each distinct Name and distinct Group. Thank you. Result: Answer
Creating a CTE in Oracle
I am trying to create a CTE in Oracle that doesn’t select from an existing table but instead has data inserted into it. Currently, I am creating a table and then dropping it after the query is done. …
How to use order by on a calculated field in SQL?
How to use order by on a calculated field in SQL? This is giving me ‘Total1’ column does not exist but as you see I have created it and is working if I am not using the order by clause. Answer You can do what Mureinik suggests and use the ordinal notation of ORDER BY 13, which means “order b…
Which is faster in sql: searching for a table, or searching for data in table? [closed]
Say there are 1,000 tables in a database, and each table has 1,000 rows. When I search for single table from these 1,000 tables, is the search time same as that required to search for data within one …
MySQL to fetch all the records based on a month of a year
I have a table and in that table there is a column called date_created, which is in TIME STAMP format 2016-07-20 11:30:15 and while I am fetching record I have to pass only the month and year in my front-end field like (month_no/year) 1/2016, 2/2016, 3/2016….. So I have to fetch all the record based upo…
SQL: SAP Hana if parameter is null, ignore where
I’m passing 3 parameters into my Hana Stored Procedure to use as WHERE clauses, and if the parameter is null, I want the procedure to behave as though that condition doesn’t exist. example: if one of the input parameters is deviceType. if deviceType is null, query should simply be I know I can ach…
VBA Query based on multiple “multiple select list boxes” in Access when not selecting an item from one of the multiple select boxes
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 …
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 new…
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 …