Hi all,

It works now, I just had to fix the parenthesis (brackets?)

Thanks !

I dynamically built 3 different queries, one for the first, one for the second and one for the third and it worked fine

Thank you, I found it, to share it with people, here is the trick

http://blog.sqlauthority.com/2008/04/02/sql-server-find-nth-highest-salary-of-employee-query-to-retrieve-the-nth-maximum-value/

Thank you all again 🙂

It didn't provide any results for the dynamically built query, but it was because I didn't specify the schema, once corrected, the query ran fine.

Still I am having an issue...

The problem I am facing is that I cannot use the output of the first query I am running :

select TABLE_NAME , COLUMN_NAME, DATA_TYPE, NUMERIC_PRECISION

from INFORMATION_SCHEMA.COLUMNS

in a second query, I...