![]() I need to join these 2 tables to get the below data: Insert Into dbo.Calendar values(20210303,'Friday',6) ![]() Insert Into dbo.Calendar values(20210302,'Thursday',5) Insert Into dbo.Calendar values(20210301,'Wednesday',4) Insert Into dbo.Calendar values(20210204,'Tuesday',2) Insert Into dbo.Calendar values(20210203,'Monday',2) Insert Into dbo.Calendar values(20210202,'Sunday',1) Insert Into dbo.Calendar values(20210201,'Saturday',7) Insert Into dbo.Calendar values(20210103,'Tuesday',3) Insert Into dbo.Calendar values(20210102,'Monday',2) ![]() Insert Into dbo.Calendar values(20210101,'Sunday',1) I have 2 SQL tables with the below DDL & sample data :
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |