I run theis procedure against a link server (Quickbooks) It runs with no errors but will not return records. SELECT * FROM QODBC …Customer
Answer Question | October 10, 2010 10:33 PM
openquery, SQL, SQL Express 2008, SQL Query
Hello. I’m dot.net developer, and i’m working a lot with MSQL. My current task is when some user executes select query on database, i should ”catch” the query data. What do i mean is if select query is “select * from UsersTbl where UserID = 5″, i have to get ’5′. Does somebody have any idea where to start??? Thanks [...]
Answer Question | April 9, 2011 8:25 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query
consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?
Answer Question | October 2, 2010 6:52 AM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000
I need help translating a ruby script to SQL query. I’m a SQL noob. Help please. [em]here is the script.[/em] require “rubygems” require “ruport” SQL = <<-EOS SELECT tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle, tv.Clinic, tv.Age, tv.Notes FROM ( /* SECOND LEVEL, this brings out cliniccode from the main query so we [...]
Answer Question | September 22, 2010 2:19 PM
Ruby, SQL Query, SQL Query Parse Data, Sql Script, SQL Server 2000
For a SELECT Query in RPG program if we get -811 SQL error, it means we have got multiple selections in our query. Is it possible to know how many records are selected from the SELECT statement from any field of SQLCA or in some other way?
Answer Question | September 16, 2010 5:40 PM
RPGILE, SQL Query, SQL/400
I have an “Early voter list” table that I queried for matches against a “Dem Voters” table with the results generating a new “Identified Early Dems” table. I would now like to query the “Identified Early Dems” table against the original “Early voter” table and be left with a table of “Early voter non-Dems” but [...]
Answer Question | September 16, 2010 7:02 PM
Access 2003, Access Database, Access query, BASIC, SQL Query
Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG(“MISC” “CODE”), 0008.00 &MISC LEN(4,0) COLHDG(“SHARED CONTAINER” “CODE”) NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL syntax it errors: Token MISC was not valid. Valid tokens: :.
Answer Question | September 16, 2010 4:42 PM
AS/400, SQL Query, SQL Server, V5R4M0
Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?
Answer Question | September 17, 2010 3:13 PM
i5, SQL performance, SQL queries, SQL Query, V6R1
What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??
Answer Question | August 24, 2010 5:28 PM
SQL Query, SQL Server 2000, SQL Server 2000 queries, SQL Server Query
what r the most common errors occurs when creating report on crystal report xi by using oracle (SQl) query.also plz suggest the solutions for thoes errors.
Answer Question | August 17, 2010 3:56 AM
Crystal Reports Errors, Crystal Reports XI, Oracle 10g, SQL Query, Troubleshooting
I’m not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.
Answer Question | August 20, 2010 4:46 PM
Ad Hoc, iSeries Navigator, SQL Query, SQL Scripting
Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.
Answer Question | August 12, 2010 12:37 PM
SQL Query, SQL query optimization, SQL Server, SQL Server 2005, SQL Server Query, SQL tables
Hi again, I have another query to get my head around! I am trying to take an existing table in a database that looks like this Time Type Price Code 09:00:01 BID 99 A 09:00:01 ASK 100 A 09:00:01 BID 99.5 B 09:00:01 ASK 100 B 09:00:02 BID 99.3 A 09:00:03 BID 98.5 C 09:00:03 [...]
Answer Question | August 11, 2010 11:09 AM
Access, SQL, SQL Query, SQLite
Hi there, i was wondering if anyone would be kind enough to help with something i am struggling with… I have a table something like this: Region ID Cost s1 1 v1 s1 2 v2 s1 3 v3 s2 4 v4 s2 5 v5 s2 6 v6 What I am trying to achieve is to [...]
Answer Question | August 11, 2010 10:54 AM
Access, SQL, SQL Query, SQLite
How to select nth row from a table if they are not in any order
Answer Question | July 30, 2010 8:40 AM
SQL, SQL Data Set, SQL Query, SQL tables
Hi Trying to retrive a report from the DataBase using left join on two tables. To get the count of resultant table, I’m using count. But the output shows error. If I comment count statement then the query executes successfully. I feel there is some error in the syntax of the count that I’m using. [...]
Answer Question | July 27, 2010 11:13 AM
SQL 2005, SQL 2005 Database, SQL generated files, SQL Query, SQL Server, SQL Server 2005
Hi, i have one query plz help me on the same…. I am creating the report in oracle report builder 6i, i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. [...]
Answer Question | January 17, 2011 11:11 AM
Oracle development, Oracle Reports, Oracle Reports 6i, Oracle Reports Builder, SQL Query
does sql supports nonlinear recursive queries
Answer Question | July 21, 2010 10:15 AM
SQL, SQL Query, SQL Server, SQL Server Query, SQL Server query optimization
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
Answer Question | February 14, 2012 3:20 PM
SQL 2005, SQL Query, SQL Select, SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server stored procedures, T-SQL
I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is insufficient [...]
Answer Question | March 2, 2012 3:10 PM
SQL Query, SQL Server 2008, SQL Server 2008 error messages, SQL Server database restore, SQL Server restore