WITH sales_by_team_and_category AS
(
SELECT
SUM(sales) AS Total_Sales
,Teams
,Category
,ROW_NUMBER() OVER(PARTITION BY Teams, Category ORDER BY SUM(sales) DESC) AS rn
FROM Sales
GROUP BY Teams, Category
)
SELECT *
FROM sales_by_team_and_category
WHERE rn <= 10

Drew

• This reply was modified 6 years, 5 months ago by drew.allen. Reason: Added missing partition

Data should be stored in fields of the appropriate data type.  Dates should be stored in date fields, not character fields.  (There is an exception for intermediary tables that are...

Having separate threads for each topic makes it easier to follow each conversation and also makes it easier Google it.  I'm also having trouble understanding what questions you might have...

• This reply was modified 6 years, 5 months ago by drew.allen.

Actually, why don't you just insert it into your first temp table instead of creating a second?

create table #HomeroomTeacher2 (TeacherPersonID int , sectionTeacherDisplay varchar(105))

insert into #HomeroomTeacher2 (TeacherPersonID...

This only requires one temp table, which I think is what you are looking for.

create table #HomeroomTeacher3 (TeacherPersonID int , sectionTeacherDisplay varchar(105))

insert into #HomeroomTeacher3

SELECT TeacherPersonID, sectionTeacherDisplay
from HTeacher

UNION

SELECT...

• This reply was modified 6 years, 5 months ago by drew.allen. Reason: Added missing paren

Your conditions are contradictory.  You will NEVER get any records that meet all criteria.  Since AND is both commutative and associative, your conditions are equivalent to

(
 ...

if you look at recursive CTEs you can build a list of dates within your boundaries

then use SELECT DATEPART (DAY,GETDATE()) and exclude the Saturday and sunday values then count...

i...

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/execute-transact-sql?view=sql-server-ver15

 Note

This feature is in maintenance mode and may be removed in a future version of Microsoft SQL...

Unless you are required to do this for legal purposes, it's more trouble than it's worth.  Just assign identity or a date/time field when you create the record and then...

You should be using sp_executesql instead of using EXEC.  EXEC has been deprecated.

Drew

Unless you are required to do this by law, it's more trouble than it's worth.  If you absolutely have to do it, I would use a SEQUENCE and run a...

This was and still...

The following requires fewer scans, so it will perform better.  It does depend on having the identity field with a primary key.  You can use CHAR rather than BINARY as...

LAG() is not going to work here, because it goes back a specific number of records and this solution requires going back an arbitrary number...

First, simply stating that something "is not working properly" is not very informative.  Are you getting an error message?  Are getting wrong results?  How is it not working?

Second, your sample...