There's no difference. SQL Server will interpret them as the same query.

measterbro (11/12/2014)

---

Thank you for your reply.

Your query works but it only uses wins for the calculation.

In this example:

WLGB

B410

A253

The "games behind" are found by subtracting Team A wins from Team B...

You should use error files to identify those rows an understand why they're missing.

Maybe something like this could help you.

WITH GamesWon AS(

SELECT Lge,

GameDate,

HomeTeam...

It's a nice question that might confuse some newbies. It's important to study the logical operators and the results given.

I'd love to see in the explanation that the correct answer...

Why do I always forget the safety net? I live on the edge. :hehe:

DECLARE @x table (y varchar(100));

INSERT INTO @x VALUES

('ReportServer-SalesOrders'),

('ReportServer-OKLA-SalesOrders'),

('SalesOrders');

SELECT REVERSE(left(REVERSE(Y), charindex('-', REVERSE(y) + '-')-1)) ,

...

Here are 2 additional options:

Note that PARSENAME can return incorrect results if you have dots in your values or if you have more than 4 sections.

DECLARE @x table (y varchar(100));

INSERT...

You don't need a loop. You need a really fast splitter which you can find in the following article: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Once you split the data, you just need some cross tabs...

Sometimes we miss the little details and just need a different point of view.

Glad I could help.

jennigirl (11/10/2014)

---

I am trying to pull a report with average down time and I getting the error message "Msg 195, Level 15, State 10, Line 4

'AVG' is not a recognized...

I can't find the documentation, but I'm sure that it's because that's a parsing error while the others are execution errors.

Your question seems incomplete.

You can modify data in SQL Server using views with some restrictions, check the following article: http://msdn.microsoft.com/en-us/library/ms180800.aspx

Doctor Who 2 (11/6/2014)

---

Hi Steve (or anyone else at the PASS conference), what you wrote suggested to me that people could see at least some of the presentations online. How...

Sean Lange (11/6/2014)

---

I am back. Had a major project get deployed 2-3 weeks ago. This was a complete top to bottom rewrite of our ecommerce system that took nearly 2...

You're right, it wasn't about performance. It's because the splitter works on a single char basis. Modifying Alan's example could give us undesired results.

SELECT *

FROM dbo.PatternSplitCM('blrah1 \r\ bl\ah2 \r\ blah3','%[\r\]%')

WHERE...