Even though I ran the checkpoint? Would you mind elaborating? Thanks a lot!

Thanks for the responses guys, here is more info.

Both tables already exist.

Table 1 has supplier information and about 24 columns & about 100K rows of data. One of...

Thanks a lot Lowell, I changed it VARCHAR (50) since this is just for testing purposes, and both scripts work now. Something new learnt.

However, I didn't quite understand what...

To answer my own question: I think that SAM's Teach Yourself T-SQL in 10 Minutes is a great starting point for beginners. Comments?

@ray K : Thanks for your input. Yep I bought Developers Edition on recommendation from a user on these forums. The 64 bit only version (or 32-bit only...

@Welsh, thanks for the reply. After being involved with SQL, Access for some time I've realized I'm more interested in the development side.

For those who might find themselves in...

@bill and others...ok well let me ask this question: Not only am I new to SQL, I am new to databases in general (my background is in networks)....

With all due respect, I think the discussion that has developed here about what SQL has to do with relational theory deserves a thread of it's own. Hopefully we can...

How lucky! Do relay my high regard for his book to him. And if possible get me some inside info on when he's coming out with "inside relational databases -...

@Andy: I have to admit, that book is a good read, I LOVE the humor with which it is written, not to mention the simplicity. Thanks for the...

Yes I did extract it to the hard disk. And this is the error it gave me:

SQL Server Setup has encountered the following error:

SQL Server 2008 setup100.exe and setuppatch.exe...

I got my copy of developers edition from dreamspark, burnt the iso image onto a DVD and attempted to install. Before I did that, I uninstalled SQL Server Express, with...

Is there a significant difference between the developer edition and SQL express? The book im referring to (SQL 2008 from novice to professional by Robin Dewson) uses the developers edition...

@jason..thank you for the link, it's a great guide for a newbie like me looking to seriously find my way through SQL server. Really appreciate it.

I think I also found an answer to this in the Microsoft documentation:

http://msdn.microsoft.com/en-us/library/bb326612.aspx

"In SQL Server Express, Windows users are granted connect permission because the BUILTIN\Users group is...