We help IT Professionals succeed at work.
Get Started
Displaying only first row for the 2nd Stored procedure
I have two stored procedures in one report. My main stored procedure is procSSFTP_RPT_WorkAndRestD
I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.
I have multiple rows for the comments against the single seafarer name.
Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".
Attached is the report for your reference
https://drive.google.com/open?id=1nb_DOgTVjFD1d-YdRR8jUX2omN5yO8KV
I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.
I have multiple rows for the comments against the single seafarer name.
Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".
Attached is the report for your reference
https://drive.google.com/open?id=1nb_DOgTVjFD1d-YdRR8jUX2omN5yO8KV
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE