Converting to view computed column method.
T-SQL statment like this way.
return strFmt(@'select top 1 WHT.ACCOUNTNUM from WHSSHIPMENTTABLE as WHT
where WHT.WaveId = %1 order by WHT.RECID asc',waveId);
Table1 ppt; select firstonly ppt order ItemCode, ItemRelation, AccountCode, AccountRelation where (ppt.ItemCode == TableGroupAll::T...
No comments:
Post a Comment