tags:

views:

97

answers:

3
Q: 

How to use Stored Procedure in Inner Joins?

How to use stored procedure in inner joins?

+1  A: 

you can't. what you can do is rewrite your scprocs into table valued user definde functions and then join to them.

you'll have to expand a bit on your question though.

Mladen Prajdic  2009-07-02 09:56:01
+1 - You should check out table valued functions and look at converting your sprocs into those if you want to join directly to the results.
ConcernedOfTunbridgeWells  2009-07-02 10:38:33
A: 

Look at combining INSERT and EXEC.

Update- here's an example- scroll down to INSERT and EXEC. You can then do the join on the temporary table.

However I recommend you do this via other mechanisms- see here to find out why.

RichardOD  2009-07-02 09:56:53
Thanx for thisMy Prob may be solved
Shubham Jain  2009-07-03 05:38:43
A: 

hii shubham, what are u doing.

Shubh  2010-05-11 06:38:36
i m fine wt abt u whr r u
Shubham Jain  2010-05-17 07:15:01
Shubh  2010-05-17 10:13:40

related questions

What do you use to write and edit stored procedures in Oracle?
How do I determine using TSQL what roles are granted execute permissions on a specific stored procedure?
How do I run Oracle plsql procedure from Lisp?
Output parameters not readable when used with a DataReader
How do you create SQL Server 2005 stored procedure templates in SQL Server 2005 Management Studio?
How do I call MySQL stored procedures from Perl?
Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS's?
Default Integer type in ASP.Net from a Stored Procedure
Should data security be performed on the database side?
How do I conditionally create a stored procedure in SQL Server?
Why is parameterized SQL generated by NHibernate just as fast as a stored procedure?
PHP + MySql + Stored Procedures, how do I get access an "out" value?
SQL file encoding in Visual Studio
T-SQL stored procedure that accepts multiple Id values
SQL Server Fast Forward Cursors
Formatting Stored Procedures
Asynchronous Stored Procedure Calls
Stored Procedure and Timeout
Which is better: Ad hoc queries, or stored procedures?
Query a union table with fields as columns.
Standalone tools for debugging stored procedures
What are the pros and cons to keeping SQL in Stored Procs versus Code
LINQ-to-SQL vs stored procedures?
Insert Update stored proc on SQL Server
Is there any list datatype in MySQL stored procedures, or a way to emulate them?