User Profile

Collapse

Profile Sidebar

Collapse
snelson476
snelson476
Last Activity: Nov 13 '13, 10:30 PM
Joined: Jul 9 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • snelson476
    replied to I have a list- null, 1,2,3 and am asking for only the 1 but keep getting 1 and null.
    in MySQL
    Code:
    select PATIENT.PAT_MRN_ID as MRN
, PATIENT.PAT_NAME as Patient
, convert(date,HH_EPSD_EVNT_DATES.DATE_OF_EVENT,101) as SOC
, CASE when ZC_ACCT_CLASS_HA.NAME='Home Health' then diagnosis.DX_NAME else hospice.DX_NAME end as 'PRIMARY DX'
, ZC_TEAM_ASSIGNMENT.NAME as TEAM
, ZC_ACCT_CLASS_HA.NAME AS PROGRAM
, hospice.LINE



from HSP_ACCOUNT
inner join ZC_ACCT_CLASS_HA on HSP_ACCOUNT.ACCT_CLASS_HA_C=ZC_ACCT_CLASS_HA.ACCT_CLASS_HA_C
    ...
    See more | Go to post

      Leave a comment:

    • snelson476
      started a topic I have a list- null, 1,2,3 and am asking for only the 1 but keep getting 1 and null.
      in MySQL

      I have a list- null, 1,2,3 and am asking for only the 1 but keep getting 1 and null.

      In a subquery I only want the line 1 from a list of null, 1,2 and 3, but I keep getting line 1 and null. How can I get only line 1?
      Code:
        (select HOSPICE_DX.PAT_ENC_CSN_ID
           , edg.DX_NAME
           , HOSPICE_DX.LINE
            from HOSPICE_DX
           inner join EDG on    HOSPICE_DX.HOSPICE_DX_CODED_ID=edg.DX_ID
         
           ) hospice on PAT_ENC.PAT_ENC_CSN_ID=hospice.PAT_ENC_CSN_ID
      ...
      See more | Go to post
      • snelson476
        started a topic An expression of non-boolean type specified in a context where a condition is expecte
        in SQL Server

        An expression of non-boolean type specified in a context where a condition is expecte

        Using this Where statement I get the error " An expression of non-boolean type specified in a context where a condition is expected".
        Code:
        (PAT_ENC.CONTACT_DATE between team.CARE_TEAM_START_DT and team.CARE_TEAM_END_DT) or 
              (PAT_ENC.CONTACT_DATE >= team.CARE_TEAM_START_DT and team.CARE_TEAM_END_DT isnull )
        If I leave off the or statement I can get it to run, but I have some data that...
        See more | Go to post
        Last edited by Rabbit; Jul 9 '13, 03:48 PM. Reason: Please use code tags when posting code.
        No activity results to display
        Show More
        Working...