[HELP]How to delete all Free guilds?

Hello guys,
I need some script for sql agent for delete all guilds where is only one member (free guild), cose i have over 700 guilds and half is free of members.. It's sux cose SQL server taking more thant 80% of CPU..

declare @guild varchar(14)

declare lista cursor local forward_only for
SELECT dbo.Guild.G_Name
FROM dbo.Guild
LEFT OUTER JOIN dbo.GuildMember ON dbo.Guild.G_Name = dbo.GuildMember.G_Name
GROUP BY dbo.Guild.G_Name, dbo.Guild.G_Score
HAVING (dbo.Guild.G_Score < 5) AND (COUNT(*) < 1)

open lista
fetch next from lista into @guild
while @@fetch_status = 0
begin
execute WZ_SetGuildDelete @guild

fetch next from lista into @guild
end

close lista
deallocate lista

Hmmm!Thanks oggyss for script!

Quote:

---

Originally Posted by oggyss

declare @guild varchar(14)

declare lista cursor local forward_only for
SELECT dbo.Guild.G_Name
FROM dbo.Guild
LEFT OUTER JOIN dbo.GuildMember ON dbo.Guild.G_Name = dbo.GuildMember.G_Name
GROUP BY dbo.Guild.G_Name, dbo.Guild.G_Score
HAVING (dbo.Guild.G_Score < 5) AND (COUNT(*) < 1)

open lista
fetch next from lista into @guild
while @@fetch_status = 0
begin
execute WZ_SetGuildDelete @guild

fetch next from lista into @guild
end

close lista
deallocate lista

---

Thank you!