Forum Replies Created

Viewing 6 posts - 106 through 111 (of 111 total)

  • RE: Pivot & Order By

    john.arnott (5/28/2009)

    I may be missing something about what you want to do, but it seems that just moving the "order by" to the end of the query may work.

    After...

    May 29, 2009 at 2:59 pm

    #1002287

  • RE: Pivot & Order By

    john.arnott (5/29/2009)

    Usually, as in this case, the original poster will confirm that they've got things worked out. And actually, often different people will have offered multiple suggestions and we...

    May 29, 2009 at 12:18 pm

    #1002206

  • RE: Pivot & Order By

    john.arnott (5/28/2009)

    I may be missing something about what you want to do, but it seems that just moving the "order by" to the end of the query may work.

    I...

    May 29, 2009 at 7:59 am

    #1002063

  • RE: fULL OUTER JOIN IN T-SQL

    How about

    SELECT Recipe_Classes.RecipeClassDescription,

    Recipes.RecipeTitle

    FROM Recipe_Classes full outer join Recipes on Recipe_Classes.RecipeClassID = Recipes.RecipeClassID

    May 28, 2009 at 2:57 pm

    #1001787

  • RE: PIVOT QUERY HELP NEEDED

    Hi All,

    While working on this PIVOT thing I observed something and I have drawn a conclusion.

    My sample query:

    declare @test-2 table(myno varchar(25), mydate datetime, mystatus varchar(1), mytype int)

    insert...

    May 26, 2009 at 4:34 pm

    #1000246

  • RE: Reporting Services: Adding extra columns / rows to a matrix

    Really a clever way. I've been using the addition of an extra table with similar grouping as the matrix one but then I always lost the ability to export and...

    July 24, 2008 at 8:26 am

    #847808

Viewing 6 posts - 106 through 111 (of 111 total)