Month: April 2011
T-SQL equivalent for NEXT_DAY() of ORACLE
I thought of creating a simple function for this operation, in T-SQL. Function Name: Next_Day Input Params: @FromDate - Date from which you wish to get the next day; @DayNumber - Day of week for which you wish to get the next day (6=>Saturday, 7=>Sunday) Operation: SELECT dbo.Next_Day(GETDATE(),6) //Returns the next Saturday (6) from today Function: Function body ...
Check out my video on MindTree Certified Project Manager, done on behalf of MindTree Movie Club.
First Time Manager Video
Check out my video on a First Time manager's state of mind.
MindTree Campus Training July 2007 Video
Check out my video on MindTree Campus Training during my batch of July 2007.
Census 2011 Video
Check out this video i did for MindTree Foundation on Census 2011 for differently-abled citizen.