Thank you Kenneth. Will do. Personally I do not see how saving on forum space may help but since I am a newbie here, I couldn't object and thought I...

Thanks, I appreciate all help, so pls do not feel bad if it will take time. I'll be in touch.

Chris, very kind of you but since I am the one in need here, you or other members are under no obligation to apologise for any delays.

I've looked at your...

As I said I am equally amenable to using an sproc for this case. Although I only discovered their power recently (AFTER joining this site!), I regard stored procedures very...

To Chris:

This is an extract of the view I am using:

SELECT FOODS.Des, LOCATIONS.Location, RECIPES.Qty As Qty1, INVOICEDETAILS.Qty As Qty2, PRODUCTS.Product, UNITS.Unit

FROM InvoiceMaster INNER JOIN InvoiceDetails

ON InvoiceMaster.Inv_No = InvoiceDetails.Inv_No

INNER JOIN...

Nice touch.

Thanks Carl Serge.

Carl, if you can get ThisMonday from your code, can't you short-circuit it to get NextFriday too? I tried it, works fine.

if object_id('tempdb..#YWK') is not null drop...

I am a greenhorn in SQL, so I hope you understand that I asked out of curiosity, not to show off. No offense intended.

Sergiy, your solution as usual is brilliant, but if you check back the OP wants to process an argument that is in yyyyww format.

Ken, I broke it up into its constituent statements and ran them separately, and yes as Michele says, they run fine, but I am certain if left on my own...

Ken, thanks, (how I wish I could understand its sntax construction).

BTW, is the Maxdop option necessary? I looked it up in BOL and it made me feel that it may...

Thanks, I got it.

The solution you want may be simpler than it seems, if only we can get DDL for ArticlesInStock Table.

As it stands, there is duplication of values in the two columns,...

Thanks, again, and please help me one last time:

How do I get a handle on this recordset from my VB6 code?

I normally run Stored Procedures with the statement

Conn.Execute "stored_procedure_name".

How can...

Michele, i do not think I quite understand you; before I reply I need you to tell me:

1. whether I understood your problem correctly or not?

2. in slightly clearer terms,...

Thanks, it is what I was afraid of.

Question: I still want to work with a view, how can I write a Store Proc to return a view? (It's a dumb...