![]() |
#12 |
Участник
|
Оставил два no exists join, на сервер уходит вот такой запрос:
X++: declare @p1 int set @p1=1073742866 declare @p2 int set @p2=180158983 declare @p5 int set @p5=16 declare @p6 int set @p6=1 declare @p7 int set @p7=-1 exec sp_cursorprepexec @p1 output,@p2 output,N'@P1 nvarchar(8),@P2 int,@P3 nvarchar(2002),@P4 nvarchar(8),@P5 nvarchar(8)',N'SELECT A.REQUESTID,A.CURRENCYCODE,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.DIMENSION5_,A.DIMENSION6_,A.DIMENSION7_,A.CONFIRM_LABEL1,A.CONFIRM_COSTCONTROL,A.CONFIRM_FINAL,A.DATECONFIRM_LABEL1,A.DATECONFIRM_COSTCONTROL,A.DATECONFIRM_FINAL,A.USERCONFIRMLABEL1,A.USERCONFIRM_COSTCONTROL,A.USERCONFIRM_FINAL,A.AMMOUNT,A.USER_REGISTR,A.DATE_REGISTR,A.FIELD1,A.ID_COMPETENCE,A.REQUESTID_REZERV,A.ATF_TYPEREQUEST,A.AMMOUNT_BALANS,A.VENDACCOUNT,A.VENDRNN,A.VENDNAME,A.CONTRACTDATE,A.CONTRACTNUMBER,A.DATECONFIRM_TOPAY,A.USERCONFIRM_TOPAY,A.AMMOUNT_PAYMENT,A.CONFIRM_TOPAY,A.REQUESTURL,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID,A.REQUEST_TEXT FROM PURCHTABLE_REQUEST A WHERE ((A.DATAAREAID=@P1) AND ((A.CONFIRM_FINAL=@P2) AND NOT ((A.REQUESTURL=@P3)))) AND NOT EXISTS (SELECT ''x'' FROM PURCHTABLE B WHERE ((B.DATAAREAID=@P4) AND (A.REQUESTID=B.REQUESTID)) AND NOT EXISTS (SELECT ''x'' FROM PURCHLINE C WHERE ((C.DATAAREAID=@P5) AND (A.REQUESTID=C.REQUESTID)))) ORDER BY A.DATAAREAID DESC,A.DATECONFIRM_FINAL DESC OPTION(FAST 1)',@p5 output,@p6 output,@p7 output,N'dat',1,N'',N'dat',N'dat' select @p1, @p2, @p5, @p6, @p7 Не пойму в чем проблема.
__________________
Лучше сделать и жалеть, чем жалеть что не сделал |
|
Теги |
exists, query |
|
|