All-Star
123252 Points
10024 Posts
Moderator
Aug 21, 2018 02:19 PM|limno|LINK
Select Count(*) as Total_IN_ID , datepart(week,Resolve_Datetime) Resolve_Week Group by datepart(week,Resolve_Datetime ), year(Resolve_Datetime )
All-Star
123252 Points
10024 Posts
Moderator
Re: SQL Query to Get ID counts in a weekly basis?
Aug 21, 2018 02:19 PM|limno|LINK
Format your SQL query with instant sql formatter:
http://www.dpriver.com/pp/sqlformat.htm