KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
This query SELECT FirstName, LastName, NCAAStats.AccountId, College_Translator.school_name, StatTypeId, COUNT(*) AS 'Count' FROM NCAAstats INNER JOIN College_Translator ON College_Translator.AccountID = NCAAstats.AccountId GROUP BY FirstName, LastName, NCAAStats.AccountId, College_Translator.school_name, CalendarYear, StatTypeId HAVING COUNT(*) >1 ORDER BY 'Count' DESC Selects records that I would like to set an ISValid bit to 0 . These records are records that appear twice in my database due to an input error. I'm looking for something like: UPDATE NCAAstats SET IsValid = 0 WHERE (my select statement) This is on MS SQL SERVER 2008 Thanks!
Tags (comma-separated)
Save Edits
Cancel