You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
30 lines
650 B
30 lines
650 B
|
|
|
|
ALTER TABLE [dbo].[tbl_customer_information]
|
|
ADD DealerSelectedMode varchar(50)
|
|
|
|
ALTER TABLE [dbo].[tbl_customer_information]
|
|
ADD DealerSelectionJobStatus int
|
|
|
|
ALTER TABLE [dbo].[tbl_businessUnit]
|
|
ADD BuCode varchar(10)
|
|
|
|
ALTER TABLE [dbo].[tbl_businessUnit]
|
|
ADD BuSubType varchar(10)
|
|
|
|
UPDATE [dbo].[tbl_businessUnit]
|
|
set BuSubType='KTM' where BuId =1
|
|
|
|
UPDATE [dbo].[tbl_businessUnit]
|
|
set BuCode='PB' where BuId in(1,4)
|
|
|
|
UPDATE [dbo].[tbl_businessUnit]
|
|
set BuCode='MC' where BuId =2
|
|
|
|
|
|
UPDATE [dbo].[tbl_businessUnit]
|
|
set BuSubType='MC' where BuId =2
|
|
|
|
|
|
UPDATE [dbo].[tbl_businessUnit]
|
|
set BuSubType='HUS' where BuId =4
|