https://stackoverflow.com/questions/8435963/how-to-find-a-string-inside-a-entire-database

You're looking for strings in any column in any table? Sounds like the design of your database is seriously dodgy.

Thanks for the data sample... however, that's not super helpful. (Imagine copying and pasting that into SSMS and trying to run it.)  Here's how to do it:

[code...

You really need to open up SSMS and try learning something.

How about the painfully obvious:

SELECT *
FROM #Dummy
WHERE RandomString LIKE '%Mr. %'
OR RandomString LIKE...

Go crazy. Post your code in here...

PROCEDURE [dbo].[USP_AUTO_MOVE_TBMESSAGEREDUCE_DONE_AND_REJECT_TO_SENT]
    @TopRecord INT = 50000
    , @ManagementID TINYINT
    , @ResText VARCHAR(MAX) OUTPUT
AS
DECLARE
    @NEWLINE CHAR(1)
    ,@SubLoop_Rows...

Why are the month numbers in quotes? They're numbers, not text.

You would need to update those, removing the proper number of characters (Use LEFT() and LEN() in an update query... Since you only have a few cases, you could write...

Lowell posted some code that output a dataset as an HTML table not too long ago. Look around for it.

Go to Dice or any tech-oriented job site and look for jobs... and see what you find.

Oh, cool!  I knew there had to be a less messy way of doing it! Thanks!

Looks like you missed the CREATE TABLE part of this script...

Any chance you could post some CREATE TABLE and INSERT scripts so we can all play with the same data?

Please explain what records you want from Table B. An outer join returns nulls from Table B if there are no records that match those in A.
Compare
SELECT a.Field1,...

Only way I can think of getting this to work would be to add a running total in your query.... if that's not an option, then this could get ugly.

What are you going to use this for? I'm asking because in SSRS, this is really simple. You would add a tablix to your report surface, and just group by...