Use cursor to append row values?

I have a table like this (abridged):
Alert Period                  Department        AlertSetting
Down at least 1 day      DB      E-mail
Down at least 1 day      DB      SMS
Down at least 1 day      IT      E-mail
Down at least 1 day      IT      SMS
Down at least 1 day      QAG      E-mail
Down at least 1 day      QAG      SMS
......

I want to append the values in each row for each comination of Alert Period and Department like this:
Down at least 1 day      DB      E-mail/SMS
Down at least 1 day      IT      E-mail/SMS
Down at least 1 day      QAG      E-mail/SMS
......

I wrote a cursor like this, but the result I got is like:

Down at least 1 day      DB      SMS/SMS
Down at least 1 day      IT      NULL
Down at least 1 day      QAG      NULL

Can someone please tell me where I was wrong in the code?
Thanks a lot!!
------code------
declare @counter int,
        @count int
declare @AlertPeriod nvarchar(150),
        @Department nvarchar(50),
        @AlertSetting nvarchar(100)

create table #Rotate
             (AlertPeriod nvarchar(150),
              Department  nvarchar(50),
              AlertSetting nvarchar(100))

select @counter = 0

declare mycursor cursor
for select distinct [Alert Period], Department
from #ForCursor

open mycursor
fetch next from mycursor
into @AlertPeriod, @Department

while @@fetch_status = 0
begin
     select @count = count(*)
     from #ForCursor
     where [Alert Period] = @AlertPeriod
     and   Department = @Department

while @counter <= @count
begin
     select @AlertSetting = AlertSetting + '/' + AlertSetting
     from #ForCursor
     where [Alert Period] = @AlertPeriod
     and   Department = @Department

     set @counter = @counter + 1
end

insert into #Rotate
values (@AlertPeriod, @Department, @AlertSetting)

set @AlertSetting = null

fetch next from mycursor
into @AlertPeriod, @Department
end

close mycursor
deallocate mycursor