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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.