OPEN H_BM_Cursor FETCH NEXT FROM H_BM_Cursor into @bmid,@bmmc -- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE @@FETCH_STATUS = 0 BEGIN declare @strtemp varchar(50) -- Concatenate and display the current values in the variab