Database

declare @UsersProfile table
(
  Person varchar(20),
  DOB datetime
)

insert into @UsersProfile
  select 'Person1', '2009-03-11'
  union select 'Person2', '2009-03-13'
  union select 'Person3', '2009-03-13'  
  union select 'Person4', '2009-03-16'
  union select 'Person5', '2009-03-25'

select * from @UsersProfile 
  where DOB = ( select min(DOB) from @UsersProfile where DOB>GetDate() )

Meax wrote:

i have users Date Of Birth

<br />
SELECT TOP 1 * FROM UsersProfile WHERE datepart(dy,DOB)>=datepart(dy,now()) ORDER BY datepart(dy,DOB)

Select Person from UsersProfile where DOB = <br />
     ( Select min(DOB) from UsersProfile where DOB > GetDate() )

Select Person from UsersProfile where DOB =<br />
     ( whatever it takes to obtain the next birthday )

Select Person from UsersProfile where DOB =<br />
( SELECT min(datepart(dy,DOB)) FROM UsersProfile WHERE datepart(dy,DOB)>=datepart(dy, now()))

$Query="SELECT * FROM $table WHERE DAYOFYEAR(birthday)= ".
    "(SELECT min(DAYOFYEAR(birthday)) FROM $table ".
    "WHERE DAYOFYEAR(birthday)>=DAYOFYEAR(now()))";

<br />
"SELECT * FROM $table WHERE DAYOFYEAR(birthday)= ".<br />
		"(SELECT min(DAYOFYEAR(birthday)) FROM $table ".<br />
		"WHERE DAYOFYEAR(birthday)>=DAYOFYEAR(now()))";<br />

string refnum = "091222REF";//here you get last reference number from database<br />
            string newrefNum = "";<br />
            if (DateTime.Now.ToString("yy") != refnum.Substring(0, 2))<br />
            {<br />
                newrefNum = DateTime.Now.ToString("yy") + "0001REF";<br />
            }<br />
            else<br />
            {<br />
                int incNum = int.Parse(refnum.Substring(2, 4)) + 1;<br />
<br />
                newrefNum = DateTime.Now.ToString("yy") +  incNum.ToString("0000") + "REF";<br />
            }

try<br />
{<br />
//insret refnumber<br />
}<br />
catch<br />
{<br />
//get last inserted number in table and then genereate new refnumber<br />
}<br />
finally<br />
{<br />
//close connection or do some else<br />
}

string refnum = "091222REF";//here you have last inserted reference number in database<br />
string newrefNum = "";<br />
if (DateTime.Now.ToString("yy") != refnum.Substring(0, 2))<br />
{<br />
newrefNum = DateTime.Now.ToString("yy") + "0001REF";<br />
}<br />
else<br />
{<br />
int incNum = int.Parse(refnum.Substring(2, 4)) + 1;<br />
<br />
newrefNum = DateTime.Now.ToString("yy") + incNum.ToString("0000") + "REF";<br />
} 

StudentId StudentName  SupervisorId <br />
1         john          1<br />
2         paul          1<br />
3         britney       3<br />
4         Mike          5<br />
.<br />
.<br />
.<br />
.<br />
13       beckham        7