• 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:
  • Alternative for LEFT OUTER JOIN

    HI all, select code.batchno, detailA.batchfee , detailB.batchfee from Code code left outer join Detail detailA on (detailA.id= code.id) left outer join Detail detailB (detailB.id= code.id) where code.category = categoryA order by code.id I want an alternative for left outer join.. I cannot use left...

    4knowledgexchng20 pointsBadges:
  • SQL SERVER 2005 Security use Kerberos instead of NTLM

    How can I setup sql server 2005 to use kerberos authentication instead of NTLM?

    Rick Martinez585 pointsBadges:
  • Does SQL support nonlinear recursive queries?

    does sql supports nonlinear recursive queries

    Gomsbk35 pointsBadges:
  • error in SQL workbench

    ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

    Whitneyf5 pointsBadges:
  • iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”

    A while back, Seeker1 posted this question.  Unfortuantely, he didn't provide enough information for Tom to help.  Well - I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT  , 'CITY ')  FROM Units Here are the...

    Craig Hatmaker1,855 pointsBadges:
  • SQL Server 2008 Code to find fields containing similar text

    I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word "Smith" Field 2 has "Smith AB" in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 Thanking you in advance

    Davewaltonuk20 pointsBadges:
  • SQL and RPG 400 (SQLRPG) Variable lengths help required.

    Please could someone help me with the following, I am new to SQL and have been tasked with the following:- I am writing an RPG program where the user will be able to do a search by entering up to 15 characters to find part numbers. I know how to do this using SQL but I am struggling with this when...

    AS400Kate15 pointsBadges:
  • How to keep date format when creating Index on a Table

    I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to *DMY. How could I keep the...

    MacroJ20 pointsBadges:
  • I’m interested in creating a web form that will deposit information into a SQL Server database.

    I'm interested in creating a web form that will deposit information into a SQL Server database. What's the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

    Eabouzeid175 pointsBadges:
  • Find the SQL value behind the decimal

    I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?

    Tslake9925 pointsBadges:
  • Event ID: 2803 and 17137 Question

    I have recently installed SQL 2005 Express and Symantec Backup Exec for Windows 2003 SBS. I have not created any backup jobs and do not have an Active SQL DB just yet. However the following Information Events are being logged under Application Event every 5 minutes. Is this normal and is it...

    PCJunkie870 pointsBadges:
  • SQL Writer error message – SQLDUMPER library failed

    error sql writer - sql dumper liabrary failed initialization install corrupt or tamper with

    Mmichals15 pointsBadges:
  • Windows Scheduling iSeries Data Transfer

    I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe...

    Heather4000 pointsBadges:
  • VB updates to DB2 table.

    Why does as DB2 table need journaling when doing updats from VB SQL? Our setup is SQL, link server, local DSN to AS400.

    SittingBull25 pointsBadges:
  • Compare Two Tables With Identical Fields

    Need to compare two tables A & B with identical fields and report when rows don't match and rows from B are missing in A.

    Jaggerdude60 pointsBadges:
  • ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT

    I tried example 6 from the book SQL for Microsoft Access and got the error message" CHARACTERS FOUND AT THE END OF SQL STATEMENT. I tried deleing the first semicolon and got a message: missing semicolon at end of SQL statement. Can anyone tell me what I am doing wrong? Thanks, INSERT INTO Toys...

    Fredking5 pointsBadges:
  • SQL indexes

    hello, there are many indexes clustered an non clustered .so how can i see the result of each index, clustered and non clustered seperately through (T-SQL) pls guide me. RINO

    Fhhdjfhjdhfjhjdfh135 pointsBadges:
  • Count Distribution

    From an input table consisting of YEAR and COUNT, e.g. YEAR COUNT 1999 3 2000 4 2000 7 2000 15 Can a Pivot Table or SQL Query be constructed to output a Yearly Count Distribution? e.g. YEAR 1->9 10->19 20->29 1999   1 2000   2        1 Thanks, JaG

    Jaggerdude60 pointsBadges:
  • Sql Server CAL

    I have a Sql Server Enterprise 2005 64X, installed licesed by processor, I what to cut budget so thougt if I change to CAL licensing could save money, but know how to calculate how many users are currently conecting to my server. How can I get this info?

    Noyo775 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.

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

Following