What are the challenges you face when working across database platforms? Take the survey
Options

Bug / AS

Hi Team,


; WITH
duplicates_cte AS
(
SELECT
*
  , HASHBYTES (
  'MD5'
, CONCAT (
TRIM ('_.|' FROM requestId)
   ,  eventTime
)
  ) AS hashId
  FROM sys.objects
  )
  SELECT * FROM duplicates_cte;

SQL Prompt will add an AS before evenTime and the code becomes invalid.
Thanks for fixing!

Torsten
MVP 

Answers

Sign In or Register to comment.