how to get Date and DayName based on row number in SQL Server

Question

I want to display record in Gridview like Table EmpId And EmpName1               Amit2               Sumit Display Gridview date         dayname      EmpName1092016  Monday          Amit2092016  Tusday           Sumit

kalpesh · Accepted Answer

Refer the below sql test query for your referenceYou can use it as store procedure and call it to bind your grid viewTestQueryDECLARE Month INTDECLARE Year INTDECLARE Date DATESET Month  03SET Year   2016 SET Date  CASTRIGHT39039  CASTMonth as VARCHAR2 23939390139 CASTYear as VARCHAR4 As DATEDECLARE Table AS TABLEEmployeeId INTEmployeeName VARCHAR20INSERT INTO Table VALUES139David39INSERT INTO Table VALUES239Kevin39INSERT INTO Table VALUES339Peter39INSERT INTO Table VALUES439Jhon39INSERT INTO Table VALUES539Andrea39SELECT REPLACECONVERTVARCHAR24CASTDATEADDDDROWNUMBER OVER ORDER BY EmployeeId  1Date AS DATE103 39393939Date      DATENAMEdwDATEADDDDROWNUMBER OVER  ORDER BY EmployeeId  1Date DayName       EmployeeNameFROM TableOutput DateDayNameEmployeeName01032016TuesdayDavid02032016WednesdayKevin03032016ThursdayPeter040

how to get Date and DayName based on row number in SQL Server

Company

Explore

Follow us

Contact Us