Let's modify the query from the QoD a litle bit:

DECLARE @A TABLE (a varchar(20) NOT NULL)

DECLARE @b-2 TABLE (b varchar(20) NOT NULL UNIQUE)

INSERT @A VALUES (1)

INSERT @A VALUES ('a')

INSERT @b-2...

And here we come to the order of SELECT statements execution.

1. FROM

2. INNER JOIN

3. WHERE

...

SELECT comes somewhere 7th or 8th in line.

After that comes GROUP BY.

And that's where the aggregation...

Hugo Kornelis (1/12/2012)

---

I think the problem is lingual.

"Is executed" can have two meanings.

1. Present tense, passive form - the code is invoked. Can be compared to running "EXEC MyStoredProc" in...

Actually something does.

It's named "bookmark lookup".

As...

Hugo Kornelis (1/12/2012)

---

Most operators don't process all data at once; they are called repeatedly...

Simple question:

what's being aggregated if the data in the table have not been scanned yet?

Check the topic "DATETIME Query problem" on the 1st page of this forum.

Might be exactly the same issue.

CAST uses server's default DATEFORMAT settings, which are not probably the...

Just leave only "right" fraction in the lookup table, and...

FLOAT is not a character type, it's a numeric data type.

That's why this your statement...

There 2 main problems here.

1) 2.50 may represent odds...

This query will work out all odds at once:

DECLARE @Odds TABLE (

Odds varchar(20)

)

INSERT INTO @Odds (Odds)

SELECT '1/1'

UNION

SELECT '6/4'

UNION

SELECT '5,6/4'

UNION

SELECT '8/3'

UNION

SELECT '1/1'

UNION

SELECT '1,1'

UNION

SELECT '11/10'

UNION

SELECT '1000/1'

UNION

SELECT '5/7'

SELECT Odds,

CONVERT(DECIMAL(10,2), (CONVERT (decimal(18,6),...

Or read this article:

http://www.sqlservercentral.com/articles/Test+Data/61572/

It's from the same author, so should be as useful.

🙂

Check the outcome generated in The "Hog" Test.

Just export 2 columns generated by the query to comma delimited...

You nay use a "concatenate" function to put all the answers into a single varchar value, including all quotes and commas.

After that you just export that 2 columns table to...