Recent content by bud31047

Thargy, This is good stuff and everything is easily understandable. I really like your use of computed columns to get the Period and Week. Your solution is much simpler than the one I came up with using the Schedule table as part of the equation. I am sure I can make your approach work for us...

I think I have the database good to go now. One last thing before we wrap this up. I would appreciate it if you could get me pointed in the right direction to create a view that shows who has not had all of their safety training. Thanks again,

Could not drop object 'TOPICS' because it is referenced by a FOREIGN KEY constraint." I am using SQL Server 2005 Express. That might explain it. Here is a quick rundown of what I am trying to get. We have 1300 employees where I work that we have to train each year; OSHA safety training...

Thargy, The code to extract the Period from the training date works great. Thanks for that. After an hour of tinkering with various functions I realized it would just be quicker to create the Weeks table. I was unable to use your script to create and alter the tables. Possibly you made some...

Thanks for the help.

I created a table not listed above to get Period from SafeDate. ------------------------------------------------------- CREATE DATABASE Safety GO USE SAFETY CREATE TABLE Employees ( GPID int NOT NULL PRIMARY KEY, FirstName nchar(20) NOT NULL, Department nchar(20) NOT NULL) INSERT INTO...

Thargy, Thanks for the feedback. Obviously my questioning skills could use some work as well as my design skills. Let me try this again. I am not sure which way is best to display relationship information but I will take a swing at it. All of the tables listed are complete for column's with...

I am working on a SQL Server database to track OSHA Safety and company mandated training compliance. The training is conducted 13 times a year (each period). There are 100+ topics that we track. Each period we may train on multiple topics. We may also train select individuals on topics that are...

Thanks. I will ask my follow-on questions in the Programming forum.

I am working on a SQL Server database to track OSHA Safety and company mandated training compliance. I felt fairly good about it until I attempted to create my views. I would appreciate it if someone could take a look and let me know if I'm heading down the wrong path. The training is conducted...

NEWSalt, I had completed the program but someone came back after the fact and wanted me to filter the output. I will explore the idea of using another ArrayList. At this point I think this would be a better solution than re-writing the program. Memory is not an issue as the source file is less...

I am parsing a text file and storing the results in an ArrayList. Prior to appending the data I need to compare the string in the current and next index looking for duplicate/unwanted data. Here is what the data in the ArrayList looks like; Alice Smith;34578;01/01/2010;10:10:00 PM;;Add Punch...

Thanks for the information guys. This is what I suspected.

Anyone know what SQL Server permissions/privileges would be necessary to migrate/upsize an Access database?

I work at manufacturing plant for a Fortune 500 company. All of the tools I create are used only at my facility. The Corporate Data Security folks are only willing to offer me the following permissions in SQL Server, unless I can demonstrate a "Business Need"; create & drop tables, procedures...