If you looked at the poster you guessed it right!

So far I am with the others NO CURSOR NEEDED to accomplish that

Guessing is a good part of this kind of questions .... I'd guess 

Not sure but shouldn't it be :

SELECT DATEPART(YEAR, SaleDate) SaleYear, Product, AVG(SaleQty)AvgSales

FROM

orderdetail

GROUP BY DATEPART(YEAR, SaleDate), Product

At least that's what I interpret by accross all years and months...

Just want to add that when the number of repeated keys on the inner table is large exists is always a superior choice but when the keys are not repeated too...

did you use sp_rename for that?

if yes did those tables had triggers on them ?

if yes fix the triggers

You need to have a look at Alternate synchronization partners

Not sure why it doen't for you it still does for me!

The following link is one step before the download. Try clicking on the right hand side link and see...

I don't use enterprise manager except for the cases in which I have no other choise. My approach is

1. find all the tables that are on the Filegroup that...

You are going to need to talk to your network guys apparently someone applied a strong security template GPO to your server if what you said is the case

Try:

EXECUTE sp_makewebtask @outputfile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.html', @query = 'EXECUTE YMCA.dbo.spMoveSelect @Action=3, @ID=0, @Var1=19', @templatefile = 'd:\harvestwise\hwsystem\pickup\PMDRpt.tpl'

Cool name for a DB

You should look at implementing Multiserver administration with SQLServerAgent

Have a look at that topic in BOL.

SELECT orderNum, Sum(Convert(decimal(10,2), shipamt)) as totalShipped FROM invoiceData

WHERE shipamt <> ''

GROUP BY orderNum

With stored procedures you code manually the deletes starting from the lowest in the hierarchy! with triggers you could do the same thing but Triggers are more difficult to debug maintain...

AWE is not needed when Windows total memory is 4GB!!!