Posted by Mintyman on 01/05/07 13:09

Hi Erland,

I totally agree with not being spoon fed! I'm sorry I came across as wanting
to be. I'll try and work out what your script is doing :o) Thanks for your
help!

Mintyman

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98AF7D09BCD42Yazorman@127.0.0.1...
> 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

[Back to original message]