Mine
public text v1 · immutableDECLARE @TypeVar nvarchar(4000),
@sql nvarchar(4000)
DECLARE Typer CURSOR FOR
SELECT Distinct Type FROM temp_data
FETCH Typer INTO @TypeVar
while @@fetch_status <> 0
select @sql = 'count(*) from temp_data where Type = ' + @TypeVar
PRINT @sql
FETCH NEXT FROM Typer Into @TypeVar