1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
|
USE [MSELLER]
GO
/****** Object: StoredProcedure [dbo].[STOCK_DISPONIBLE_EVD] Script Date: 10/04/2013 09:09:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[STOCK_DISPONIBLE_EVD]
--@Ids int,
--@Tsim varchar(5)
AS
SET NOCOUNT ON
SELECT Top(1) [ID_AUTO], [DATEOP], [ID_SIM], [STK_ANCIEN], [STK_ENTREE], [STK_SORTIE], [STK_FINAL], [REF_MVT], [OBSERVATION], [LOGINPAS], [IS_ANNULER],[TypeSIM]
FROM [dbo].[MVT_TRANSFERT]
WHERE [dbo].[MVT_TRANSFERT].[ID_SIM] IN (SELECT ID_AUTO FROM [dbo].[SIM]) and [dbo].[MVT_TRANSFERT].[TypeSIM]= 'VM'
GROUP BY [ID_AUTO], [DATEOP], [ID_SIM], [STK_ANCIEN], [STK_ENTREE], [STK_SORTIE], [STK_FINAL], [REF_MVT], [OBSERVATION], [LOGINPAS], [IS_ANNULER],[TypeSIM]
ORDER BY [dbo].[MVT_TRANSFERT].[ID_AUTO] desc
CREATE TABLE #TEMPTAB(int ID_SIM, decimal STK_FINAL)
INSERT #TEMPTAB (ID_SIM)
(SELECT ID_AUTO FROM [dbo].[SIM])
UPDATE #TEMPTAB
SET STK_FINAL = (SELECT Top(1) [STK_FINAL]
FROM [dbo].[MVT_TRANSFERT]
WHERE [dbo].[MVT_TRANSFERT].[ID_SIM] = 33)
SELECT * FROM #TEMPTAB |
Partager