|
|
Posted by Erland Sommarskog on 01/05/07 11:17
Mintyman (mintyman@ntlworld.com) writes:
> Thanks for the script. The difference between the Northwind database and
> mine is that all the data I want to get access to is in one table (unlike
> Northwind where it is spread over [order details[ and [products].
I could have done the script with product ids instead of product names
but that seemed boring.
> It says there is an invalid column name 'rowno' - I guess this is right
> because there is no column with that name in my database! However, when I
> check in Northwind, there isn't one called that there either!
The column rowno is defined in the derived table. I suggest that you study
my query a little closer, and try to understand what it's actually doing.
It might be that you want to be spoon-fed a solution, but I have this funny
idea that I like to help people to help themselves. That is, when I post a
solution, I hope that people do not only use it, but also try to understand
how it works, so that the next time they run into a similar problem, they
now have something in their toolbox that they can apply.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|