Stuff
public sql v1 · immutableDECLARE @TypeVar nvarchar(128), @StationVar nvarchar(128), @sql nvarchar(4000)print 'Start'DECLARE Typer CURSOR FORSELECT Distinct Type,Station FROM temp_dataOPEN TyperFETCH Typer INTO @TypeVar,@StationVarWHILE @@fetch_status <> -1BEGINSET @sql = N'select count(*) from temp_data where Type LIKE ''' + @TypeVar + ''' AND Station LIKE ''' + @StationVar + ''''EXEC sp_executesql @sqlprint @sqlFETCH Typer into @TypeVar,@StationVarENDCLOSE TyperDEALLOCATE Typer