This is my current stored proc. The co_name and ru_name are the associated records and op_id is the id of the main record I spoke of in my first post..hope this helps.Thanks
<code>
CREATE PROCEDURE dbo.usp_OpinionSearch
@caseNumber VARCHAR(10)=NULL,
@judge INT=NULL,
@debtor_defendant...
I have a SQL question along the lines of the one posted earlier, is there a way to return data from two or more cells in a table to one value. Such as I have one record that has multiple records associated with it and I would like to return 1 line with:
Would like to return...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.