Home Forums SQL Server 2005 T-SQL (SS2K5) Query Help - difference between last and current year RE: Query Help - difference between last and current year

  • hi here is the create table and insert and my query to get data for 2009 and 2010 year,,

    the result will be like this:

    LASource1YTD 200969

    LASource1YTD 201068

    I want to show variance below

    LASource1VARIANCE-1

    hope you got it...

    Just run the code the query will show the aggregated count...

    I need variance below now...

    Any help on this...

    thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]