You can use Data Transformation services to move tables from most any other database to SQL server. You will need an odbc connection to the DB2 server. DTS is pretty...

You can do this in data transformation services (DTS).

Easiest way is to open the DTS folder in Enterprise Manager and follow these steps.

1. Right click Local Packages, New Package

2....

Thanks for the help. Neither of these worked. Here's why

If years is char, or varchar the sort is alphanum. So I get results like this.

1

11

12

2

3

I found that if I...

Try _The Guru's Guide to Transact-SQL_ by Ken Henderson

Also, more advanced

_The Guru's guid to Sql Server Stored Procedures, XML and HTML_ by Ken Henderson.

Both are excellent books. If you are...

Change your left join to a full outer join. This will ensure that you get a record returned for each class that exists, and also that you will get the...