• Infinite recursion in SQL Server 2000

    consider a recursive query in SQL.How to handle infinite recursion to make the query evaluation optimized?

    Gomsbk35 pointsBadges:
  • 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,...

    Transom3245 pointsBadges:
  • 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?

    Fw15 pointsBadges:
  • 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?

    TNKR130 pointsBadges:
  • 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...

    a1maida150 pointsBadges:
  • 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...

    Sharx2th5 pointsBadges:
  • xp_fileexist workd in Query window but doesnt in stored procedure

    Hello, I am running on SQL server on my local PC . I am singed onto the PC using a network user. This probelm happens if the SQL server service runs as either Local system or network service. In the server management studio if I go to a query window and enter Declare @result int exec xp_fileexist...

    Kendo5 pointsBadges:
  • 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??

    Gomsbk35 pointsBadges:
  • 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.

    Jaggerdude60 pointsBadges:
  • 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.

    Deb4u50 pointsBadges:
  • 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.

    Macha19735 pointsBadges:
  • 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 ASK 99 C and put into...

    Baatch20 pointsBadges:
  • 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 get a result set that looks like this using a single query...

    Baatch20 pointsBadges:
  • 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

    Johnsmak5 pointsBadges:
  • 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....

    SQLmurali5 pointsBadges:
  • Does SQL support nonlinear recursive queries?

    does sql supports nonlinear recursive queries

    Gomsbk35 pointsBadges:
  • How to create date in SQL Server 2000

    i create a table with attribute date and i want to store date as "Date-Month-year" .what procedure to create a date and how we able to insert the required format by using sql server 2000.

    Malikjavediqbal30 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • How can I write a SQL query to get the database name ?

    How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

    KulkarniMandar5 pointsBadges:
  • How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    For example on an as/400 Data base file, some 10 indexes are created? How would we know which index is been used during Native IO reads or SQL query execution happens on that file during program is being run?

    TNKR130 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following