• SQL Server 2000 script

    Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item's price with second max(effective_date). Thanks in advance.

    Beginer200825 pointsBadges:
  • SQL statement exceeding 2000 characters in Oracle Graphics Builder

    In Developer 6i Graphics Builder, i am not able to write query exceeding 2000 character. i think it is restriction in this version. If I want to write query exceeding 2000 then please suggest me what to do.

    44063860 pointsBadges:
  • How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • SQL error. There is already an object named ‘InitCap2′ in the database.

    I am running the following code in Microsoft SQL Server Management Studio Express, and after I run it, I get the following error, even though it is returning the record set that I am looking for. I would like to get rid of this error. Thanks. The error is: Msg 2714, Level 16, State 5, Procedure...

    Mmoreno5 pointsBadges:
  • SQL Find a number between the given ranges of number / Find a row which has range of given number

    I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value in...

    Bsethi245 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • SQL Error

    SQSQL Error :Component SARWFNUM:SQLSTATE 37000L Error :Component SARWFNUM:SQLSTATE 37000SQL Error :Component SARWFNUM:SQLSTATE 37000

    Odunsi5 pointsBadges:
  • Round GPA to tenths and remove decimal in SQL

    I have a field in a table, ACT_OVGPA that represents a student's current overall gpa. The field is a 2 digit number on a scale of 00-40 where I believe there is an implied decimal point and actually represents 0.0 - 4.0. This is what I have written, but it returns an error "too many values". Can...

    Cmyers40 pointsBadges:
  • Does similar ClearPool() from .NET Framework 2.x exist in .NET Framework 1.x

    I'm looking for a method similar to the ClearPool() from .Net Framework 2.x but this method must work in .Net Framework 1!

    alessandro.panzetta9,725 pointsBadges:
  • SQL Writer

    SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?

    Wnic5 pointsBadges:
  • I want to retrieve always the first record via sql

    I want to retrieve always the first record of a group of records i.e. a history of sold articles, I want to see the date of every first sold article

    Fra90820 pointsBadges:
  • Converting SQL data to Microsoft Access through coding in VB.NET

    I have tables in SQL and i want to port them to MS access through coding in VB.NET

    Kiti15 pointsBadges:
  • Fastest “get duplicates” SQL

    What is an example of a fast SQL to get duplicates in datasets with hundreds of thousands of records. I typically use something like: select afield1, afield2 from afile a where 1 < (select count(afield1) from afile b where a.afield1 = b.afield1);

    Mm201010 pointsBadges:
  • SQL Queries

    pls any one help me I Need to disply in o/p only alphabets but not any numbers or integers for this i/p as follows i/p o/p ----- ---------- 1.2NE NE 1.1NN NN 1.3.1NE NE 1.1CE CE 1.2.2NN NN 1.6.2NN NN 1.3CE CE 1.3CE CE 1.1 --- 2 ---- 11 -- THANKS IN ADVANCE SURENDRA

    Ecsbc35 pointsBadges:
  • SQL query to select highest test score

    I am writing a sql to bring someone's highest test score into a table. The sql is bringing in the highest test score possible, rather than the person's test score. I assume MAX is making that happen. If I take MAX out, it returns the single row subquery returns more than one row error. What can I...

    Cmyers40 pointsBadges:
  • Two programs with separate SQL Databases

    I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

    Cstanley25 pointsBadges:
  • SQL to pull consecutive numbers rows

    Hello, I have a table with these sample recs. ColA ColB ColC 00100 295.00 295.00 00100 295.01 295.01 00100 295.02 295.02 00100 295.03 295.03 00100 295.04 295.04 00100 295.05 295.05 00100 295.10 295.15 00100 295.98 295.98 What SQL query (prefers not to use cursor if possible since it will involves 2...

    WarrenDar5 pointsBadges:
  • Update help needed

    I need to perform an update as follows... Update LIBNAME.SDFILE Inner Join LIBNAME.DXFILE On SDPRDC = DXPRDC And SDSENO = DXSENO And SDORNO = DXORNO And SDLINE = DXLINE Set DXDNAM = '', DXDAD1 = '', DXDAD2 = '', DXDAD3 = '', DXDAD4 = '', DXDPCD = '', DXINVN = 0 Where SDIECD = 'SO' And SDCDAT <...

    SBatSI415 pointsBadges:
  • Limit admin access to a single database SQL2005

    I want to set up an account similar to sa but limit the rights to a particular db.

    Cybx10 pointsBadges:
  • iSeries RPG Embedded SQL Performance

    Hi, I'm trying to replace some long running Query/400 jobs with RPG and embedded SQL. Some of the existing jobs run for almost 24 hours on our machine. I've already successfully managed to reduce a few of these jobs to a matter of minutes using embedded SQL. So far, so good. My problem is when...

    Gilly40023,730 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