Your function could be easier like this:

CREATE FUNCTION [dbo].[ufn_GetYYYYMMSixMonthsAgo_YYYYMM](

@pYYYYMM INT)

RETURNS int

AS

BEGIN

declare @dt...

Peso (4/17/2008)

SELECTSalesOrderId,

Type,

ISNULL(CONVERT(VARCHAR, Date, 103), 'No Date Specified') AS ExpiryDate

FROMdbo.Values

INNER JOINSalesOrders ON SalesOrders.SalesOrder = dbo.Values.RecordNumber

INNER JOINdbo.DataNameFields ON dbo.DataNameFields.DataField = dbo.Values.DataField

WHEREdbo.Values.DataField = '43'

AND dbo.SalesOrders.Type...

OR you can use:

----------------

SELECT

CASE

WHEN [DateField] IS NULL then 'No Date Specified'

ELSE convert(varchar, Date, 103)AS ExpiryDate

END AS DD

FROM

[AppsGo].[dbo].[Sales]

Hi, this is my solution, performance problem can occurs but...

create function uf_Period_Previous:

CREATE FUNCTION [dbo].[uf_Period_Previous](

@Period INT)

RETURNS INT

AS

BEGIN

DECLARE @Year INT

DEClARE @Month TINYINT

DEClARE @PrevPeriod INT

SET @Year = @Period / 100

SET @Month = @Period...