I am trying to pass a complete query to source qualifier of Informatica powercenter Designer. Since the query is large I cannot parameterize it (limitations of UNIX also comes here). So, is there a …
SQL Server: Best way to concatenate multiple columns?
I am trying to concatenate multiple columns in a query in SQL Server 11.00.3393. I tried the new function CONCAT() but it’s not working when I use more than two columns. So I wonder if that’s the best way to solve the problem: I can’t use COLUMN1 + COLUMN2 because of NULL values. EDIT If I t…
Using inner Join in Solr query
In SQL, I have the query like this SELECT * FROM table1 INNER JOIN table2 ON table1.table1To2Id = table2.table2Id INNER JOIN table3 ON table1.table1To3Id = table3.table3Id How can I …
Rails Activerecord Relation: using subquery as a table for a SQL select statement
Can somebody help me figure out how to write the following SQL using Rails (I’m using Rails 4) Activerecord methods? I know you can do this with find_by_sql but I’d like to preserve the active record relation. Here’s the sql for a postGreSQL db that I’m trying to create: For my subquer…
Does Order of Fields of Multi-Column Index in MySQL Matter
I know the importance of indexes and how order of joins can change performance. I’ve done a bunch of reading related to multi-column indexes and haven’t found the answer to my question. I’m curious if I do a multi-column index, if the order that they are specified matters at all. My guess is…
SSIS Error: External Column for Source out of sync with Data Source columns; How do I remove External Columns?
Query should output a certain list of Items, along with info like store information and manager info. Uses a Cursor to flip through list of various different levels of management, selects relevant …
Calling Stored Procedure while passing parameters from Access Module in VBA
I am working in Access 2010 with a Microsoft SQL Server 2008 backend. I have a stored procedure that inserts new values(supplied by the parameters) into a table. The values assigned to the parameters are obtained from files stored in a folder. The Windows File System is used to scan a particular folder to mak…
Dynamics AX strange index functionality
At work we have a customer which doesn’t allow synchronizing. They have a database trigger which stops all Dynamics’ synchronization stuff. Now we are moving on to a plan where the synchronisation is allowed but I have to make a list of all indexes that do not match between AX and the SQL database…
mysql compare specific date
I have a table which contains a varchar field containing date like ’15 May 2015 – 03:10 am’ I have to compare all date in this table with the current date to retrieve row which are next the current …
How to SUM() for past 3 months for every field in a column
I have a table in MS Access that looks something like this And I want to count for every item in every month, what’s the sum of the past 3/6/12 months and it should look something like this Is there anyway this can be done in SQL queries? Answer Try a self-join on Item and t2.Date <= t1.Date and t2.D…