Trying to deploy Write UDF in DDT

Geoff Hirst — Mon, 11 Aug 2008 08:54:45 GMT

Guys,

A simple UDF, that I need to return a date based on some info in my DB, I wanted this as a UDF, which I have written and tested in SQL Server, works fine.

What I can't do is get the DDT to deploy it. I know my issue lies in the first 2-3 lines, but I really don't know what it might want.

Can anyone send me a translation of how it should be put into the DDT?

thanks in advance

UDF is as follows

[codesnippet]

CREATE FUNCTION [dbo].[FirstDayHolidayYear]()

RETURNS smalldatetime

BEGIN

-- Declare the return variable here

DECLARE @Year CHAR(4)

DECLARE @Month VARCHAR(2)

DECLARE @Day VARCHAR(2)

SELECT @year = YEAR(GETDATE())

SELECT @day = '01'

IF (SELECT annualleaveyearstart FROM dbo.ApplicationSettings)<10

SELECT @Month = '0'+CAST(annualleaveyearstart AS CHAR(1)) FROM dbo.ApplicationSettings

ELSE

SELECT @month = CAST(annualleaveyearstart AS CHAR(2)) FROM dbo.ApplicationSettings

BEGIN

-- Insert statements for procedure here

return (CAST(@year+'-'+@month+'-'+@day AS SMALLDATETIME))

END

[/codesnippet]

RE: Trying to deploy Write UDF in DDT

Dustin Taylor — Mon, 11 Aug 2008 08:54:45 GMT

Glad you got it figured out :)

RE: Trying to deploy Write UDF in DDT

Geoff Hirst — Mon, 11 Aug 2008 08:24:04 GMT

Guys,

No need to respond. I had a brainwave and ran a profiler session to see what YOU send it. Once I had this, all I needed to add was (), as I have no parameters for this function.

sorry for the hassle.

best

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Trying to deploy Write UDF in DDT

Trying to deploy Write UDF in DDT

RE: Trying to deploy Write UDF in DDT

RE: Trying to deploy Write UDF in DDT