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.
| Author |
Topic |
|
Budvegas
Starting Member
13 Posts |
 Posted - 2009-12-03 : 10:33:48
|
| Afternoon allI am very new to SQL.I am looking to create a DB Staff attendance. At the moment I am using an excel spreadsheet. With different sheets for different months.I was wandering if anyone could help me create an sql DB from scratch?The info I need to start with is Staff name, date. At the moment I use a 1 to record if they are here, S if there are sick, HS is they have half day sick, H for holiday etc?Any Help would be greatly appreciated.I can send the speadsheet if that helps.Many Thanks in advanceBud\m/ :D \m/ |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-12-03 : 14:58:38
|
| The purpose of this site is not so much to walk someone through an entire project but rather help with specific issues. The scope of your question is a little too big - or if you need help with a specific part of this then the question is too vague.a database is a collection of sql objects like tables, views, stored procedures, users, etc. It sounds like what you are describing is a single table. Why do you want to move away from excel? Are you trying to solve a specific problem or perhaps you intend to use database technology to support an application? Do you need help with syntax on how to create a database and at least this one table or do you need help designing what columns should be in your table(s)?Be sure to use Books Online as a resource for getting started as well as a continuing reference. Here is a good place to start:http://technet.microsoft.com/en-us/library/ms187875%28SQL.90%29.aspxBe One with the OptimizerTG |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-12-03 : 15:47:12
|
| What he said...But let's get stupid...(it's my favorite place)WHERE do you want to build this database? What platform?SQL Server, Access, EXCEL, Notepad, Stone Tablets?(Order of platform determining value is not determinant...for example, Access is ahead of stone tablet)Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
|
|
|
|
Staff Attendance DB