The error message is kinda vague... The query below works on one server, but fails on another: INSERT INTO searches (status, uid, datecreated, searchname, options) VALUES (0, 1, NOW(), 'TEST', '16') RETURNING sid; And I get this error: Query failed: ERROR: syntax error at or near "RETURNING" Am I missing something here? ...
I am using the Select query as SELECT id, ordering FROM `jos_menu` WHERE ordering='".$rec['ordering'] -'1' ."' AND parent = '0' Here I need all the records whose ordering is less than 1 of the selected record's order($rec['ordering'] = getting from other select query ) when I am trying to echo the query I am not getting complete stat...
Hi is there any way to debug a SQL Server 2008 query ? Thanks in advance ...
I received reports that a my report generating application was not working. After my initial investigation, I found that the SQL transaction was timing out. I'm mystified as to why the query for a smaller selection of items would take so much longer to return results. Quick query (averages 4 seconds to return): SELECT * FROM Payroll WH...
Not sure if I am using the correct term, but it's not child/parent since they aren't nested objects. In my application I've got a User, UserUserGroup, and UserGroup objects which are pretty standard, UserUserGroup is a linking object with corresponding IDs. I am using Linq-to-SQL so unforunately it doesn't used nested objects, but it sti...
I have a column that contains page titles, which has the website name appended to the end of each. (e.g. Product Name | Company Name Inc.) I would like to remove the " | Company Name Inc." from multiple rows simultaneously. What SQl query commands (or query itself) would allow me to accomplish this? To re-illustrate, I want to convert m...
We're using TFS with MSF for Agile 4.2 on a project, and I have a bunch of work to do, both Tasks and Bugs. Both are prioritized by our managers, and assigned due dates and target releases. I use a Work Item query as my main TODO list, and I want to list all the Work Items assigned to me, in order by due date and priority. Problem: I...
Coldfusion Report Builder is great. One small issue. We use ANT+CFANT to deploy. When we create the report, say in a datasource called MyApp_dev on a dev box. Our other server is the production server. It also contains a staging build to ensure everything is going smoothly before we publish to live. (thanks to Al Everett for bringi...
I'm trying to do a very simple search from a list of terms terms = ['term1', 'term2', 'term3'] How do I programmatically go through the list of terms and construct the "conditions" from the list of terms so that I can make the query using filter and or_ or _and? e.g. query.filter(or_(#something constructed from terms)) ...
I have a table with these columns: win, los, id ... I want to order the table by this index: win / ( win + los ) * 30 + win / SUM(win) * 70 and then to find the rank for two id's. I'm not very good on mysql, so what I wrote is totally wrong. (It uses Perl + DBI + DBD::mysql): $stmt=$con->prepare("SET @rk := 0"); $stmt=$con->prep...
I need to performance tune following SQL query by removing "OR" statements Please help ... SELECT a.id, a.fileType, a.uploadTime, a.filename, a.userId, a.CID, ui.username, company.name companyName, a.screenName FROM TM_transactionLog a, TM_userInfo ui, TM_company company, TM_airlineCompany ac WHERE ( a.CID = 3049 )...
This query gives an error: select ep, case when ob is null and b2b_ob is null then 'a' when ob is not null or b2b_ob is not null then 'b' else null end as type, sum(b2b_d + b2b_t - b2b_i) as sales from table where ... group by ep, type Error: ORA-00904: "TYPE": invalid identifier When I run it with group by ep, the...
This is a situation I'm generally facing while writing SQL queries. I think that writing the whole column (e.g. long case expressions, sum functions with long parameters) instead of aliases in GROUP BY expressions makes the query longer and less readable. Why doesn't Oracle SQL allow us to use the column aliases in GROUP BY clause? There...
Problem: A Database collumn has a Tristate (0,1,2). Each of the values are used serversidely. The Clientcode (which cant be changed anymore) is only able to understand '0,1'. In the Clients view '1' is identic with '2'. So I want to change the SQL Query in the Database to return '1', if the specific value is > 0. My current Solution ...
"ALTER TABLE tablename AUTO_INCREMENT = 10000000 " taking long time to update. why? i need to get optimize this query. Please help ...
Hi there I use MS Access as a front end to my MS SQL server. When I use a SQL query in ms Access that is (in my opinion) equivalent to a query I run from the SQL server, Access returns different data. The pictures below illustrate the difference. I use Access 2003 and I have connected the Access table to the SQL server (2008) through O...
Hi, This is what I'm trying to do something similar to the following request, but I don't know if it's possible with the SQL-Server syntax: declare @idClient int select @idClient=idClient from table where entite is null and (SELECT * from table where entite=@idClient) is null Thanks. ...
Lets say I have a database of widgets. I am showing a list of the top ten groupings of each widget, separated by category. So lets say I want to show a list of all widgets in category A, but I want to sort them based on the total number of widgets in that category and only show the top 10 groupings. So, my list might look something lik...
table1 (id, name) table2 (id, name) Query: SELECT name FROM table2 -- that are not in table1 already ...
I've been working on this for a few hours now and can't find any help on it. Basically, I'm trying to strip a SQL string into various parts (fields, from, where, having, groupBy, orderBy). I refuse to believe that I'm the first person to ever try to do this, so I'd like to ask for some advise from the StackOverflow community. :) To unde...