Please help i have that list of teachers how can i distribute the subjects based on days of the week without any conflict using any insert into stored procedureDays Monday Tuesday Wednesday Thursday Friday Saturday Sunday CLASS S1K S1K S2B S3C Software Engineering Computer Networks Physics Chemistry Mathematics Applied Mechanics List of teachersNoMUKASA JOHN20001MUKISA PAUL20002please help

Create Time Table query in SQL Server

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Mar 13, 2022 11:10 PM
Forum: SQL Server
Answer: 1
Views: 1942

Please help i have that list of teachers. how can i distribute the subjects based on days of the week without any conflict using any insert into stored procedure.

Days
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday

CLASS
S1K
S1K
S2B
S3C

Software Engineering
Computer Networks
Physics
Chemistry
Mathematics
Applied Mechanics

List of teachers	No
MUKASA JOHN	2-0001
MUKISA PAUL	2-0002

please help

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Mar 14, 2022 10:44 AM
Report

Refer below link.

https://stackoverflow.com/questions/60350853/creating-a-time-table-using-sql

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Create Time Table query in SQL Server

Company

Explore

Follow us

Contact Us