Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple search procedure

Status
Not open for further replies.
rajani101

rajani101

IS-IT--Management
Jun 4, 2001
1
US
I'm trying to write a stored procedure that pulls multiple records from 4 different tables. At first I used multiple inner joins, but that returned many unnecessary results and taking too long. Any suggestions? Thanks.
 
Sort by date Sort by votes

Please post the queries, table structures, relationships... We can't guess what to do. Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Brianfree
  • Locked
  • Question
Simple SQL Pivot
Replies
9
Views
598
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to display part number based on search string by chemical id ?
Replies
3
Views
376
gmmastros
gmmastros
RazorEddie
  • Locked
  • Question
Simple query gone wrong
Replies
10
Views
618
RazorEddie
RazorEddie
Cpreston
  • Locked
  • Question
Field change as caused issues to store procedure
Replies
19
Views
850
Andrzejek
Andrzejek
bmacbmac
  • Locked
  • Question
Help searching within this Json file
Replies
0
Views
314
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top