EXEC sproc

• 
  Hello Bill,
  
  This should definitely work. When you hover over this particular stored procedure, do you see something in a tooltip similar to 'NOT SHOWN:spRankDataSet '?

  Brian Donahue October 04, 2006 11:32

  - 0 +
• 
  No, it doesn't show me any extra information when I hover over the stored procedure. When I create my project, I just select the 'stored procedures' group.
  
  I've pasted a portion of the stored procedure below and how the EXEC call is being done. Let me know if you need any other information!
  

  	IF (@UseCache)=1	-- our DataSet has already been defined
  	BEGIN
  		EXEC spRankDataSet @EntityId, @TypeID
  	END
  	ELSE -- use the entire Entity table as DataSet
  	BEGIN		
  		-- create the temp table
  
  		CREATE TABLE #DataSet
  		(
  			numID INTEGER IDENTITY(1,1),
  			FkItemEntityID bigint not null,
  			ComparisonValue decimal(10,4) not null,
  			ComparisonSlice int,
  			PRIMARY KEY CLUSTERED (numID),
  			UNIQUE (FkItemEntityID, numID)
  		)
  
  		-- exec spNewRankUsers
  		INSERT INTO #DataSet EXEC spNewRankUsers @EntityID, @TypeID, @MaxRecords, @PageNum
  	END
  

  wdevine October 04, 2006 14:31

  - 0 +
• 
  Hello,
  
  Can you script the spRankDataSet stored procedure as well?

  Brian Donahue October 05, 2006 06:45

  - 0 +
• 
  Hi Brian,
  
  Sorry I didn't get back to you quickly. I was travelling. Here's the spRankDataSet script that you asked for.
  
  Also, if you'd like the whole db schema, give me an email you'd like it sent to.
  
  Let me know if you need any other information.
  
  Thank you,
  
  Bill
  

  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;
  
  
  
  SELECT e.EntityId as FkItemEntityId, cast(count(wd.WordText)*avg(cast(ww.XLoc as numeric(9,4))) * 0.01 as numeric(9,4)) as ComparisonValue,
          null as ComparisonSlice
  		INTO #DataSet2 FROM #DataSet ds
  	INNER JOIN Entity e ON ds.FkItemEntityId = e.EntityId
  	INNER JOIN WordDef wd
  	INNER JOIN WordSelection ws
  	INNER JOIN #entityWords ww
  		ON ws.WordId = ww.WordId
  		ON wd.WordID=ws.WordID 
  		ON ws.EntityID = e.entityid
  	where wd.WordText in (select t.WordText from #entityWords t)
  		group by e.entityid 
  
  
  Update ds
  Set ComparisonValue = ds2.ComparisonValue
  From #DataSet ds
  JOIN #DataSet2 ds2 on (ds.FkItemEntityId = ds2.FkItemEntityId)
  
  drop table #DataSet2
  
  
  GO
  

  wdevine October 11, 2006 12:52

  - 0 +

Add comment

Please sign in to leave a comment.