Align = in MERGE statement

• 
  Hi RichardMGreen,
  
  Thanks for posting on the Redgate forums.
  
  It might be that this is a feature request, but to confirm could you please show a before and after code sample of what you are expecting to see?

  Dan B May 06, 2019 09:07

  - 0 +
• 
  Hi Dan

  This is what we currently get:-

  WHEN MATCHED THEN

  UPDATE

  SET

  TARGET.fkPatientLocalID= SOURCE.PatientLocalID

  ,TARGET.fkStaffLocalID= SOURCE.StaffLocalID

  ,TARGET.EpisodeStartDateTime= SOURCE.EpisodeStartDateTime

  ,TARGET.EpisodeEndDateTime= SOURCE.EpisodeEndDateTime

  ,TARGET.MainSpecialtyLocalCode= SOURCE.MainSpecialtyLocalCode

  ,TARGET.MainSpecialtyLocalDescription= SOURCE.MainSpecialtyLocalDescription

  ,TARGET.MainSpecialtyNationalCode= SOURCE.MainSpecialtyNationalCode

  ,TARGET.MainSpecialtyNationalDescription= SOURCE.MainSpecialtyNationalDescription

  ,TARGET.TreatmentFunctionLocalCode= SOURCE.TreatmentFunctionLocalCode

  ,TARGET.TreatmentFunctionLocalDescription= SOURCE.TreatmentFunctionLocalDescription

  ,TARGET.TreatmentFunctionNationalCode= SOURCE.TreatmentFunctionNationalCode

  ,TARGET.TreatmentFunctionNationalDescription= SOURCE.TreatmentFunctionNationalDescription

  ,TARGET.IsDeleted= SOURCE.IsDeleted

  ,TARGET.SYSDateLastUpdated= @Today

  
  

  
  

  This is what we'd like to see:-

  
  

   

  WHEN MATCHED THEN

  UPDATE

  SET

  TARGET.fkPatientLocalID                         = SOURCE.PatientLocalID

  ,TARGET.fkStaffLocalID                          = SOURCE.StaffLocalID

  ,TARGET.EpisodeStartDateTime                    = SOURCE.EpisodeStartDateTime

  ,TARGET.EpisodeEndDateTime                      = SOURCE.EpisodeEndDateTime

  ,TARGET.MainSpecialtyLocalCode                  = SOURCE.MainSpecialtyLocalCode

  ,TARGET.MainSpecialtyLocalDescription           = SOURCE.MainSpecialtyLocalDescription

  ,TARGET.MainSpecialtyNationalCode               = SOURCE.MainSpecialtyNationalCode

  ,TARGET.MainSpecialtyNationalDescription        = SOURCE.MainSpecialtyNationalDescription

  ,TARGET.TreatmentFunctionLocalCode              = SOURCE.TreatmentFunctionLocalCode

  ,TARGET.TreatmentFunctionLocalDescription       = SOURCE.TreatmentFunctionLocalDescription

  ,TARGET.TreatmentFunctionNationalCode           = SOURCE.TreatmentFunctionNationalCode

  ,TARGET.TreatmentFunctionNationalDescription    = SOURCE.TreatmentFunctionNationalDescription

  ,TARGET.IsDeleted                                = SOURCE.IsDeleted

  ,TARGET.SYSDateLastUpdated                      = @Today

  
  

  Hopefully the above makes sense.

  If not, I can post screenshots if that is an option.

  
  

  Thanks
  
  Richard

  rmg1 May 07, 2019 10:10

  - 0 +
• 

  Hi Dan

  
  

  Found the option to attach a screenshot.

  This is what we'd like to see.

  
  

  Thanks
  
  Richard
  

  rmg1 May 07, 2019 10:13

  - 0 +
• 
  I have spoken to the team about this and currently, there isn't a way for this to be achieved inside SQL Prompt. We have created a feature request for this but I can't guarantee that this will gather enough momentum to make it into the product in the future.

  Dan B May 13, 2019 15:11

  - 0 +
• 

  Thanks Dan.

  
  

  Is there any way for me to help this gain some momentum?

  
  

  Regards
  
  Richard
  

  rmg1 May 13, 2019 15:15

  - 0 +
• 

  Dan B said:

  I have spoken to the team about this and currently, there isn't a way for this to be achieved inside SQL Prompt. We have created a feature request for this but I can't guarantee that this will gather enough momentum to make it into the product in the future.
  
  
  
  We think this is one of the biggest flaws of the formatting prompt style. This is also the case for an update statement. What is the status the feature request?

  EricFranken June 11, 2024 14:10

  - 0 +

Add comment

Please sign in to leave a comment.