Views + OUTER APPLY

• lanky_doodle

  SSCrazy

  Points: 2378

  More actions

  April 15, 2013 at 4:13 am

  #276494

  Hey,

  SQL Views don't seem to like OUTER APPLY, so is there an alternative (I know they work, just not in Diagrams etc.).

  This is what I need to achieve;

  OUTER APPLY

  (SELECT TOP 1 acr.ACR_ACT_Code

  FROM [Activity Records] acr

  WHERE acr.ACR_Clock_No = cr.CLK_Clock_No AND CONVERT(date, acr.ACR_Shift_Date) = CONVERT(date, cr.CLK_Shift_Date)

  ORDER BY acr.ACR_Start_Date + acr.ACR_Start_Time DESC) acr

  Thanks