Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Enter Data in table and allow some data transfer

Author  Topic  jedistev Starting Member 1 Post Posted - 2010-01-18 : 12:00:41 Hi i have look book and Pdf, but cannot find right one, or maybe it don't have one right now here is example Create table Vacation.Employee_Details( EmployeeID INTEGER PRIMARY KEY, Name VARCHAR (215) , Task_Manager VARCHAR (215), People_Manager VARCHAR (225), Another VARCHAR (215) Create table Vacation.request ( Request_ID integer PRIMARY KEY, EmployeeRequestID integer references Vacation.Employee_Details(EmployeeID), Name VARCHAR (15), Date_start DATE, Date_Finish DATE, Total_Day VARCHAR (2), Task_manger VARCHAR (50), Comments VARCHAR (50), Notes VARCHAR(50) ); if i insert into Details on Table Employee Details like Name Joe Blogg EmplyeerequestID 5453 Task_manager Mr Men and there is data on this which auto data gentrated without me put it on data on vacation EmployeeID 5453 Name Joe Bloggs Task_Manager Mr Bean and it on database record,when open Vacation request i will find it there without me add on it but some are blank as well ,so the rest of it all i gotta type down blank