Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Get count of each ID in query

    dnt know if this is what u want.

    Select DataID, Title, Count(*) Over (Partition by DataID) as Result

    FromProblem1

    Order By DataID

    the result is in this form

    1Names2

    1Names2

    2Books1

    3Movies1

    4Papers1

    5Areas4

    5Areas4

    5Areas4

    5Areas4

    6Box1

    January 21, 2009 at 2:56 pm

    #930738

  • RE: CLR function with temp table

    GREAT..its working fine now..

    thanxx.

    June 11, 2008 at 2:56 pm

    #827546

Viewing 2 posts - 1 through 2 (of 2 total)