You're welcome

Jeff Moden (8/19/2014)

---

davidmckee (8/19/2014)

---

This is the exact result...except it seems to be in MSSql...the web server runs MySql

I did some research after copying the code into the query and receiving...

I'm not sure what tool you are using to connect to the database, so I can't give you any help on that. The statement I provided is to create...

I would go for computed columns for the winner/loser

Something like this:

CREATE TABLE Games (

HomeTeam CHAR(1) NOT NULL, -- use an appropriate varchar if you have full names

AwayTeam CHAR(1) NOT NULL,...

davidmckee (8/19/2014)

---

I have attached the excel file.

The standings is not a true table...it looks to the "games" table and the standings are all calculated and sorted.

So I have created the...

I think this should do the trick, however I am assuming that the MIN and MAX functions are fixed to the entire range.

WITH ExcelData AS (

SELECT *

FROM (VALUES

('A',6,0),

('A',6,0),

('A',4,2),

('A',3,2),

('A',3,3),

('A',3,3),

('A',3,3),

('A',1,5)

) EXCEL(Team, Wins,...

Glad to see it helped.

Thanks guys

That was the article I wanted to link to before I ran out of time 🙂

Hi

ISNUMERIC may not be doing what you are expecting.

Try the following

SELECT lat

FROM #t

WHERE lat like '%[^0-9.-]%';

SELECT long

FROM #t

WHERE long like '%[^0-9.-]%';

Where does MS SQL store the cache? Is a view cache or the index that you mentioned exist after a reboot or does MS SQL have to work to recreate...

I suppose it comes down to where you want the performance hit to happen.

If you have a table that has a lot of changes happening to it but is infrequently...

Hi

You may also want to look at indexed views.

Edit: added link

Good question thanks

Hi

You subqueries are returning the sum for all ITEMNOs and LOCATIONCODEs. I suspect you should be joining these to the outer query of ITEMNO and LOCATIONCODE.

select ITEMNO, LOCATIONCODE

, AVG(UNITCOST)...

SQL Server will not natively reporject, but the is an option to create or use...