[HELP]How to delete all Free guilds?

[instereo]

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..

[MentaL]

[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

[BlackEye]

Hmmm!Thanks oggyss for script!

[instereo]

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!