Viewing 15 posts - 91 through 105 (of 144 total)
Going back to good database design, this is NOT.
A table with just a primary key is meaningless. If there is nothing to group together as related, then there is no...
September 10, 2004 at 9:52 am
Actually, you do not need two tables to do this.
tbl_Employee_Salary_History
EmpSalaryHistoryID (Identity) PK
EmployeeID
EffectiveDate
SpecialityID
ClassID
RateType
RateAmount
The EmployeeID and Effective Date are the business key. Rate type is annual or hourly, and rate amount...
September 10, 2004 at 8:59 am
I was also a Clipper head, and did FoxPro, DbaseIII, MS Access 1 - 2003. And, even co-authored a book on MS Access. I've only been making a living doing...
September 3, 2004 at 9:43 am
If I remember correctly, it was 3.51 that I started with.
September 3, 2004 at 9:08 am
I run MDAC 2.8 and everything is SP 3 for SQL Server.
In my databases that I distribute, I use something like CS_dbo, CS_User, and CS_Admin where CS is the name...
September 3, 2004 at 7:53 am
The most effective way is to have a date dimension table with all the math and breakouts on a date already done. Or, if you do not need that level...
September 3, 2004 at 6:16 am
If you are doing this new "install" from a CD, you might need to change the properties on the MDF file and the log file to remove the read-only property.
September 3, 2004 at 6:12 am
Remember that the ADP itself is designed to be single user. So you need to do what Remi said and develop a process for getting the most recent version on...
August 31, 2004 at 8:30 am
Since most hosting companies are running Linux, I doubt you could run it even if they let you.
It does not matter that you own the SQL Server software. The licensing...
August 30, 2004 at 7:02 am
For a Query Analyzer type of front end, email: sqlguy@hotmail.com
He is developing one that can be used with it. Unfortunately, it is the only way I have found of...
August 25, 2004 at 7:47 am
Actually, jfmccaeb is correct. But, I would also add that you should have a structure something like this for you statement type table.
+------------------------------------------------------------------------+
|Statement Tax Acct |
|ID Type...
August 25, 2004 at 7:02 am
Or, you can simply download it here:
August 25, 2004 at 6:52 am
Define the range for your data and name it in Excel.
Click on File | External Data
Select your excel file and the named range
Once it is linked, you can create an...
August 17, 2004 at 1:01 pm
What are you using to view it? Enterprise Manager will not show it all to you. You will need some kind fo front end tool to view or report on...
August 17, 2004 at 6:58 am
I would not use the method you are using. I would link the Excel file and use an append query to do the data transfer. This is assuming that teh...
August 17, 2004 at 6:48 am
Viewing 15 posts - 91 through 105 (of 144 total)