CREATE Procedure [dbo].[spRankDataSet](@E bigint,@T int = sfEntityTypeVisualizerValue -- default, this is the typeId for Visualizer)as -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;