SQL Joins or Multiple SELECTS in Procedures

[stoogots2]

I have to either Join 4 tables, or retrieve one column from 3 tables, and one record from another.

I can use a stored procedure to do the JOINs (doing that now), but it seems like overkill if I need one or two columns from each of the other tables.

Alternatively, I could use OUTPUT parameters and do separate SELECT statements for each Table.

Just looking for advice on making this process more performant.

Regards

[ck9663]

If you need to have some dynamic filtering, meaning a WHERE ColumnName = @VariableName, a table-function might the one you need. If it's a pretty much fixed SELECT, use views.

--- CK

[stoogots2]

CK,

Thanks for the help. One more question for you, if you have a moment. Would it be more performant to call a stored procedure 12 - 24 times or send 12-24 lines of INSERTs at the Command Text from my ASP.NET application?

[ck9663]

Depending on what you're stored proc would be doing.

What are you trying to do?

-- CK