daily pastebin goal
83%
SHARE
TWEET

Untitled

a guest May 16th, 2018 109 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Select Client.ClientID, dtmServiceEnd, clientname, State, ClientStateID from ClientState
  2. Inner Join Client on ClientState.ClientID = Client.ClientID
  3. INNER JOIN States ON ClientState.StateID = States.StateID
  4. WHERE ClientState.dtmServiceEnd < '" & date1 & "'
  5. And ClientState.dtmServiceEnd >= '" & date2 & "'
  6. And ClientState.AgentID is not null
  7. And ClientState.iStatus != 'Pending' AND Client.ClientStatus != 'Archive'
  8. Order By dtmServiceEnd
RAW Paste Data
Top