On Oct 6, 7:09*pm, "Tools4SQL.net" <tools4... (AT) gmail (DOT) com> wrote:
i used t4s stored procedure generator. i generated around 6 SPs for
around 30 tables. all insert, update, delete sps are fine. but i want
to generate select sp with joins. please tell me how to do that ?

it's easy to generate joins for select sp. For example: StateID is a
foreign key column in City table. We want to generate the query given
below:

SELECT CityID,
CityName,
StateName
FROM City
INNER JOIN State
ON City.StateID = State.StateID

To generate this query, simply follow these steps.

(1) Open your project.

(2) Check the checkbox "Generate select sp with join like left outer
join, inner join" in select sp tab of General Configurations.

(3) Go to FK Display Member tab in project configurations. Here you
need to select those columns which you want to select when perticular
table is JOINed.
In our example, you need to select StateName column of state table. So
StateName is FK Display Member for city table. Or click the button
"select probable". by clicking this button, software will auto select
probable FK Display Member columns.

(4) Go to FK Columns tab in Project configuration. Here you need to
select those foreign key columns on which you want to perform join.
In our example, you need to select StateID column in City table as we
want to join both tables using StateID column. OR click the button
"Select By FK Display Member". this button will auto select those
foreign key columns whose FK Display Members are selected in FK
Display Member tab.

(5) Generate sp for City table. the query given above will be
generated.