38 lines
No EOL
1.4 KiB
Transact-SQL
38 lines
No EOL
1.4 KiB
Transact-SQL
DROP PROCEDURE IF EXISTS sp_GetOsztalyokHaviHianyzasiOsszesitoje
|
|
GO
|
|
|
|
CREATE PROCEDURE sp_GetOsztalyokHaviHianyzasiOsszesitoje
|
|
@tanevID int
|
|
,@intezmenyId int
|
|
,@honapAdatszotarTypeId int = 55
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
declare @honapok table(honap int, honapnev nvarchar(max));
|
|
insert into @honapok
|
|
select distinct d.c_value, d.c_name as Honap from t_dictionaryitembase d where d.C_DICTIONARYTYPEID = @honapAdatszotarTypeId order by d.c_value
|
|
|
|
select honapnev from @honapok
|
|
|
|
DECLARE kur CURSOR FOR
|
|
select distinct d.c_value as Honap from t_dictionaryitembase d where d.C_DICTIONARYTYPEID = @honapAdatszotarTypeId
|
|
|
|
DECLARE @Honap int
|
|
|
|
OPEN kur
|
|
FETCH NEXT FROM kur INTO @Honap
|
|
|
|
WHILE @@FETCH_STATUS = 0 BEGIN
|
|
create table #tabla(COLUMN379 nvarchar(max), [1] int,[2] int,[3] int,[4] int,[5] int,[6] int,[7] int,[8] int,[9] int,[10] int,[11] int,[12] int,[13] int,[14] int,[15] int,[16] int,[17] int,[18] int,[19] int,[20] int,[21] int,[22] int,[23] int,[24] int,[25] int,[26] int,[27] int,[28] int,[29] int,[30] int,[31] int, COLUMN2672 int, COLUMN1910 int, COLUMN5197 int, COLUMN1786 int, COLUMN1787 int, COLUMN1788 int, COLUMN1789 int, COLUMN1911 int)
|
|
insert into #tabla
|
|
EXEC uspGetOsztalyokHaviHianyzasiOsszesitoje_honapra @tanevID, @intezmenyId, @honap
|
|
SELECT * from #tabla
|
|
drop table #tabla
|
|
FETCH NEXT FROM kur INTO @honap
|
|
END
|
|
|
|
CLOSE kur
|
|
DEALLOCATE kur
|
|
|
|
END
|
|
GO |