I’m trying to find out if anyone is aware of any list of the limitations of NetSuite’s ODBC SuiteAnalytics Connect Service being used through OpenQuery? I’ve been running into many problems with some of my more complex queries failing for no apparent reason, and I finally started narrowing i…
Index and hasmap
In order to ask my question I first need to explain my understanding of both concepts. Actually, my understanding is very vague, so stop me if I’m wrong. Index (btree in SQL): An index is helpful …
INSERT INTO SELECT with CURRENT_TIMESTAMP value
I have a query that takes all data from database A and inserts it into database B. It is working correctly, however I created a new column in database B called “actual_date” and I would like that, …
Finding unique number of IDs in multiple groups
I have a dataset that has doctors and the various practices they work in. Each doctor in my dataset works in at least 1 practice but as many as 17 different practices. I would like to know the unique …
Sql Syntax to tag rows in a table where this specific criteria appears at least once or more
I am using SQL Server 2014 and I have a table (t1) which contains a list of 6 numbers in more than 25,000 rows. Extract of t1 is given below: Id F1 F2 F3 F4 F5 F6 1 5 11 15 …
Python SQL mismatched input ‘Orion’ expecting ‘FROM’
I’m using OrionSDK and I have a python query that keeps returning this error: mismatched input ‘Orion’ expecting ‘FROM’ . Here is the query. Not sure what can be causing this. Thanks in Advance! ”’…
SQL Stored Procedures, Combining rows with derived variables
I’ve been away for sometime and need help with, what is probably a simple solution but at this time I’m stuck. I have this select statement and need to combine rows with like elements for the same department but the group by would have a very large select list, is there another way like MERGE? Her…
MYSQL Trigger update not working as expected when value is updated
Looking to use a trigger on a MYSQL table when the row is updated, anytime the row is updated. Only setting the id if the id field is null Currently nothing is happening when the table row is updated Answer Your code should raise a syntax error, since id and username are undefined variables. If you want to ac…
How to write a select query that returns multiple results based on the booleans in one row (for spring security authorities query)?
I have a Java web app using Spring Security 5. I’m using MySQL as the database. The database table with users in it looks something like this: Spring Security requires me to give it two queries … one to get the users, and one to get the user’s roles. Typically the queries look like this: How…
How to query all occurences of a header of a XML column in SQL Server
I have a table with a column named [xml] of type varchar(max) column with HTML Tables in each line, such as: in a Microsoft SQL Server 2008 R2. I want to know how many occurrences of a table header there is. I have inconsistencies because all headers were supposed to be the same, but they are not. I have to