BJones questions

BJones answers

• Unique constraint on multiple columns in a table variable
• Replacing NAs in column with values from another table SQL Server
• SQL Server query for calculating daily census
• sp_rename error "could be found"?
• How can I populate missing rows in sql with static data?