could i join function(return table) with a table

alyeng2000 · August 23rd, 2004, 07:44 AM

hi all
could i join function which return a table variable with a table like

Ahmed Ali
Software Developer

happygv · August 23rd, 2004, 09:18 AM

That looks too short to be understood. Can you explain that a bit in detail?

_________________________
- Vijay G
Strive for Perfection

alyeng2000 · September 15th, 2004, 08:45 AM

sorry message was not complete

like :
select * from table1 join dbo.funcTable1(@var)

Ahmed Ali
Software Developer

happygv · September 16th, 2004, 12:08 AM

Then you should go for constructing a dynamic SQL statement and use Exec() to execute that.

_________________________
- Vijay G
Strive for Perfection

alyeng2000 · September 16th, 2004, 06:42 AM

using exec i think it kills the procedure performance
exec finally takes a string and execute it

Ahmed Ali
Software Developer

happygv · September 16th, 2004, 10:05 PM

There might be a little performance hit, but IMO it shouldn't be that worse to kill the performance. I don't see it possible otherwise.

Is that such a huge/heavyload procedure? I thought that would be for just that select statement.

Cheers!

_________________________
- Vijay G
Strive for Perfection

Lalit_Pratihari · September 30th, 2004, 07:23 AM

Hi,

Yes you can join a table with a function that returns a table.

The only think you will have to take care of is to give a proper alias to the function while joining.

Thanks,

Lalit
Life Means More...;)