CREATE UNIQUE NONCLUSTERED INDEX [NCI_Wms_MaterialBoxMaster_BoxCode_BoxTypeFlag]
ON [dbo].[Wms_MaterialBoxMaster]([BoxCode] ASC)
WHERE [BoxTypeFlag] = 3
CREATE UNIQUE NONCLUSTERED INDEX [NCI_Wms_MaterialBoxMaster_BoxCode_BoxTypeFlag]
ON [dbo].[Wms_MaterialBoxMaster]([BoxCode] ASC)
WHERE [BoxTypeFlag] = 3