I learnt something about XML, Discussions was very informative.

XML..

I always try to find alternate for XML. "I have to learn XML"- This has became part of my new year resolution. But I never tried to stand with my...

Roddy.CAMERON (1/23/2013)

---

Hi Hugo

I think it maybe really relates more to a terminology thing and the fact that the command actually performs 2 different actions, rather than being inconsistent in my...

Simply I guessed XML and got it wrong.

Nice question.

From the explaination I understood even duplicate values can be generated using DBCC CHECKIDENT.

Topic says BIT data type but explaination deals about ELSE (IF...ELSE). By seeing the question I expected something about NULL handling with BIT Data type.

Anyway easy one to start the...

Even though i got idea about the function from BOL, I don't want to sit and calculate what will be the last day of 2016 or last day of february...

I don't whether i will use it in the mere future. Eventhough if i use i have to go through the explaination once again on that time.

+1

I got it correct, B'coz I have already faced this issue(all expressions should be implicitly convertable to higher priority datatype) many times and gone for dynamic sql for sorting the...

If we run the profiler before clicking Display Estimated Execution Plan, we can see SHOWPLAN_XML option is set to ON.

I think due to enabling this set option we are...

:blink:

Hugo Kornelis (1/17/2013)

It will fails based on syntax. The outer WHERE clause references b.Col3, but the subquery aliased as b only exposes the columns b.Col1 and b.Col2, so you'll get...

Hugo Kornelis (1/17/2013)

For instance, you can not do without CROSS APPLY in the following fragment:

FROM Table1 AS a

CROSS APPLY (SELECT b.Col1, SUM(b.Col2) FROM Table2 AS b WHERE b.Col3 >= a.Col3...

Thanks for such a detailed explaination Hugo.

I think the below code

FROM Table1 AS a CROSS APPLY (SELECT Col1, Col2 FROM Table2 AS b WHERE b.Col3 = a.Col3)...