Get Day and Day Name with Holidays in SQL Server

Question

I am using this linkHow to get Day and Day Name with assigning Sunday as Holiday in SQL ServerI have one more table Holiday namethis table store the holiday Date and Holiday NameI want  like thisDate          DayName    EmployeeName30102016   Sunday            Holiday31102016    Moday             Diwali

kalpesh · Accepted Answer

Refer the below Test Query for your referenceDECLARE Month INTDECLARE Year INTDECLARE Date DATEDECLARE TotalDays INT  Set Month And Year ValueSET Month  10SET Year   2016  SET Default Date by month and yearSET Date  CASTRIGHT39039  CASTMonth as VARCHAR2 23939390139 CASTYear as VARCHAR4 As DATE To Get Total daysSET TotalDays  datediffday Date dateaddmonth 1 Date  Details tableDECLARE Details AS TABLEDATE DATEDayName VARCHAR20EmployeeNameHoldiday VARCHAR15  Table where Employee Details is storedDECLARE Table AS TABLEEmployeeId INTEmployeeName VARCHAR20INSERT INTO Table VALUES139David39INSERT INTO Table VALUES239Kevin39INSERT INTO Table VALUES339Peter39INSERT INTO Table VALUES439Jhon39INSERT INTO Table VALUES539Andrea39DECLARE HolidayTable AS TABLEHolidayDate dateHolidayname VARCHAR20INSERT INTO HolidayTable VALUES39101120163939D

Get Day and Day Name with Holidays in SQL Server

Company

Explore

Follow us

Contact Us