79737360

Date: 2025-08-16 17:18:09
Score: 1
Natty:
Report link

Woudn't a CTE make sure it is only executed once?

like

CREATE VIEW CHECK_WITH_CTE AS
WITH CHK AS ( 
  SELECT 1 AS Dummy
    WHERE dbo.fn_CheckPermissionTVF(2) = 1
)
SELECT BT.*  
FROM CHK 
CROSS JOIN big_table BT
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • High reputation (-1):
Posted by: Turo