Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL SERVER 2005

Author  Topic 

praveendaya
Starting Member

13 Posts

Posted - 2006-06-14 : 15:22:48
Helo everybody,

I am praveen, master student working parttime in a company. i m new to this forum and hope u all give me a warm welcome......

At work i came across a tricky thing which i m not able to resolve may be because i m new to sql server 2005.

the thing is this.... I was trying to do a merge join transformation for two tables on one join key condition. I got like 2 rows in my destination. But if i do the same join condition in the sql server management studio i m gettin more than 2 rows in the resultset and i m really struck with this.

thankx,
Praveen kumar Dayanithi

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-15 : 03:19:07
Duplicate post
http://sqlteam.com/forums/topic.asp?TOPIC_ID=67808

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

sqldev80
Yak Posting Veteran

68 Posts

Posted - 2006-06-15 : 12:31:12
s.profession_id = cc.item_id?????????
Go to Top of Page
   

- Advertisement -