openquery no records returned SQL Express 2008
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

MSQL Auditing
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

Infinite recursion in SQL Server 2000
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

Translate Ruby Script to SQL Query?
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

Embedded SQL in RPGILE
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

Basic Access Database query question
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

Query Manager Error
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?
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?
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 are the most common errors that occur when creating report on crystal report xi by using oracle (SQL) 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

iSeries Navigator SQL Script Output
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

Joining 3 tables in SQL Server 2005
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

SQL Query to consolidate rows into new table
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

SQL Query to get the difference from average for every row with grouping
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

SQL query How to select nth row from a table if they are not in any order
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

SQL-Using count and inner join in a single query
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

Oracle Reports Builder
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 support nonlinear recursive queries?
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

Calling stored procedure in a database to query data in another database
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

SQL Server 2008 Restore Fails – There is insufficient system memory in resource pool ‘internal’ to run this query
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