Thank you all for the valuable suggestions. I got it working using Michael's solution. It is perfect for what I need.

Yes, as Matt suggested, I can use cascading drop-downs up...

Thanks for the quick response. This is what I was trying to do:

I have a table (TableA) that contains 20 columns (Col1, Col2 through Col20). I want to retrieve 5...

Thank you all, I got it working using the COUNT function as it is simpler.

sg2000

Thanks, Matt. I found out what was wrong. I should expand the execute line as follows:

EXEC sp_executeSQL @SQL,@OutputDef, @val = @Output OUTPUT

SELECT @Output

@Output is a user's parameters

The SP...

Thank you all for the suggestions. I tried them but still encounter problem. Even with the most simple example as listed in the tutorial encoutered error. My SP code is...

To All:

Thanks very much for the suggestion of using sp_executeSQL with parameters. I tried the following:

DECLARE @SQL varchar(1000), @Param varchar(500)

SET @param = '@Output varchar(50) OUTPUT'

SET @SQL = 'SELECT @Output ='...

Hi John and Roy:

Yes, Dynamic SQL works for me! Thanks for the advice.

sg2000

Thanks Grant for the info.

sg2000

Kent:

Thanks for the quick response. However, I can't figure out how to fit what you recommend in a View? Anyway, I got it working by following the suggestion from Grant...

Grant:

Thanks very much for the quick response. Yes, it works!!!! I just wonder why TOP 1 works and not MAX. Well, may be I can find out later on. Thanks...

Antonio:

Thanks very much for the alternatives. As posted before, I use Convert (decimal (5,3), xxx...) instead of Convert (decimal (3,3), xxx...) and it does work. This is the best option,...

Matt:

Yes, you are right. I changed it to Convert (decimal (5,3), xxxx....) and it works. Thanks!

sg2000

Lowell:

Thanks for the quick response. However, when I tried the method you suggested on the calculated column Ratio (see below) and execute the SQL, I got SQL Execution Error window...