| Тарас, , Свалкоигра! Откоментируй тем, что есть в буфере обмена (для тех, у кого звука нет: CTRL+V) Свинодемон, , [0][1][2][3][4][5][6][7][8][9][10][11] birdy, , Морекакоп, , Постриг Бородку, , Google - MIcrosoft Apple - HTC Пахомов, , Пидроид, , Редькотёр, , СыржантПеппер, , @idUser int=null, @XMLsearch xml=null, @XMLoutput xml=null output, @bOut bit=1 as set nocount on declare @iDocThis int declare @idDeal int exec xml_preparedocument @iDocThis output, @XMLsearch select @idDeal=case when Name='idDeal' then convert(int,Val) else @idDeal end from openxml(@iDocThis,'/root/object/row',2) with tmXMLsearch exec xml_removedocument @iDocThis select @XMLoutput=( select (select objectname='KGRExportInfo', (select top 1 idDeal=@idDeal, idEventLast=E.EventID, dExportDateLast=E.dExportDate, sProcessingStateLast=E.ProcessingState, sProcessingInfoLast=E.ProcessingInfo, idEventExported=EE.EventID, dExportDateExported=EE.dExportDate, sProcessingStateExported=EE.ProcessingState, sProcessingInfoExported=EE.ProcessingInfo, idEventSuccess=EES.EventID, dExportDateSuccess=EES.dExportDate, sProcessingStateSuccess=EES.ProcessingState, sProcessingInfoSuccess=EES.ProcessingInfo, sKGRLimitStatus=R.sLimitStatus, dKGRDate=R.dEditDate, iKGRVersion=R.iVersion, bDraftSent=case when TE.idDeal is null then 0 else 1 end from KGR.ftEvent E left outer join (select top 1 * from KGR.ftEvent E1 where E1.ObjectID=@idDeal and E1.bExported=1 and E1.ProcessingState is not null order by E1.dExportDate desc) EE on E.ObjectID=EE.ObjectID left outer join (select top 1 * from KGR.ftEvent E1 where E1.ObjectID=@idDeal and E1.bExported=1 and E1.ProcessingState = 'O' order by E1.dExportDate desc) EES on E.ObjectID=EES.ObjectID left outer join (select top 1 * from KGR.ftKGRDealStatus DS where DS.idDeal=@idDeal order by DS.iVersion desc) R on E.ObjectID=R.idDeal left outer join KGR.bfTemporaryEvents TE on E.ObjectID=TE.idDeal where E.ObjectID=@idDeal and E.bExported=1 order by E.dExportDate desc for xml path('row'),type, ELEMENTS) for xml path('object'),type, ELEMENTS) for xml path('root')) if @bOut=1 select @XMLoutput Kid_mode, , klerk, , коника, , Пакоп, , Linksys wireless broadba, , Прыщавое междусисие, , аввап, , аввап, , Linksys wireless broadba, , Ч. Бурек, , Корабел, , Кадзе, , СыржантПеппер, , транзакт мативо эскуэль Мокабевич, , %usernаmе%, , Thanks for placing an order with us. We aren¹t able to take card payments at the moment, but you can still pay for your order by bank transfer (what we call payment by invoice). Company name: CLOVERFIELDS TRADING UNIPESSOAL LDA VAT Number: PT509646450 Bank Name: Millennium bcp Banco Comercial Portugues Bank Address: Avenida da República, 8 A/H1050 191 Lisboa Portugal Account (NIB) 0033 - 0000 - 45404367415 05 IBAN: PT50 - 0033 - 0000 - 45404367415 05 Swift/BIC: BCOMPTPL If your deposit has cleared in the account by 3pm today it will be sent out today. Please include your 18 digit order number as a reference so we can match your payment to your order. Please note that same day dispatch is not always possible working with bank transfers. If you are paying for your order from a bank account that differs to the name your Herbal Highs account is registered under, please let us know via email so that we will be able to identify your payment as quickly as possible. We apologize for any inconvenience caused by this temporary solution and are working towards taking card payments again. Kind Regards, Herbal Highs Team Бакарекот, , It is very important. Зунян, , Ронян, , Свинодемон, , [0][1][2][3][4][5][6][7][8][9][10][11] Отметиться |