My next question would be WHY?

This feels like it is a presentation issue and should be handled in the presentation layer (report or view) and not in the...

MSSQL 2000!

Please don't use this for production 🙂

+1 for delimited split 8K
be aware though that you are doing a 3 way Cartesian join so with 3 elements you are selecting 1 from 27 combinations, with 4...

I feel your pain and although I also agree with Jeff that subscriptions can be a pain,  I would still be looking at reporting services as an option.

If...

what is the original data source.  Some ODBC drivers (e.g. Progress) do not have a very tunable buffer size.

Looking at the ERD there is a many:many relationship between Category and Department (i.e. the same department can appear in many categories - hence the bridging table DepartmentCategory)

A...

pedant 🙂

There are many things that can cause SSIS to pause. Buffer size and row size are one as you have correctly identified.  Some tasks can be considered blocking (require all...

OK. you're not going to like this but that is probably not a good database design pattern.  Can you re-factor so that the steps are in one table and the...

Kudos for getting it to work but I can't help feeling that you are building up some technical debt here.  Managing that email going forwards could prove difficult.  Have you...

The example you have given is clearly not the business problem you are trying to solve.  SQL does not give you tables, it gives you data sets

Depending on...

you should be using your own code ! 🙂

don't run code you don't understand in production

+1 for the use your own schema

Another option if you only need the reference data inside a single sproc would be to use #temp_tables or @in_memory tables.  #tables...

Ignoring the posts which became a flame war.

Reading between the lines, I think to OP is mildly frustrated about the fact that sprocs can't take tables as parameter...

My initial answer would be YES this is normal.  This assumes that there is a business requirement to be able to report on aggregated values at different levels of the...