How to find empty collection
-
sábado, 16 de junio de 2012 15:35
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 |
Todas las respuestas
-
sábado, 16 de junio de 2012 15:37
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
.png)
