with activeOrders as ( SELECT o.ordernum, o.orderid, o.orderdate, o.FSPro_UserID, o.RequesterFName, o.RequesterLName, o.RequesterFName + ' ' + o.RequesterLName as RequesterName, o.shp_Company, o.shp_firstName + ' ' + o.shp_lastName as shiptoName ,o.Email, o.proxyOrderPlacedByUsrId, o.dtneeded, o.status, o.shp_Date, o.rejectReason, o.smpl_orderType, o.approverUserId, t.orderTypeCode, t.orderTypeDesc, t.orderTypeSysType, e.eventName, b.broker_name, floor( 10191817 * sqrt( orderid * log10( orderid ))) as tk FROM tbl_POS_Orders o with (nolock) INNER JOIN tbl_POS_OrderTypes t with (noLock) ON t.orderTypeId = o.smpl_orderTypeId LEFT OUTER JOIN tbl_EVT_Events e with (nolock) ON o.smpl_eventId = e.eventId left outer join tblBrokers b with (nolock) on b.broker_id = o.requesterOwnerId and 'BRO' = o.requesterOwnerType WHERE o.OwnerID = AND o.FSL_TableCode = AND o.status in ('DR','PA') ) #forJSON( 'activeOrders', attributes.dataStore, 'orderdate' )#