This procedure creates a NewID column copies everything from ID to NewID, drops the ID column and renames NewID to ID. Now While creating the NewID column you can set...
you are selecting all the rows of table "tblUsers_Sites" when you say "SELECT * FROM tblUsers_Sites WHERE UserID = @userid" and trying to equate it to tblSites.ID