Thank You Eirikur.. Loved it..

One more help. Is it feasible for this value to be shown

INSERT INTO #ActivityComments VALUES('S14-04932-01 + S15-04931-01 + S14-04932-02')

Output

----------

S14-04932-01, S15-04931-01, S14-04932-02'

I am getting an error..

Please guide me on this.

SELECT

CASE WHEN PATINDEX('%S[0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9]%',Comments)>0

THEN

SUBSTRING(Comments,PATINDEX('%S[0-9][0-9]-[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9]%',Comments),12)

FROM #ActivityComments

ELSE

SELECT ' '

END AS ActivityComments

Hi anthony.green,

The script you posted also fetches the same result. E10 is coming just below E1 0DAA1. In the required output, it should come below E9.

<= and >= did not give me the required results.

I tried that way.

Hi Kevin

It will be useful if you can explain me with some code change example, in the way that will benefit the query performance.

Would be grateful if any of the members can post a sample alternate way for my cursor part. This will throw light how to proceed on this.

Also, suggest some way...

Ok..I agree with Wayne. Please help me in get rid of the cursor by alternate code.

I am new to this set based approach, removing the cursor.

Instead of removing cursor, please help to me to modify the existing code within.

Please suggest me what all changes I can make in this SELECT statement given, taking the performance into consideration.

Thank You for the comments..

I am a newbie in perf tuning. Please help in getting a alternative for CHARINDEX and LTRIMs.

Also how this part can be rewritten in view of...

Thank you all for the replies.

Actually my need is to rearrange the JOINs and ON conditions in a meaningful readable way.

There are so many JOINs written in a very difficult...

Yes Chris, You are correct. I want to get last position from StoringEvents Table.

Thanks for the help.

This was the existing code which I wanted to change for two textboxes.

=Fields!internalPartnerName.Value & "

" & Fields!addressLine1.Value & "

" & Fields!addressLine2.Value & "

" & Fields!addressLine3.Value &...

Please modify my code so that I can get the idea.

In both cases, ie. If DB field is NULL or DB field is empty, it shows an empty space in the report.