Is this an error in the documentation???

Question

Or am I not understanding something?

Please refer to http://msdn.microsoft.com/en-us/library/bb522522(v=sql.105).aspx

In the Table

It seems that the column headers for EXAMPLE INPUT STREAM RESULTS are reversed - and should be (LEFT TO RIGHT): TrgEmpID  TrgName SrcEmpID  SrcName

And also why are these refered to as EXAMPLE INPUT STREAM RESULTS shouldn't this be EXAMPLE OUTPUT STREAM RESULTS??? After all it is the result of the matching process isn't it?

Answer 1

check on this link, its pretty straight to understand.

http://en.wikipedia.org/wiki/Join_%28SQL%29

Answer 2

Hello,

should the sequence of the columns be matter to worry? The column sequence can be defined in the SELECT Part, so you cant really say the example show is correct or not unless the entire query is shown.

And yes they could have said that as Output stream results or simply Example Results

Regards
satheesh

Answer 3

I agree with you that this example can be made much better. it is just confusing people, at least when I looked at I have same feeling as you do.

From the context, I think you indeed are RIGHT from my point of view. 

Answer 4

And yes they could have said that as Output stream results or simply Example Results

Its Input stream only, input to the merge Source and target 

the table also shows the resulting input stream for the example source and target tables when the search criteria for matching the source and target data is Source.EmployeeID = Target.EmployeeID.

Regads
satheesh

Answer 5

Satheesh - I am saying only the heading should change but the data below them should remain where it is - in otherwords the column headings are flipped the yellow headings below should go with the yellow data:

Answer 6

Oh, I didn't notice this my bad :-(

Yes, Now it look confusing to me...

Regards
Satheesh

Answer 7

Hi dpress,

Thank you for your post.

I agree with you.  The column headers should be TrgEmpID  TrgName SrcEmpID  SrcName. It is an document  error.

For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 8

Hi dpress,

I’m a Technical Writer on the SQL Server team, and I’ll take a look at your request. Thank you for question.

Answer 9

dpress, I've fixed the column headings in http://msdn.microsoft.com/en-us/library/bb522522(SQL.105).aspx. The updates will be published in late July. Thank you for pointing out that error!

--Jim