CREATE FUNCTION save_GetCloseDate
(
	@Inhome datetime,
	@Market varchar(6)
)
RETURNS DATETIME
AS
BEGIN
    RETURN (SELECT closedate 
                   from dbo.vw_MarketMailDates
                   where month(inhomedate) = month(@inhome) and Market = @Market)
END


I basically need the same thing but want what is like a FOR LOOP where it does 
a (i=-1) month(dateadd(m, i, inhomedate)) 
and if the value is null (IE - no value in dbo.vw_MarketMailDates) to run 
month(dateadd(m, i, inhomedate)) again with i=-2 etc and once it returns a value stop.

Could anyone help with this within SQL? Thanks

CREATE FUNCTION save_GetCloseDate
(
	@Inhome datetime,
	@Market varchar(6)
)
RETURNS DATETIME
AS
BEGIN
    RETURN (SELECT TOP 1 closedate 
                   from dbo.vw_MarketMailDates
                   where inhomedate < = @inhome
                   and Market = @Market
            ORDER BY inhomedate DESC)
END