![[1]](https://svalko.org/data/2008_12_05_23_06_344103_1.gif){kind=link}
2011-08-19 15:17:37 #
Nerozumím vaší kurva Google Translator. Myslím si, že by rádi viděli více na Tatry. Pokusím se, stačí se jen trpělivost!!!
2011-08-19 15:11:44 #
ALTER Procedure KGR.KGRExportInfo_get
@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
@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
2011-08-19 15:24:14 #
Мужики говорят "Это так, потому что <вывод_из_известных_утверждений_по_правилам_вывода>
2011-08-19 15:26:29 #
2011-08-19 15:39:40 #
Just as nine women can't produce a baby in one month, unless you've put down on parallelization, the single delivery performance is limited by that sloth.
2011-08-19 15:52:18 #
Hello,
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
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
[0][1][2][3][4][5][6][7][8][9][10][11]