17 lines
495 B
Transact-SQL
17 lines
495 B
Transact-SQL
 
|
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'my_ImpDM_Konta' AND user_name(uid) = 'CDN')
|
||
|
|
DROP PROCEDURE [CDN].my_ImpDM_Konta
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE PROCEDURE [CDN].my_ImpDM_Konta
|
||
|
|
(
|
||
|
|
@Rok smallint,
|
||
|
|
@Miesiac smallint
|
||
|
|
)
|
||
|
|
AS
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
select distinct DT_Konto as Konto
|
||
|
|
from CDN.Dziennik inner join CDN.DziennikElem on DZK_GIDNumer = DEL_GIDNumer
|
||
|
|
inner join CDN.Dekrety on DT_GIDNumer = DEL_GIDNumer
|
||
|
|
where DZK_Rok = @Rok and DZK_Miesiac = @Miesiac
|
||
|
|
order by 1
|
||
|
|
GO
|