//Find day of Weak of current date
CREATE Procedure getDayOfWeak
AS
SELECT 
    CASE WHEN Datepart(dw,getdate()) = 1 THEN 'Sunday' 
		ELSE 
			CASE WHEN Datepart(dw,getdate()) = 2 THEN 'Monday' 
				ELSE 
					CASE WHEN Datepart(dw,getdate()) = 3 THEN 'Tuesday'
						ELSE 
							CASE WHEN Datepart(dw,getdate()) = 4 THEN 'Wednesday'
								ELSE 
									CASE WHEN Datepart(dw,getdate()) = 5 THEN 'Thrusday'  
										ELSE 
											CASE WHEN Datepart(dw,getdate()) = 6 THEN 'Friday'
												ELSE 
													CASE WHEN Datepart(dw,getdate()) = 7 THEN 'Satrday'
													END
											END
									END
							END
				    END
			END
	END