Procédure stockée /// USE [SAMAC] GO /****** Object: StoredProcedure [dbo].[EXT_CREATION_PARAM_IMPRESSION_TIERS] Script Date: 06/12/2016 20:41:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — ============================================= — Author: — Create date: <6/1/2016> — Description: — ============================================= ALTER PROCEDURE [dbo].[EXT_CREATION_PARAM_IMPRESSION_TIERS] AS BEGIN select * from [dbo].[MODELE] insert into [dbo].[TIERS_MODELES] ([TIRID],[MODID],[PINID],[TIMCHRONO],[TIMNBEXP]) select [TIRID],’379′,’3′,’1′,’2′ FROM [dbo].[TIERS] WHERE [TIRTYPE] = ‘C’ insert into [dbo].[TIERS_MODELES] ([TIRID],[MODID],[PINID],[TIMCHRONO],[TIMNBEXP]) select [TIRID],’383′,’4′,’1′,’2′ FROM [dbo].[TIERS] WHERE [TIRTYPE] = ‘C’ END ///