I am just learning sql, and I need some help. This may seem basic to many but I don’t know where to begin. Below I have a single table that I need to make into at least three tables.
CREATE TABLE [dbo].[SetFocus](
[EmployeeNumber] [int] NOT NULL,
[EmployeeName] [varchar](50) NOT NULL,
[Project1] [varchar](50) NULL,
[Project2] [varchar](50) NULL,
[Project3] [varchar](50) NULL,
[Team] [varchar](50) NULL,
[Hours1] [int] NULL,
[Hours2] [int] NULL,
[Hours3] [int] NULL,
[ProjectManager1] [int] NULL,
[ProjectManager2] [int] NULL,
[ProjectManager3] [int] NULL,
————————————————
1. How do I decide to brake up the data.
2. I was able to break up the data, but I am not able to get the results that I am looking for.
Please help
