Thanks for the replies.

I replaced my CASE statements with a PIVOT statement and now my query seems to be running fine.

This is what my query looks like now:

SELECT BranchName...

Thanks.

I tried eliminating the cursor and it works fine now.

Sorry about my post...I will observe the pattern in my next posting.

Sorry Jon I am not an expert in SQL 🙁

I didn't understand how to use sub-query for my query.

Can you help.

Also, the above query doesn't get me the desired results....

I am sorry about that.

Currently my results are displayed as:

Checks Customer Complaints Securities Transactions.....

Member Firm A, 9/26/08 ...

thanks !!

that was really helpful

thanks I got that working

I just changed my case statement as :

CASE

WHEN (SELECT qq.LogEntryStatusID

FROM Transaction2821Journals zz INNER JOIN

Journals qq ON zz.LogEntryID=qq.LogEntryID INNER JOIN

LogEntryStatus ll ON qq.LogEntryStatusID =...

I already use a case statement in my stored proc.Can i nest two case statements.

Also, I am not passing status as a parameter.

When a particular row is found it shouls...

Thanks, I got that working.

At some times the len was coming out to be zero that's why the error.

I appreciate your efforts.

I am sorry I didn't realise it was a big chunk of code.

I have now attached the script for my sql statement.

Hi,

I have yet another problem that I am facing with the query.

I am trying to run a rport from my ASP.NET code that uses the query we wrote earlier.

My...

This was a helpful query.

I tested the query with my tables and data and it gives me the desired result.

Thanks for helping me out with this.

I am sorry if I didn't make myself clear enough.

Though I don't quite understand what you meant by the expected output.

I need to select all the columns from the table...

Oh and along with that there are some conditions that always need to be met...like the producttype and transactiontype...so there are some conditions that will go in an AND conjunction.

I want to pull records that fulfill any of the given conditions:

Client Age (>/</=) certain number

Amount (>/</=) certain number

Annual Income (>/</=) certain number

TransactionPercentofNetWorth (>/</=) certain number

Time Horizon is in given...

Here I have uploaded the DDL and Data