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

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

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

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

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