I just built a quick little SQL reformater that makes your sql a bit more readable.

It takes this:
select pmtlndet.pmtlndet_amt, glcdty.glcdty_desc from pmtlndet
join pmtln on pmtln.pmtln_ID = pmtLndet.pmtln_ID
join pmt on pmt.pmt_id = pmtln.pmt_id
join GlCdTy on pmtlndet.GlCdty_id = GlCdTy.GlCdty_id
where pmt.hostappl_inv_num = @HostApplInvNum and pmtln.pmtStatSubTy_id=@RCRYty_ID

and turns it into this:

select	pmtlndet.pmtlndet_amt,
	glcdty.glcdty_desc
from	pmtlndet
join	pmtln
on	pmtln.pmtln_ID=pmtLndet.pmtln_ID
join	pmt
on	pmt.pmt_id=pmtln.pmt_id
join	GlCdTy
on	pmtlndet.GlCdty_id=GlCdTy.GlCdty_id
where	pmt.hostappl_inv_num=@HostApplInvNum
and	pmtln.pmtStatSubTy_id=@RCRYty_ID

This tool was just a quick one off and does not reformat subqueries very well as well as function calls in the select statement (i.e. isnull(col, 'replacement')) but so far has saved me a ton of time.


NOTE: When you click the parse button it automatically copies the reformated SQL to the clipboard.

Download