Thanks Sir !!! I could display "No Records Found"

Thanks for the great example. What if I wanted to display the SSN's with the Table Names ?

I'm sorry that was a mistake. I was just focused on showing the multiple rows. But yes there will only be one ssn per result set. Again I greatly apologize.

Thanks So Much For Your Help. I was wondering what will this stored procedure return if I the SSN doesn't exist in any table. Also I was wondering what if...

Thanks for your Help... Greatly Appreciated !!!!!

Please see attached doc for how I want the returned results. Thanks !!!!

See the attached file please. Thanks for your Help !!!!

Thats a good point I don't know how to include the table name in the result set. This is not easy for someone who  doesn't write select statements all the...

Thanks for your help and the critical thinking skills lesson, I greatly appreciate that. What I would like for the stored proc to return is all the rows (With the...

I apologize, but I have experimented with so many different queries or ways to solve this problem and I was unsuccessful. Most of my experience is in .Net Development and...

• This reply was modified 4 years, 8 months ago by  Data Rat .
• This reply was modified 4 years, 8 months ago by  Data Rat .

SSN is the only parameter. I would think that they all need to be joined so that I can get the SSN if it exits in the table(s). If you...

• This reply was modified 4 years, 8 months ago by  Data Rat .

This is an in-house utility application that we are using.

I apologize for mis wording my original post, but the query doesnt return a null value in the ssn column, it only returns the column name with nothing.

I have heard of those functions before but if you could steer me in the right direction on how to apply them to my issue. Thanks !!!

I still cant make heads or tails out of it. Although you are right that it can be in a neat format.  why did they do a left join then...

• This reply was modified 5 years, 2 months ago by  Data Rat .