Search results for query: *

James, What is the significance of s1 - I don't know what it means?

Thanks James, unfortunately I had over simplified the problem. What if I also wanted the total 'Price' per shop. i.e. Shop1 - 900, shop2 - 1440, etc.

Consider the following: Shop Product code Price 1 001 200 1 002 300 1 003 400 2 008 370 2 011...

Can anyone give me an overview of this please?

Thank you mr Furious. IT WORKED HOORAY. YOU ARE THE MAN, you have saved my a@*!

This is the SQL I was using SELECT Name, Address, Date FROM dbo.client_info WHERE MAX(date) Here is the error message: ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 5:Incorrect syntax near ')'. Note: date is in decimal format Just to clarify, I only want...

I have a file that contains a number of lines for each month. New data gets added to it each month. The month is in the format YYYYMM and I wish to create a smaller table that only contains the latest month's infomation. I hoped it was as easy as Select name, address from clientinfo...

Hi, Within word, can you not just select view, toolbars and tick standard, formatting and drawing? Hope it is that simple!

I have just produced a pivot chart in excel but I wanted the series in a different order and so I right clicked on the series and selected format data series and changed the series order by moving up and down. The problem is that when I then make selections on the pivot chart, the formatting...

Forgive me as I am very new to SQL. I've been finding that if you introduce a new variable in a view it seems you cannot use it in that particular view. Is this the case or am I missing something?

Thanks MeanGreen, I tried the above and received an error message: Error 8118: Column 'bx1' is invalid in the select list because it is not contained in an aggregate function and there is no Group by clause. This error message was repeated for each variable. I then tried adding GROUP BY 'Box...

In the following problem the variables 'BoxtypeA - H are varchars. A '1' can appear in any of them. bx1 - 8 are the corresponding money fields of BoxtypeA - H. I want Box1 to be the sum of bx's where there is a '1' in the corresponding Boxtype A- H. So what is wrong with this? (From a very...