Question...why was the table designed with the "IN" and "OUT" as separate Records?  I'm not harrassing, I just want to know if there is some type of advantage to that?

Keep in mind that I do not have SSRS yet...but, wouldn't it be possible (like Lee Frost says) to maybe override a Method in the WebService (maybe they have some...

Ok, my 2Cents

I will absolutely never use an Identity Column, whether as a Unique PK or not.  This is only my opinion.  I know...

In Developing a lot of .NET Applications, I have come to realize this is a simple process.  Well, simple, yet difficult.

In .NET, it is possible to create "simple" Deployment projects. ...

Hmm, well, I lied, it's not really a "Users" table.  It's more of an "Individuals" Table which stores Users and Contacts of Companies in the same table.  The reason is...

Thanks!  That did the trick!

Another way is to create a .NET Remoting App which runs as a Service on each PC running SQL Server or MSDE.  Then, from another PC (your Main PC?) an...

UniqueIdentifiers are treating like Strings / Text...so Import them as such

Umm, try to Connect, if it fails trap the Exception and display a friendly Error to the User?

Select * From ThisTable Where ID IN(Select ID From ThatTable)

OR

Select * From ThisTable Where ID NOT IN(Select ID From ThatTable)

Ok, here's a revised version...

Select C.Column_Name As ColumnName, Data_Type As Type
 From Information_Schema.Key_Column_Usage CU
 Inner Join Information_Schema.Columns C ON (CU.Table_Name = C.Table_Name) And (CU.Column_Name = C.Column_Name)
 Where...

I've been able to do this 2 different ways.  My problem with using the "Information_Schema" Views was that I needed not only the Column Names, but the DataType of those...

You have a point there!

A lot of "manual labor" in an automated world

I've developed the Time-Tracking system for my job which handles everything and even keeps track of...

So why not just Execute an Update Statement instead of using a DataReader?  It seems like your using the wrong object for the job...maybe you need to explain a little...