This is the best I could do ... I used online http://www.dpriver.com/pp/sqlformat.htm and it gave the following code...
But.. the code works...

SELECTCLAIM.dclaim.formnbr, claim.dclaim.admitdate, claim.dclaim.membernbr, claim.dclaim.totalnetamt, dclaim_1.totalnetamt...

Agree it works for a small db. 
Any way that you could show me how to tweek it so that I only get one column of output and the tables...

Next.. challenge.. Canyou help me tweek this ?

I just need the SELECT statement to list only the TABLE name in the same order as it does now.  I...

;
;
with  cteTbHierarchy
    as ( /* Select all table without (selfreferencing) FK */
     select distinct
        1 as LevelID
        , OBJECT_SCHEMA_NAME(Parent.object_id) as TableOwner
        , Parent.name...

Thanks, out of curiosity is there a way to get the start position of the nth occurrence ( if any )   without going into a WHILE LOOP. 
Never mind...

Would like the position of each occurrence in a comma separated string.

Bekker: Thanks That works!

IF object_id('tempdb..#a') IS NOT NULL DROP TABLE #a;

create table #a
(
memberid varchar(40),
claimnum varchar(10),
claimB varchar(10),
histclaim varchar(10)

Thanks ... But this worked... I am all set !

=IIF(((Fields!HIST_SRVC_DT.Value)="0001-01-01"), "", Fields!HIST_SRVC_DT.Value)

OK it works but does not resolve my issue....
MY SSRS report pulls data from IBM DB2. So the null dates are coming as 0001-01-01.

How ever your IIF statement considers them...

Incorrect # of parenthesis  count the number of "(" and ")"

Ahhh...
That was a simple fix, why didn't I think about that.....
OK, DONE!

Select
ROW_NUMBER() OVER
(
PARTITION BY NULL
ORDER BY NameTitle,...