Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KIDDIE

    Modulo Question for SQL Server

    SELECT ACCOUNT_NUMBER, EM_NO + IN_BANK + NT_BANK AS SPA, CURRENT_BALANCE, CYCLE_CODE_99 FROM dbo.MASTER_CUR WHERE ((EM_NO + IN_BANK + NT_BANK) IN ('502650000000', '851190000000')) AND (CURRENT_BALANCE between 1600 AND 5000)and...
  2. KIDDIE

    How to filter Even Numbers

    SELECT ACCOUNT_NUMBER, EM_NO + IN_BANK + NT_BANK AS SPA, CURRENT_BALANCE, CYCLE_CODE_99 FROM dbo.MASTER_CUR WHERE ((EM_NO + IN_BANK + NT_BANK) IN ('502650000000', '851190000000')) AND (CURRENT_BALANCE between 1600 AND 5000)and...
  3. KIDDIE

    Filtering by Even Numbers

    SELECT ACCOUNT_NUMBER, EM_NO + IN_BANK + NT_BANK AS SPA, CURRENT_BALANCE, CYCLE_CODE_99 FROM dbo.NANOMASTER_CUR WHERE ((EM_NO + IN_BANK + NT_BANK) IN ('502650000000', '851190000000')) AND (CURRENT_BALANCE between 1600 AND 5000)and...
  4. KIDDIE

    Even Numbers on SQL Server

    SELECT ACCOUNT_NUMBER, EM_NO + IN_BANK + NT_BANK AS SPA, CURRENT_BALANCE, CYCLE_CODE_99 FROM dbo.NANOMASTER_CUR WHERE ((EM_NO + IN_BANK + NT_BANK) IN ('502650000000', '851190000000')) AND (CURRENT_BALANCE between 1600 AND 5000)and CYCLE_CODE_99...
  5. KIDDIE

    Passthrough Query

    I have extracts in MS SQL Server DTS Package with half of the data I need, the other half of the data needed to complete this query is sitting on an Oracle DB. I am running a passthrough query from MS SQL Server that gets the rest of the data. How can join the tables from MS SQL Server and the...

Part and Inventory Search

Back
Top