Luis,

with over 6100 points, you've been around awhile.  You know we need DDL and data with expected results to help.

Can you provide what you are expecting for results?  Also, how do the tables relate?

try this

It would be nice if you supplied some meaningful data and expected results.  What you provided is missing amounts for all records expect the last one.  You're expected results are...

have you tried anything or just looking for someone to give you the solution?

First of all, why????

secondly, you'd need to set identity insert on before inserting to the second table (I assume there is an identity column on it, but it's...

Try Rank

select * from (
select EName, UnitsSold, Category,
        Rank() over (partition by category order by UnitsSold desc) Ranking
from #t) t
...

Steve is right.  This is only selecting one record.  declare @calendarID VARCHAR (8000) = (SELECT schoolID from dbo.school)

You would need something like this to get all the values

You can use a dynamic pivot.  I have a table function called Tally that I use to generate the numbers. You pass in where you want to start and end. ...

I setup a very similar process using RowVersion datatypes.  Then kept track of last RowVersion for each table.  I go the largest RowVersion > previous and then retrieved all records...

would be nice to have DDL so we could help

Wow!! this kinda got ugly.  Lynn was trying to explain how %ROWTYPE% works.  I think the OP is used to using Oracle and was just asking if there was a...

you can also setup a maintenance plan to rebuild/reorg indexes automatically at night.  I agree with Steve that this should not be an app that allows users to do this...

Please provide DDL and some sample data.  Based on what you are asking for results, does this work for you?

For better, quicker answers, click on the following...

http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/