stevesohcot

UPDATE tblData
SET
	tblData.field_one = tblSource.field_one
FROM
	myTableNameHere tblData
INNER JOIN myOtherTableNameHere tblSource ON
	tblData.id = tblSource.id
WHERE
	tblData.field_with_criteria = 'x'

stevesohcot

SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS FirstOfMonth