Wpis z mikrobloga

@ReniferApokalipsy: USE [SPEED4c2]
GO
/**** Object: UserDefinedFunction [dbo].[funckja1] Script Date: 11/27/2015 09:17:24 ****/
SET ANSINULLS ON
GO
SET QUOTED
IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[funckja1]
(
@KIEROWCA VARCHAR (50),
@KRAJ VARCHAR (3),
@MIESIAC int
)
RETURNS VARCHAR (35)
AS
BEGIN
DECLARE @STAWKA_DIETY FLOAT
DECLARE @WARTOSC_DIETY FLOAT
DECLARE @ILOSC_GODZIN FLOAT
DECLARE @ILOSC_DIET FLOAT
DECLARE @WYNIK int
declare @waluta varchar(10)

SET @ILOSC_GODZIN =(select SUM(DATEDIFF(hour,ZADATA, WYDATA))
FROM Zlecenia
where NRZLEC
  • Odpowiedz