What I want to do (I know this does not work) is:
update stats set BandwidthLastMonth = BandwidthThisMonth, BandwidthThisMonth=0 where myPk = 3
Is there a way to do this in a select statement? Or do I need to write a stored procedure and hit each record twice (I sure hope not).
My solution needs to work for Sql Azure and Sql Server 2008.