Infinitedating com

The two continued visiting each other fairly often after that, but Walker says they were ready for marriage even before meeting in person.

So, can Walker see Fancred being a place where other soulmates find one another? Sports is a big thing, it is easy to connect over (if you like the same teams)." Despite Walker's joking parenthetical, she said there's room for some friendly rivalry in their relationship.

TOPIC_ID=70975DECLARE @period INT SET @period = 30 -- put period in days SELECT employeeid FROM tm_emptable WHERE CONVERT(INT, RIGHT(CONVERT(VARCHAR,empdob,112),4)) BETWEEN CONVERT(INT, RIGHT(CONVERT(VARCHAR, GETDATE(),112),4)) AND CONVERT(INT, RIGHT(CONVERT(VARCHAR, GETDATE() @period,112),4)) Hi limno I have DOB records in my table like years with various months., 2011,2010,2005,1998 but your query does not displays that.

I want to displays all birthdays from now to 2012-DEC 31.

SELECT CAST(DAY(Up Coming Birth Day) AS VARCHAR(2)) ' ' SUBSTRING(DATENAME(MM, Up Coming Birth Day),1,3) Up Coming Birth Day, DOB FROM ( SELECT CASE WHEN CAST(convert(varchar(10), DATEADD(YEAR, DATEDIFF(YEAR, DOB, GETDATE()), DOB), 111) AS DATETIME) SELECT CAST(DAY(Up Coming Birth Day) AS VARCHAR(2)) ' ' SUBSTRING(DATENAME(MM, Up Coming Birth Day),1,3) AS Up Coming Birth Day Ordered, DOB FROM ( SELECT CASE WHEN CAST(convert(varchar(10), DATEADD(YEAR, DATEDIFF(YEAR, DOB, GETDATE()), DOB), 111) AS DATETIME) Ya that i know and i tried that, If we give order by for 2012-11-24 this formate it displays in right order But if we give for 13 Nov this format it does displays in right order.

It only sort the day,if i have records like, 13 apr 16 dec 1 Nov means, it displays 1 nov 13 apr 16 dec but it should sort both month and day right? In that i have made a change that i.e I changed the Alias of Upcoming Birth Day to Upcoming Birth Day Ordered and added order by on Upcoming Birth Day.