Why?

This comment assumes that a balance of...

Hi Gail,

No apologies necessary. I appreciate the help.

The following query works.

SELECT StockCount.id, StockCount.SizeID, StockCount.Count, StockCount.OutDate, FunctionStock.ID AS Expr1, FunctionStock.StartDate, FunctionStock.EndDate,

...

Hi Gail,

I have been trying different queries in an attempt to learn more about SQL.

The following query does not work, but it does represent what I am actually trying to...

Hi Gail,

I am appreciating your persistence with this. Thank you.

> You want all stockcount entries that don't have matching entries in FunctionStock for a particular date?

Almost. I need all stockcount...

Hi Gail,

File structures are:

StockType

ID, int (PK)

Type, nvarchar(50)

Charge, money

StockStyle

ID, int (PK)

TypeID, int

Style, nvarchar(50)

StockColor

ID, int (PK)

StyleID, int

Colour, nvarchar(50)

StockSize

ID, int (PK)

ColourID, int

Size, nvarchar(50)

StockCount

id, int (PK)

SizeID, int

Count, nchar(2)

InDate, datetime

OutDate, datetime

OutReason, nvarchar(100)

FunctionStock

ID, int (PK)

StartDate, datetime

EndDate,...

Hi Gail,

Thanks for the reply. It has been a big help.

Here is the SP I have created based on your example:

SELECT StockCount.id, StockCount.SizeID, StockCount.Count, StockCount.InDate, StockCount.OutDate,...

Hi All,

Thanks for all the suggestions. I have taken a mix and come up with a result that works well for me.

For those interested, I have column names of...

Hi Peter,

Thanks for the sample. What I need is something more like...

SELECT SUM(Col1), COUNT(Col1), COUNT(*)

FROM Table1

WHERE ...

Thanks Chirag,

Could you provide a sample SP of how to address multiple columns for both SUM and COUNT at the same time? How do I return the multiple results?

cheers,

Mark

I'm inclined to agree with you. Trouble though is I am just the "outside" consultant who gets called in after decisions have been made. The client will use this software...

They are being rather coy about the details.

I have not had the chance to test the application as it is an upgraded version of an app the client has used...

Hey Guys,

Got it sorted!

I created my table user IDs before the database user IDs 🙁

cheers,

Mark Chimes

There is one further question I meant to ask.

Does it make any difference if the workstation is running Windows XP home edition rather than Professional edition?

I realise this means the...