FILE:

mssql/procedures.sql

ERROR:

Invalid column name 'Birthday'.

Invalid column name 'Birthday'.

Invalid column name 'Birthday'.

STATEMENT:

create procedure [dbo].[yaf_User_ListTodaysBirthdays](@BoardId int, @StyledNicks bit = null) as

begin

SELECT

usr.UserID,

[Birthday],

usr.DisplayName,

m.Username,

Style = case(@StyledNicks)

when 1 then ISNULL(( SELECT TOP 1 f.Style FROM [dbo].[yaf_UserGroup] e

join [dbo].[yaf_Group] f on f.GroupID=e.GroupID WHERE e.UserID=usr.UserID AND LEN(f.Style) > 2 ORDER BY f.SortOrder), rnk.Style)

else '' end

FROM [dbo].[yaf_prov_Profile] as u

JOIN [dbo].[yaf_prov_Membership] m on m.UserID=u.UserID

JOIN [dbo].[yaf_User] usr on usr.Name=m.UserName and usr.BoardID = @BoardId

join [dbo].[yaf_Rank] rnk on rnk.RankID=usr.RankID

where

datepart(MONTH,Birthday) = datepart(MONTH,GETUTCDATE()) and datepart(DAY,Birthday) = datepart(DAY,GETUTCDATE())

end

Hey, balbes, let's go without curses - the feature can be disabled. It's a sort of test feature in svn beta version there will be a universal solution.

Originally Posted by: bbobb