none
How to find empty collection

    Pregunta

  • How could find those collections which have 0 memebers,

    i lots of collection is SMS , and wanna delete those collcetions, and lots of collections have 0 members, so i want to find those collections,

    please let me know the sql query to find out


    Sharad Singh | My blogs: SharadTech | Twitter: @MrLucknowWale |

    sábado, 16 de junio de 2012 15:35

Respuestas

  •  got it i can use this query

    select
        C.Collectionid,
        C.Name
    from
        dbo.v_Collection C
    Where
        C.Collectionid not in (Select Collectionid from dbo.v_FullCollectionMembership)


    Sharad Singh | My blogs: SharadTech | Twitter: @MrLucknowWale |

    • Marcado como respuesta SinghSharad sábado, 16 de junio de 2012 15:37
    sábado, 16 de junio de 2012 15:37