I've piled on more BS and it works ok.
I do however have one question. I often find the BOL difficult to understand
and my experience is "topic" blah is the result of "word1" and sometimes" referred to
this or that ... i attempt to look up one thing and i find out i need to know at least 15
other terms and how they are used. I realize this is probably easy for people coming
from some type of background but im one of those slow people.
I guess i need a primer ... I also get impatient ... instead of telling me to RTFM .. is
there a resource or a website where it starts off with one simple query and then slowly builds and builds and compare differences?
BTW bob .. i got this far, YES ive put in over 40 hours ripping stuff out of the SQL Server Black Book and other posts in here
(not much transact SQL in it)
declare @dToday datetime
set @dToday = getdate()
JOIN ln_detail ON (transaction_header.tran_id=ln_detail.tran_id)
where transaction_header.tran_cd=121 AND
rtl_prc < 5000.00 AND
order by rtl_prc desc,TRANSACTION_HEADER.STR_ID