CREATE VIEW dbo.GECICI
AS
 SELECT CODE,CODE2,REF,ROW_NUMBER() OVER(PARTITION BY CODE2 ORDER BY CODE) AS SIRALA  FROM [IHR].[dbo].[MALZEME_LISTESI_HIZLI] WHERE CODE2 IN ('51442-12050',
'UNI-STOP-892-LH/8330A945',
'81170-12A60',
'86811-1H010',
'53875-42051',
'00-212-1945-LH',
'AB39-13404',
'B455-51-060A',
'85330-0K010',
'8972343500',
'87910-02G40',
'UNI-BRKT-009',
'86811-29000',
'62310-4EA0B',
'8330B211',
'52159-02957',
'49160-77E00',
'33500-TET-H01',
'22441-2A100/22441-2A600',
'21930-2D100',
'NS-485E-RH',
'81110-0K440',
'81150-1E240',
'8982222822',
'92405-A2000',
'92406-1Y000',
'8-98193869-0',
'92102-1J500',
'52119-F2911',
'GJ6A-51-5M0B',
'52116-0K060',
'86812-1H510',
'62310-4EA1A',
'52159-02999',
'53410-12550',
'59760-2S200',
'92405-G6000',
'86812-2F500',
'29110-J9000',
'53875-02450',
'86366-1E010',
'69100-1R300',
'33550-TET-H01',
'86812-29000',
'UNI-NK-1169',
'72482-65J00',
'8315A059',
'86812-1H010',
'GE4T-66-151A',
'62310-JD000',
'25611-02502',
'21830-2D000',
'71130-T2J-H00ZZ',
'UNI-NVR05-016',
'62310-4JA0B',
'48076-12010',
'50820-TEA-T11',
'UR56-56-131B',
'32865-JD100',
'81590-02A30',
'92405-1W000-T',
'74390-T0A-A01',
'52119-12948',
'92102-1C510',
'UR56-56-141B',
'89543-52010',
'BN8F-50-A11',
'89542-52010',
'20910-2AM01',
'74390-T0A-A0',
'25443-42630',
'GJ6A-51-5L0A',
'86612-F2AA0-2',
'86811-2F500',
'28920-EB300',
'25620-27002',
'86811-24300',
'85315-0K250',
'UNI-NVR05-015',
'86811-1H510',
'87620-1E110',
'AB39-13405',
'8981791380',
'86150-1R000',
'81110-1E180',
'UR87-51-0L0D',
'UNI-22-010',
'92202-B4000',
'52159-0Z953',
'62257-4EA0C',
'52119-02000',
'52159-12941',
'81230-3X010',
'FS01-18-200A',
'BG2M-51-030',
'53876-02470',
'72481-65J00',
'8981862180',
'92101-1J500',
'74165-T0A-A0',
'72322-63J10',
'53420-12520',
'62256-4EA0C',
'53100-0K500',
'92406-C5100',
'UNI-08-017',
'87940-02F80',
'UR87-51-0K0D',
'MR439533',
'81560-95J10',
'UNI-BRKT-010',
'8330B210',
'92405-C5100',
'0K6M7-51-030',
'81170-13330',
'92201-B4000',
'81580-02A30',
'72321-63J10',
'52119-12962',
'28533-4BA0B',
'92405-1Y000',
'81150-1E440',
'WLF2-14-300A',
'8-98248-822-1',
'74115-T0A-A0',
'8981862170',
'92406-G6000',
'76201-TR2-A0/UNI-02-1175',
'89467-52060',
'87610-1E110',
'74110-T0T-H0',
'MR439534',
'UNI-STOP-893-RH/8330A944',
'92406-A2000',
'74150-T0T-H0',
'51441-12120',
'BG2M-51-040',
'86812-24300',
'53876-42051',
'8315A060',
'8-98247-822-1',
'8982222812',
'95920-2S100',
'NS-485E-LH',
'52115-0K011',
'25622-02501',
'81130-12A60',
'BP4K-53-110G',
'UH71-32-600/UR56-32-60',
'BN8V-50-1T0B',
'37150-3X000',
'92101-1C510',
'92406-1W000-T',
'28210-1R100',
'81550-95J10',
'53876-12250',
'81150-0K440',
'B455-51-070A',
'52116-0K011',
'214-1923-2-RH',
'52119-0K840',
'0K6M7-51-040') AND CODE<>''