Hi Goodguy, please can you QC the following? I've taken a couple of liberties e.g. introduced 'CUP' as a unit for 'TEA'.

Cheers

ChrisM

DROP TABLE #FOODS

CREATE TABLE #FOODS (FOOD_ID int, DES varchar(20),...

Thanks for the words of advice Kenneth, I'm a newbie here and still learning the ropes. I'll bear in mind what you've said.

Cheers

ChrisM

Hi Good guy, I understand the nature of the problem - please bear with me - we should be able to knock this one on the head very shortly. To...

Hi Goodguy, apologies for the delay, I'm on UK time - for reference this is posted at 09:35.

The previous post gave you the invoice side of things, now we need...

Hi Goodguy

Can you post the query you already have, to show the joins?

I'm sure this is do-able. You will almost certainly find it easier by packaging your tables into two...

Launch a missile? Good lord no...here's some pizza launched to say thanks for fixing holes in my dodgy code! Good luck with your new gaff.

Cheers

ChrisM

Almost, Amit, but not quite. Your query will generate 2 errors:

Server: Msg 107, Level 16, State 3, Line 1

The column prefix 'studentmaster' does not match with a table name or alias...

Steve - yes it is, thanks...sorry Brandie, day got busy.

My driving instructor has a really large cushion in his boot for Heather, who is I guess around 4 feet...

Hi Dan

Instructions for creating a numbers table exist on the forum, e.g. see posts by Jeff Moden.

Left-join your vendors table against a numbers table and use a WHERE clause, like this:

SELECT 'v9' +...

Ouch! Self-inflicted, no sympathy. Anyway, hitting my knee with your fist probably hurt you more than it hurt me!

Seriously though, it matters a lot, and I'm appalled you didn't get...

<<lower the desk for me>> <<feet dangling off the floor>> heh heh you're kidding right Brandie? Can't you use a cushion? Have you tried sitting on the desk on the...

<<What if I order the same item twice, but manage to have each item listed seperately on the order (if possible)? >>

I've had to code for this in the past, in...

Reckon most of the important points are covered here, but it's also worth pointing out that it's easy to get confused between business entities and database structure entities, and if...

Spot on, Jeff, and apologies to you, Surya.

Ok, fourth and last try, after this I'm giving up. Surya, please, open the file in a text editor and post the first three or so lines. This will show...