relawson

[QUOTE=big_k105] but as mentioned above in the CIS major they do alot more business side of IT such as system administration and Database Administration and even more into business. but CS will give you more Computer theory and math. so if you like theory and math i recommend the CS …

[QUOTE=Paladine]Well kind of. Ok here is the syntax on creating a table in SQL and having an autonumber column [code] CREATE TABLE NorthWindUsers (UserID INT IDENTITY(1,1) NOT NULL, UserName VARCHAR(50) NOT NULL, Password VARCHAR(50) NOT NULL) [/code] The userID will start a 1, and increment each time you add a …

[QUOTE=Chainsaw]My company outsources to save money. Why pay Americans $20-40 an hour when you can pay folks in other countries $6-12/hour? American's don't need good-paying jobs. [/QUOTE] My company does the same. The problem is that they aren't actually saving money. There are hidden expenses that are not so hidden …

First, you need to add some unique primary keys. That will make joining much easier and the code more readable. Look up "normalization" in google and try to get to 3NF. Second, use "not exists" instead of "not in". They both work, but "not in" does a table scan. If …

[QUOTE=NuGG]Cheers mate, it works a treat. Ive been struggling with that for ages, thats a great help...[/QUOTE] Another great "feature" brought to you by Microsoft :-)