I fixed the typo but that made no difference. There is still nothing coming from this.

I am learning this from a book so i don't really know any better, but...

I dont' follow you?

Doesn't this pass the value of count to the @HowManyProducts variable?

Hi All,

I have been playing with this code and have finally got something that is accepted without any errors. Whats supposed to happen is that when you click on a...

HI,

thanks for the code, i still cant this to work i have all sorts of errors popping up, I just cant seem to get this to work. I'm popping out...

Ok I'll try it and see how i get on. But i may be back for some help 😉

Thanks

Tom

This is one of them:

-- populate the table variable with the complete list of products

INSERT INTO @Products

SELECT ROW_NUMBER() OVER (ORDER BY ProductID) AS Row,

ProductID, Name, SUBSTRING(Description, 1, @DescriptionLength) + '...'...

Hi,

Thanks for the reply so what you woul do is declare the table variable, and then create the table, and then you could continue with the code that comes after...