alter table wrk_sts

add wrk_sts_tim_crd varchar(1) NULL

 

update wrk_sts set wrk_sts_tim_crd = '0'

 

DELETE cf_label

WHERE  table_name = 'wrk_sts'

AND    column_name = 'wrk_sts_tim_crd'

GO

 

INSERT        cf_label (language_cd, table_name, column_name,

              default_label,

              customize_label,

              default_header,

              customize_header,

              cfr_flag, cf_label_required, audit_user, audit_date )

SELECT        language_cd, 'wrk_sts', 'wrk_sts_tim_crd',

              'Timecard Require:',

              'Timecard Require:',

              'Timecard Require',

              'Timecard Require',

              '0', '0', 'admin', getdate()

FROM   cf_language

GO