SET ANSI_NULLS, QUOTED_IDENTIFIER ON
UPDATE [IHR].[dbo].[ITEMS] SET [ACTV]=0 WHERE [ACTV]=1
UPDATE [IHR].[dbo].[ITEMS] SET [ACTV]=1 WHERE [LOGICALREF] NOT IN (SELECT CARDREF FROM  [UNIVERSALDB].[dbo].[LG_011_PRCLIST] WHERE PTYPE=2) OR LOGICALREF IN (SELECT LOGICALREF FROM  [UNIVERSALDB].[dbo].[LG_011_ITEMS] WHERE ACTIVE=1)
DROP TABLE [IHR].[dbo].[1aUNI_malzeme_listesi]
 SELECT * 
  INTO [IHR].[dbo].[1aUNI_malzeme_listesi]
  FROM [IHR].[dbo].[MALZEME_LISTESI]
  CREATE INDEX son_malzeme_listesi
  ON [IHR].[dbo].[1aUNI_malzeme_listesi] ([REF])