I am attaching the actual execution plan available.

The full execution plan is not available as an error message is encountered.

Msg 1105, Level 17, State 2, Line 61

Could not allocate space...

Many Thanks for your replies.

Can you please post an alternate code (not complete code) , so that it would be helpful to tune my query.

I have been working on the code, to remove cursors.

But one cursor, still hard to remove. Please guide me on this.

If further improvements are possible, please comment on that too.

CREATE...

I am in the process of converting cursors used in the stored procs to temp table code.

I have started like converting the first cursor, @specimensCodesCursor in stored proc usp_StatusHistory

SET @specimensCodesCursor...

I have added the statement SELECT @@NESTLEVEL in my query at different points in the stored proc eusp_e5_eSM_SE_GetHistoryForItem.

But everywhere it is returning a value 0, even at the previous line...

I am encountering an error below which is because of the nested operations in my code

Server: Msg 217, Level 16, State 1, Line 1

Maximum stored procedure, function, trigger, or view...

I wiil use the NVARCHAR 4K version of [DelimitedSplitN4K] for splitting the input parameter string.

If you can help me in rewriting the stoed proc usp_StatusHistory , it will be helpful.

I have debugged and found out that it is failing and throwing the error after this statement in usp_StatusHistory

FETCH @samplePartnerKeyCursor INTO @samplePartnerCode, @clientSampleCode, @internalSampleCode, @samplePartnerSqlId, @samplePartnerIncId

and hence the

CLOSE @samplePartnerKeyCursor...

I am posting the required code.

ALTER FUNCTION [dbo].[eufn_e5_eLIMS_SE_Parse_Delimited_List](

@listString nvarchar(4000),

@delimiter nvarchar(1)

)

RETURNS @listTable Table( listItem nvarchar(50) )

AS

BEGIN

DECLARE @pos int

DECLARE @itemString nvarchar(50)

SET @listString = LTRIM(RTRIM(@listString))+ @delimiter-- add trailing comma

SET @Pos =...

I have posted the complete code for the stored proc here.

I need a alternate way that code which cause the error can be avoided.

I have not developed this code and...

Just wanted to know, how this will be working.

DATEADD(mm, DATEDIFF(mm, 0, CREATE_DATE), 0)

Thanks in advance

The hierarchy is there in the container data.

The result of #content shows the actual container level hierarchy in the container list starting with the top most level container.

If we...

I am using this particular query for an SSRS report

It has two multivalue parameters Partners and containers

When the user selects 45 partners and 42 corresponding containers, the performance issue occurs.

This...

I am posting my query modified.

I'm trying with this query for sometime. Maybe someone can point me in the right direction.

CREATE TABLE #Content(id int identity(1,1),

SiteName nvarchar(1000),

containerName nvarchar(1000),

containerCode nvarchar(1000),

contentName...

Hey, This is how I tuned my query to avoid cursor in my code. Hope it helps. ...

If any suggestions are there, all are welcome.

CREATE TABLE #Capacity (CurDay DATE, WeekDy...