Q&A about the site for developers and researchers interested in open data
declare @S varchar(200), @t varchar(100), @f varchar(100) set @S = 'tblfcdata.FCAttorneyFirm,tblPurchaseRev.SellerLoanID' while len(@S) > 0 begin set @t = left(@S, charindex(',', @S+',')-1) print 'table: ' + left(@t, charindex('.', @t+'.')-1) + ' field: ' + right(@t, charindex('.', @t+'.')+1) set @S = stuff(@S, 1, charindex(',', @S+','), '') end