Guest User

Less than 30 lines. How do you reduce it to one line of Pick without overstuffing that line?

a guest
Apr 16th, 2023
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.64 KB | Source Code | 0 0
  1. SELECT
  2.     pr.id personid,
  3.     pr.forenames,
  4.     pr.surname,
  5.     pr.membershipnumber,
  6.     pr.renewaldue,
  7.     pr.dateofbirth,
  8.     py.id paymentid,
  9.     CAST(py.creationdatetime AS DATE) [DATE Paid],
  10.     py.creationuserid [Taken BY],
  11.     py.paymentamount,
  12.     CAST(c.bookedoutdatetime AS DATE) [DATE Card Sent]
  13. FROM
  14.     dbo.person pr
  15.     JOIN dbo.payment py ON
  16.         py.personid = pr.id
  17.         AND py.creationdatetime > '01 JAN 2022'
  18.         AND py.paymentmethod = 'CARD'
  19.         AND py.returncode = 1
  20.     LEFT JOIN dbo.card c ON
  21.         c.personid = pr.id
  22.         AND c.bookedoutdatetime > py.creationdatetime
  23.         AND c.hotlisteddatetime IS NULL
  24.  
Advertisement
Add Comment
Please, Sign In to add comment