Search results for query: *

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

This worked! Thanks Zelgar...you're the best!

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

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.

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

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

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

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 '))

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

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

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

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

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

yes, the select statement does work

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