join with Table valued function

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 2005 Forums

Transact-SQL (2005)

join with Table valued function

Author

Topic

subashmvs
Starting Member

4 Posts

Posted - 2008-03-10 : 06:18:32

Hi,

I want to join a table valued function but function parameter should left joined table's primary key .... this is posible in oracle by pipeline method ..
eg..
SELECT A.Col1,A.Col2,B.Col1,B.Col2
FROM Tab As A LEFT OUTER JOIN TblFunction(A.Pkey) B
ON A.Col1 = B.Col1

any body help me ... thanx in advance..

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-03-10 : 06:34:01

Make use of new OUTER APPLY operator in SQL Server 2005.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

subashmvs
Starting Member

4 Posts

Posted - 2008-03-10 : 06:40:11

thanx .....

I solved my problem .......

mams
Starting Member

1 Post

Posted - 2008-03-26 : 12:25:11

Can you please let me know how you solved the problem with table valued functions in oracle, I have the same problem.

I did solve the problem using PIPELINED functionality in oracle 9i.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources