Viewing 5 posts - 1 through 5 (of 5 total)
Hi all,
It works now, I just had to fix the parenthesis (brackets?)
Thanks !
July 12, 2012 at 3:52 am
#1511957
I dynamically built 3 different queries, one for the first, one for the second and one for the third and it worked fine
July 10, 2012 at 5:25 am
#1510825
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 🙂
July 10, 2012 at 2:39 am
#1510738
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...
July 10, 2012 at 2:26 am
#1510729
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...
July 9, 2012 at 6:35 am
#1510300