Si!

Amrita - that's as good as altering the view...you may as well create a procedure to do this!

Also, since you don't have categoryId in your view and only the categoryname,...

I take that back...I think you should go with Remi's suggestion of stored procedure - check for @productID - if > 0 then your select will be "products.discontinued > 0...

what's the hitch in having your view only select "WHERE Products.Discontinued = 0" and then querying it for either productID or categoryID....

Did you mean for your nStatus to be "2" in row 2 ?!

1. Staying "connected" is not the same as being online and actively participating

2. How modest!

3. How modest!

I think here's where knowing foreign languages helps - I know smatterings of several - enough to coin a "pass phrase" in a mixture of a couple of languages that...

Adrianne - maybe you should post this under the "Reporting Services" forum - you might have more luck there!

I've only had to use default collations so have never had to learn...

Sorry Remi - that's not a fair comparison:

1) You're online much longer than I am.

2) Your knowledge base is waaay stronger

Remi - when do you get your work done ?! You sure seem to have plenty of spare time!!!

Anyway, since Frank's posts have gone down considerably and yours' have increased,...

As far as I know - No!

Here's a link to the MS website that should help...

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_da_6ttf.asp

Maybe the manager just thought of a naming convention to standardise everything in their database & didn't realise the consequences ?!?!

Are you talking about unicode - like nchar etc.. ???

Sorry Amrita - but I still understand you to mean that your V1 view already has values filtered on A1 column from one table and A2 column on another table...

what's your typing speed Remi ?!