• Hi All

    Below is my entry

    declare @count int, @message nvarchar(10), @message1 nvarchar(10), @message2 nvarchar(10)

    set @count = 1

    while @count <= 100

    BEGIN

    set @message = '' set @message1 = '' set @message2 = ''

    IF @count%3 = 0

    set @message1 = 'BIZZ'

    IF @count%5 = 0

    set @message2 = 'BUZZ'

    set @message = @message1 + @message2

    select @count, @message

    set @count = @count + 1

    END

    sorry i have to get back to work so i did not check how quickly it run