Function CDN.SED_TwrLiterki

-- ================================================
-- Template generated from Template Explorer using:
-- Create Inline Function (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the function.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:      Piotr Oslowski, SEDKOMP
-- Create date: 2012-11-02
-- Description:
-- =============================================
CREATE FUNCTION CDN.SED_TwrLiterki
(
    @towar int
)
RETURNS TABLE
AS
RETURN
(
SELECT 'A' as Mag, IsNull(Twr_SED_A,0) as Wartosc FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'B', IsNull(Twr_SED_B,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'C', IsNull(Twr_SED_C,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'D', IsNull(Twr_SED_D,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'E', IsNull(Twr_SED_E,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'F', IsNull(Twr_SED_F,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
--SELECT 'G', IsNull(Twr_SED_G,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
--UNION
SELECT 'H', IsNull(Twr_SED_H,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'I', IsNull(Twr_SED_I,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'J', IsNull(Twr_SED_J,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'K', IsNull(Twr_SED_K,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'L', IsNull(Twr_SED_L,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'M', IsNull(Twr_SED_M,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'N', IsNull(Twr_SED_N,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'O', IsNull(Twr_SED_O,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'P', IsNull(Twr_SED_P,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
--SELECT 'Q', IsNull(Twr_SED_Q,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
--UNION
SELECT 'R', IsNull(Twr_SED_R,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'S', IsNull(Twr_SED_S,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'T', IsNull(Twr_SED_T,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'U', IsNull(Twr_SED_U,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'V', IsNull(Twr_SED_V,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
UNION
SELECT 'W', IsNull(Twr_SED_W,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
--UNION
--SELECT 'X', IsNull(Twr_SED_X,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
--UNION
--SELECT 'Y', IsNull(Twr_SED_Y,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
--UNION
--SELECT 'Z', IsNull(Twr_SED_Z,0) FROM CDN.TwrKarty WHERE Twr_GIDNumer = @towar
)
GO