I am trying to update [SeedTracker].[dbo].[DBLogNonResInt].Cassava (bit datatype) from a bit value from another table [SeedTracker].[dbo].[Location].Cassava joined by DBLogNonResint.Location = Location.Description. If the value in Location.Cassava is True then update the DBLogNonResInt.Cassava to True otherwise update to FALSE.
Excellent! Thank you! I was making it much tougher than what it really was like usual.
YZlat
sorry, forgot the "false" part. try this:
UPDATE [SeedTracker].[dbo].[DBLogNonResInt]SET [SeedTracker].[dbo].[DBLogNonResInt].Cassava= ( CASE WHEN (t2.Cassava=True) THEN t2.Cassave ELSE False END )FROM [SeedTracker].[dbo].[Location] as t2WHERE [SeedTracker].[dbo].DBLogNonResint.Location = t2.Description
UPDATE [SeedTracker].[dbo].[DBLogNonResInt]SET [SeedTracker].[dbo].[DBLogNonResInt].Cassava= ( CASE (t2.Cassava) WHEN TRUE THEN t2.Cassava ELSE False END )FROM [SeedTracker].[dbo].[Location] as t2WHERE [SeedTracker].[dbo].DBLogNonResint.Location = t2.Description