October 26, 2010 at 12:16 am
Hi All,
I create stored procedure and it is working fine as required.
Now i want this stored procedure to be log on reporting portal.
please tell me what should i do with this variable ??
I want this variable to be input on reporting portal.
create procedure dbo.fady_details
@dep varchar (100)
AS
select mobdat.ID,CellNumber,MobDat.NoPos4Tx,mobdat.TimeBetweenSave,groups.GROUPNUMBE,
depots.DepotNumber,DepotName from GROUPS inner join Depots
on dbo.fady_match (Depots.DepotNumber) = dbo.fady_match (GROUPS.GROUPNUMBE)
inner join MobDat
on MobDat.NodeNumber = GROUPS.NODENUMBER
where Depots.DepotName = @dep
October 26, 2010 at 8:48 am
fawwad (10/26/2010)
Hi All,...please tell me what should i do with this variable ??
Not sure what you mean by what should you do with it???
on dbo.fady_match (Depots.DepotNumber) = dbo.fady_match (GROUPS.GROUPNUMBE)
This join is going to unbelievably slow if this table gets very big given that is has to call this function so many times. It will call this function the same amount of times as there are records in a cartesian. EEK!!!
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 27, 2010 at 3:55 pm
By "reporting portal" do you mean SQL Server Reporting Services?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply