Google is your friend: EDI ISA

http://msdn.microsoft.com/en-us/library/bb259967(v=bts.20).aspx

Jesus, i need my coffee 😉 (Failed)

ronmoses (3/1/2013)

---

Where I got tripped up was here, and I guess I'm still not sure I understand...

create proc sp1

as

select * from temp1

exec sp2

Without a BEGIN and END defining the body...

Hugo Kornelis (1/28/2013)

---

Tough I applaud the effort to create questions on new SQL2012 functionality, I really see nothing positive about this question.

...

This question would have been so much better if...

Koen Verbeeck (1/23/2013)

---

I'd like to see the performance of the XML solution.

Also, I would think the structure of your website is known, so a relational model is preferred.

Curious to see...

I'm also wrong, but i learned something. Could someone please explain, why is the identity resetted after a truncate? For me is a possible source of inconsitency.

I wasn't certain about GROUPING_ID, but BOL cleared it up. 🙂

And what shall we learn from that?

+1

Something new to learn. But i think it comes very rare to a situation where a coelesce has only untyped null parameters.

An easy basic question! Thanks!

Select (cast(100 as real) * 1.05)*1000000000.0000000000000,(cast(100 as real)*1.049999237060547)*1000000000.0000000,cast(cast(100 as real) * 1.05 as int);

--result: 1,05E+11 , 1,049999E+11, 104

Sorry, but maybe i'm too dumb to understand the logic how SQL Server...

My problem is, that the first expression evaluates to 105, and if i cast the 105 to int it should remain 105 and not less.

Lets play a bit:

Select cast(100 as real) * 1.05,cast(cast(100 as real) * 1.05 as int);

-- Result is 105, 104

The result is very strange for me. Does SQL Server the calculation...

Easy points in a row, fine. 🙂