I like rants.

[toey]

rant on...about anything

[billyskank]

1. You came to the right place.

:)

[mainegreen]

2. I hate writing SQL Queries.

All day every day I write freakin' queries. Link C_CLAIMS up to E_POLICY where x=y, inner join this, left outer join that ON and ON and ON. It never ends. All just so I can get some inane piece of data such as the one I'm working on now: what INT_MEMBER_POLICY_IDs attached to INT_POLICY_IDS have claims in their date range for said policy. Why? So I can make a freakin' view based on it so I can turn around and get the INT_MEMBER_POLICY_IDs on a left outer join that DONT have claims in their date range. Its like this all day every day for the LAST SIX YEARS! RANT RANT RANT

:rant:

[billyskank]

4. I like this one:

SQL> SELECT *
2 FROM users
3 WHERE clue > 0;

No rows returned.
SQL>

[Greyhound]

5. Sorry to hear that dude. But @ least you're still earning a living wage.

How many people do you know that used to do similar stuff that are now working for 1/2 or less than they were 5 years ago?

[mainegreen]

6. A lot. But the insurance industry is safe.

Mostly because it consists of the following:

SELECT dbo.CLAIM.CLAIM_NUMBER, dbo.CLAIM.FILE_NUMBER AS WCBN_NB, dbo.WC_ME_SUPP.DISABILITY_DATE, CASE WHEN disability_date IS NULL
THEN 'n' ELSE 'y' END AS REASON_LOSS_TIME, CASE WHEN '1803' THEN 'y' ELSE 'n' END AS HALF_DAY_PLUS_PAY,
CASE WHEN 1803 THEN 'y' ELSE 'n' END AS LOST_EARNINGS, 'y' AS MEDICAL,
CASE WHEN PERSON_INVOLVED.date_of_death IS NULL THEN 'n' ELSE 'y' END AS DEATH,
dbo.PERSON_INVOLVED.DATE_OF_DEATH AS DTE_OF_DEATH, CASE WHEN IS NULL
THEN 'n' WHEN = 1803 THEN 'y' ELSE 'n' END AS OCC_DISEASE, dbo.WC_ME_SUPP.LAST_EXPOSU_DATE,
dbo.WC_ME_SUPP.DIAGNOSIS_DATE, CASE WHEN IS NULL
THEN 'n' WHEN = 1803 THEN 'y' ELSE 'n' END AS CORRECTION_OF_PRIOR_REPORT,
dbo.WC_ME_SUPP.CORRECTION_DATE, dbo.WC_ME_SUPP.CORRECT_SENT_DATE, CASE WHEN . IS NULL
THEN . ELSE . END AS UIAN_NO_TEXT, CASE WHEN . IS NULL
THEN . ELSE . END AS FEIN,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_NAME,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS
EMPLOYER_NAME_2,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_ADDRESS_1,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_ADDRESS_2,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_CITY,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_STATE,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_ZIP_TOSPLIT,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE . END AS EMPLOYER_PHONE_NUMBER,
CASE WHEN . = 'Medical Center Grp Fun' THEN . ELSE .
END AS NATURE_OF_BUSINESS, dbo.WC_ME_SUPP.ADDR_DIFER_MEMO AS LOCATION_OTHER_BREAK_APART,
CASE WHEN IS NULL THEN 'n' WHEN = - 1 THEN 'y' ELSE 'n' END AS ON_PREMISIS,
dbo.EVENT.ADDR1 AS INJ_LOC_ADDR1, dbo.EVENT.ADDR2 AS INJ_LOC_ADDR2, dbo.EVENT.CITY AS INJ_LOC_CITY,
STATES_3.STATE_ID AS INJ_LOC_STATE, dbo.EVENT.ZIP_CODE AS INJ_LOC_ZIP_TOSPLIT,
CASE WHEN entity_supp_1.NCCI_RPT_CD_CODE = 3118 THEN 2 ELSE 1 END AS INSURER_TYPE, '' AS INSURER_POLICY_NUMBER,
dbo.CLAIM.CLAIM_NUMBER AS INSURER_FILE_NUMBER, dbo.CODES.SHORT_CODE AS NCCI, ENTITY_2.LAST_NAME AS EMPLOYEE_LAST_NAME,
ENTITY_2.FIRST_NAME AS EMPLOYEE_FIRST_NAME, LEFT(ENTITY_2.MIDDLE_NAME, 1) AS EMPLOYEE_MI,
ENTITY_2.PHONE1 AS EMPLOYEE_PHONE, dbo.EMPLOYEE.EMPLOYEE_NUMBER AS SSN, CODES_1.SHORT_CODE AS GENDER,
ENTITY_2.ADDR1 AS EMPLOYEE_ADDR_1, ENTITY_2.CITY AS EMPLOYEE_CITY, STATES_4.STATE_ID AS EMPLOYEE_STATE,
ENTITY_2.ZIP_CODE AS EMPLOYEE_ZIP_TOSPLIT, ENTITY_2.BIRTH_DATE, dbo.CODES_TEXT.CODE_DESC AS JOB, dbo.EMPLOYEE.DATE_HIRED,
dbo.EMPLOYEE.PAY_AMOUNT AS WEEKLY_WAGE, CASE WHEN IS NULL
THEN 'n' WHEN = 1803 THEN 'y' ELSE 'n' END AS WORK_FOR_ANOTHER,
dbo.WC_ME_SUPP.OTHER_EMPLOYR_MEMO AS WORK_ANOTHER_ADDRES, dbo.EVENT.DATE_OF_EVENT AS ILLNESS_INJURY_DATE,
dbo.EVENT.DATE_REPORTED, dbo.WC_ME_SUPP.DISABILITY_DATE AS INCAPACITY_DATE,
dbo.WC_ME_SUPP.NOTIFIED_TPA_DATE AS DTE_EMPLOYER_NOTIFIED_OF_INCAPACITY, dbo.PERSON_INVOLVED.WORKDAY_START_TIME,
dbo.CLAIM.DATE_OF_CLAIM AS DTE_EMPLOYER_NOTIFY_INSURER, dbo.EVENT.TIME_OF_EVENT AS TIME_OF_INJURY,
CASE WHEN IS NULL
THEN 'n' WHEN = 1803 THEN 'y' ELSE 'n' END AS EMPLOYEE_RETURNED_TO_WORK,
dbo.PERSON_INVOLVED.EST_RTW_DATE AS DTE_RETURNED_TO_WORK,
CASE WHEN . = 'Injuries' THEN . ELSE . END AS SPECIFIC_INJURY,
CODES_TEXT_4.CODE_DESC AS BODY_PART, '' AS OBJECTS_USED, '' AS SPECIFIC_ACTIVITY, CASE WHEN IS NULL
THEN 'n' WHEN = 1803 THEN 'y' ELSE 'n' END AS SPECIFIC_ACTIVITY_PART_OF_NORMAL_JOB_DUTIES,
dbo.EVENT.EVENT_DESCRIPTION AS INJURY_EVENTS, '' AS HOSPITALIZED_OVERNIGHT, '' AS HEALTH_CARE_NAME, '' AS HEALTH_CARE_NAME2,
'' AS HEALTH_CARE_ADDRESS1, '' AS HEALTH_CARE_ADDR2, '' AS HEALTH_CARE_CITY, '' AS HEALTH_CARELSTATE, '' AS HEALTH_CARE_ZIP5,
'' AS HEALTH_CARE_ZIP4, '' AS HEALTH_CARE_PHONE, dbo.CLAIM_SUPP.PREP_NAME_TEXT, dbo.CLAIM_SUPP.PREP_TITLE_TEXT,
'' AS PREPARER_TEL, CAST(DATEPART(mm, GETDATE()) AS VARCHAR(2)) + CAST(DATEPART(dd, GETDATE()) AS VARCHAR(2)) + CAST(DATEPART(yyyy,
GETDATE()) AS VARCHAR(4)) AS DATE_SENT_TO_WCB, 'ME' AS JURUSDICTION, ENTITY_SUPP_2.UIAN_SIT_TEXT AS EMPLOYER_SITE_NUMBER,
'' AS REPORT_ONLY, 'XXX CLAIMS MANAGEMENT SERVICES' AS CLAIM_ADMIN_NAME, 'XXXXXXXXX' AS CLAIM_ADMIN_FEIN,
'' AS CLAIM_ADMIN_ATTN_LINE, 'XXXXX' AS CLAIM_ADMIN_ADDR_1, '' AS CLAIM_ADMIN_ADDR2, 'XXXX' AS CLAIM_ADMIN_CITY,
'ME' AS CLAIM_ADMIN_STATE, 'XXXXXXXX' AS CLAIM_ADMIN_ZIP
FROM dbo.CODES_TEXT CODES_TEXT_1 RIGHT OUTER JOIN
dbo.STATES STATES_4 RIGHT OUTER JOIN
dbo.EMPLOYEE RIGHT OUTER JOIN
dbo.STATES STATES_5 RIGHT OUTER JOIN
dbo.ENTITY ENTITY_4 ON STATES_5.STATE_ROW_ID = ENTITY_4.STATE_ID LEFT OUTER JOIN
dbo.ENTITY_SUPP ENTITY_SUPP_3 ON ENTITY_4.ENTITY_ID = ENTITY_SUPP_3.ENTITY_ID RIGHT OUTER JOIN
dbo.CLAIM INNER JOIN
dbo.EVENT ON dbo.CLAIM.EVENT_ID = dbo.EVENT.EVENT_ID INNER JOIN
dbo.ORG_HIERARCHY ON dbo.EVENT.DEPT_EID = dbo.ORG_HIERARCHY.DEPARTMENT_EID INNER JOIN
dbo.ENTITY ON dbo.ORG_HIERARCHY.COMPANY_EID = dbo.ENTITY.ENTITY_ID INNER JOIN
dbo.POLICY ON dbo.CLAIM.PRIMARY_POLICY_ID = dbo.POLICY.POLICY_ID INNER JOIN
dbo.ENTITY ENTITY_1 ON dbo.POLICY.INSURER_EID = ENTITY_1.ENTITY_ID INNER JOIN
dbo.STATES ON dbo.ENTITY.STATE_ID = dbo.STATES.STATE_ROW_ID INNER JOIN
dbo.STATES STATES_1 ON ENTITY_1.STATE_ID = STATES_1.STATE_ROW_ID INNER JOIN
dbo.STATES STATES_2 ON dbo.CLAIM.FILING_STATE_ID = STATES_2.STATE_ROW_ID INNER JOIN
dbo.EDI_TODAYS_DISTINCT_CLAIMS ON dbo.CLAIM.CLAIM_ID = dbo.EDI_TODAYS_DISTINCT_CLAIMS.CLAIM_ID ON
ENTITY_4.ENTITY_ID = dbo.ORG_HIERARCHY.FACILITY_EID LEFT OUTER JOIN
dbo.ENTITY_SUPP ON dbo.ENTITY.ENTITY_ID = dbo.ENTITY_SUPP.ENTITY_ID LEFT OUTER JOIN
dbo.WC_ME_SUPP ON dbo.CLAIM.CLAIM_ID = dbo.WC_ME_SUPP.CLAIM_ID LEFT OUTER JOIN
dbo.PERSON_INVOLVED ON dbo.EVENT.EVENT_ID = dbo.PERSON_INVOLVED.EVENT_ID LEFT OUTER JOIN
dbo.STATES STATES_3 ON dbo.EVENT.STATE_ID = STATES_3.STATE_ROW_ID LEFT OUTER JOIN
dbo.ENTITY_SUPP ENTITY_SUPP_1 ON ENTITY_1.ENTITY_ID = ENTITY_SUPP_1.ENTITY_ID LEFT OUTER JOIN
dbo.CODES ON ENTITY_SUPP_1.NCCI_RPT_CD_CODE = dbo.CODES.CODE_ID ON
dbo.EMPLOYEE.EMPLOYEE_EID = dbo.PERSON_INVOLVED.PI_EID LEFT OUTER JOIN
dbo.ENTITY ENTITY_2 ON dbo.PERSON_INVOLVED.PI_EID = ENTITY_2.ENTITY_ID LEFT OUTER JOIN
dbo.CODES CODES_1 ON ENTITY_2.SEX_CODE = CODES_1.CODE_ID ON STATES_4.STATE_ROW_ID = ENTITY_2.STATE_ID LEFT OUTER JOIN
dbo.CODES_TEXT ON dbo.EMPLOYEE.POSITION_CODE = dbo.CODES_TEXT.CODE_ID ON
CODES_TEXT_1.CODE_ID = dbo.PERSON_INVOLVED.DISABILITY_CODE LEFT OUTER JOIN
dbo.PI_X_INJURY LEFT OUTER JOIN
dbo.CODES_TEXT CODES_TEXT_2 ON dbo.PI_X_INJURY.INJURY_CODE = CODES_TEXT_2.CODE_ID ON
dbo.PERSON_INVOLVED.PI_ROW_ID = dbo.PI_X_INJURY.PI_ROW_ID LEFT OUTER JOIN
dbo.CODES_TEXT CODES_TEXT_3 ON dbo.PERSON_INVOLVED.ILLNESS_CODE = CODES_TEXT_3.CODE_ID LEFT OUTER JOIN
dbo.PI_X_BODY_PART LEFT OUTER JOIN
dbo.CODES_TEXT CODES_TEXT_4 ON dbo.PI_X_BODY_PART.BODY_PART_CODE = CODES_TEXT_4.CODE_ID ON
dbo.PERSON_INVOLVED.PI_ROW_ID = dbo.PI_X_BODY_PART.PI_ROW_ID LEFT OUTER JOIN
dbo.CLAIM_SUPP ON dbo.CLAIM.CLAIM_ID = dbo.CLAIM_SUPP.CLAIM_ID LEFT OUTER JOIN
dbo.ENTITY ENTITY_3 ON dbo.ORG_HIERARCHY.FACILITY_EID = ENTITY_3.ENTITY_ID LEFT OUTER JOIN
dbo.ENTITY_SUPP ENTITY_SUPP_2 ON ENTITY_3.ENTITY_ID = ENTITY_SUPP_2.ENTITY_ID

:nuke:

[Greyhound]

7. Hahaha! Great reply! lmao!

:rofl:

[Rabrrrrrr]

3. I don't. I find them sophomoric and unhelpful, even hurtful, to the cause