79076227

Date: 2024-10-10 21:44:28
Score: 0.5
Natty:
Report link

This was answered earlier today in the comments that are now missing:

SET @summary = 'CCC.dbo.spVendor_Active_Update: Vendor.IsActive (old): [' + Convert(varchar(10), ISNULL(@oldActive, 0)) + ']; (new): [' + Convert(varchar(10), ISNULL(@Active, 0)) + '];';

Adding ISNULL was necessary to convert null bit values to varchar.

Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: jp2code