User Profile
Cheef87
Copper Contributor
Joined Feb 16, 2024
User Widgets
Recent Discussions
Re: How to get active totals by date
Your question is a bit confusing. Are you asking how to have the output structured in a specific way? One thing I would suggest is to change your active column from a Varchar to a bit field, 1= True and 0 = False. So column "IsActive" with 1's and 0's. Then in your WHERE clause you can say WHERE IsActive = 1.491Views0likes0CommentsRe: Help with delete query
dariopalermo1976 You could try to just do something like this to see what will happen: ;WITH ToDelete AS ( SELECT ROW_NUMBER() OVER (PARTITION BY ComputerName ORDER BY LastContact DESC) AS rn FROM AMP ) SELECT * --DELETE FROM ToDelete WHERE rn > 1 This would let you see what was about to happen prior to running. Then you could just replace the select * with the commented Delete.545Views0likes2Comments
Recent Blog Articles
No content to show