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!

  • 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. eshie003

    Evaluating records to identify >=3 months of consecutive service and exclude first and last month

    Hi all, I need to evaluate the records to: 1. Find persons who have >=3 months of consecutive data 2. Exclude the first and last month of the consecutive dates 3. The dates span multiple years Here's some test data: --===== If the test table already exists, drop it IF...
  2. eshie003

    Excel VBA - how to select a range of cells containing dups and clearing (not deleting)

    Hi, I modified as I needed to use the ROWID, not Name as identifier. This works great, however, it is deleting the entire row of dups and I only need to delete the dups in A:K while keeping ALL the data intact in L:Z
  3. eshie003

    Excel VBA - how to select a range of cells containing dups and clearing (not deleting)

    I have data in the adjoining columns that correlate with the data in A:K. This is the output from a 1 to many relationship table and I need to keep all the data in L:Z.
  4. eshie003

    Excel VBA - how to select a range of cells containing dups and clearing (not deleting)

    No, this is not a one-time task. I would like to develop code and modify it as needed for other spreadsheets.
  5. eshie003

    Excel VBA - how to select a range of cells containing dups and clearing (not deleting)

    I have a worksheet with duplicate data in columns A:K, however I have additional data in the colums L:Z. I want to loop through the range and if there are duplicates (column A would be the best to evaluate dups on) then I want to keep the first record and clear the remaining dup selection...
  6. eshie003

    Evaluating each record to evaluate datediff and summarize totals within a specific time frame

    Hi, I have a table with over 100K rows. See sample data attached: SBSB_ID From Date Units 780000110 9/14/2011 8 780000110 10/3/2011 8 780000110 10/4/2011 6 780000110 10/5/2011 4 780000110 10/10/2011 3 780000110 12/8/2011 2 780000110 12/9/2011 4 780000110 12/13/2011 8...
  7. eshie003

    Openquery syntax - multiple tables

    I tried that previously and when I modify last line to: AND cmc1.mctn_id='850390576')) I get 2 errors: Msg 102, Level 15, State 1, Line 21 Incorrect syntax near '850390576'. Msg 105, Level 15, State 1, Line 21 Unclosed quotation mark after the character string '))
  8. eshie003

    Openquery syntax - multiple tables

    Hi, In the query below, I want to insert the results of the query into my SQL SVR, table [#TEST]. The linked server (URAFP4 is Oracle). When I run the query below, I am getting an error on the last line of the query" Incorrect syntax near ')'. What am I missing? SELECT * INTO...
  9. eshie003

    Join is not working as expected

    I just tested it and it works! I can't believe how I missed something as simple as this... Thank you, thank you! :-)
  10. eshie003

    Join is not working as expected

    Sorry, typo. Should read TABLE 1.[Code]<>TABLE 2.[Code]
  11. eshie003

    Join is not working as expected

    Hi, I need to capture only those records from Table 1 where there is no match on Table 2 on criteria below: TABLE 1.[Agency]=TABLE 2.[Agency] AND TABLE 1.[Type]=TABLE 2.[Type] AND TABLE 1.[Code]<>=TABLE 2.[Code] TABLE 1 CODE AGENCY TYPE H2015HO MCO MA 90801 MCO MA TABLE 2 CODE AGENCY...
  12. eshie003

    OPENQUERY SYNTAX-INSERTING INTO TABLE FROM LINKED SERVERS

    It works! Thanks so much..I knew the syntax was incorrect and couldn't figure it out. You are the best!
  13. eshie003

    OPENQUERY SYNTAX-INSERTING INTO TABLE FROM LINKED SERVERS

    yes, the select statement does work
  14. eshie003

    OPENQUERY SYNTAX-INSERTING INTO TABLE FROM LINKED SERVERS

    I am trying to create a new table within my SQL SVR database [Medicaid_Retro] called [UNM_Claims_REFERRAL_1] based on SQL SVR table [UNM_Claims_REFERRAL] and joining to Oracle via linked server NMPSEDW. Using the code below, I get the following error: "Invalid object name...

Part and Inventory Search

Back
Top