Amazing, but I'm sure you knew that. Do you recommend a good reference for understanding all of this syntax?

Thanks!

No go...

Msg 8120, Level 16, State 1, Line 4

Column 'LinkedServer.SharePointProgress.dbo.tblPartRev.RevisionNum' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY...

Will a group by eliminate the old values? In this case, I have several revisions (A, B, C... etc...), and would only want C to show up in the...

Thank you very much!!

I appreciate all of your replies. This is all good stuff, and yes I am relatively new to direct SQL statements vs .NET development in SQL. I am...

Thanks!

Thank you!

OK. Thanks again!

Thanks!

Is there a way to change the data type without having to drop and recreate tables?

Purchasing Table:

PartNumber, PK, nchar(10)

IsHardware, bit

KitAlways, bit

ChinaPN, nchar(10)

KitChina, bit

InstallTime, int

LaborClass, int

UnitCost, nchar(10)

Cault_043011 Table:

PartNo, varchar(max)

PartDesc, varchar(max)

Revision, varchar(max)

Author, varchar(max)

Stat, varchar(max)

Config, varchar(max)

LN, varchar(max)

WT, varchar(max)

Material, varchar(max)

IsPurchased, bit

IsHardware, bit

No relationship between the tables. How and...

I don't think the Where is being seen here. It is changing all the records.

UPDATE Purchasing

SET Purchasing.IsHardware = 1

FROM Purchasing as t1

INNER JOIN Vault_043011 as t2

ON t2.IsPurchased...

Perfect, and thanks. I've got a lot to learn!

PartNumber

None of this

This is 100% of what I am trying to do:

BEGIN TRY

INSERT INTO dbo.Purchasing(PartNumber, IsHardware, KitAlways, ChinaPN, KitChina, InstallTime, LaborClass, UnitCost)

SELECT

RIGHT('000000'...