ÿþU S E [ W i n c c S Q L ]
|
G O
|
/ * * * * * * O b j e c t : U s e r [ S I M A T I C H M I U s e r ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 4 : 5 9 * * * * * * /
|
C R E A T E U S E R [ S I M A T I C H M I U s e r ] F O R L O G I N [ D E S K T O P - O A B 5 E A B \ S I M A T I C H M I ]
|
G O
|
/ * * * * * * O b j e c t : U s e r [ S I M A T I C H M I V I E W E R U s e r ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 4 : 5 9 * * * * * * /
|
C R E A T E U S E R [ S I M A T I C H M I V I E W E R U s e r ] F O R L O G I N [ D E S K T O P - O A B 5 E A B \ S I M A T I C H M I V I E W E R ]
|
G O
|
/ * * * * * * O b j e c t : D a t a b a s e R o l e [ S I M A T I C H M I r o l e ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 4 : 5 9 * * * * * * /
|
C R E A T E R O L E [ S I M A T I C H M I r o l e ]
|
G O
|
/ * * * * * * O b j e c t : D a t a b a s e R o l e [ S I M A T I C H M I V I E W E R r o l e ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 4 : 5 9 * * * * * * /
|
C R E A T E R O L E [ S I M A T I C H M I V I E W E R r o l e ]
|
G O
|
A L T E R R O L E [ S I M A T I C H M I r o l e ] A D D M E M B E R [ S I M A T I C H M I U s e r ]
|
G O
|
A L T E R R O L E [ d b _ d d l a d m i n ] A D D M E M B E R [ S I M A T I C H M I U s e r ]
|
G O
|
A L T E R R O L E [ d b _ d a t a r e a d e r ] A D D M E M B E R [ S I M A T I C H M I U s e r ]
|
G O
|
A L T E R R O L E [ d b _ d a t a w r i t e r ] A D D M E M B E R [ S I M A T I C H M I U s e r ]
|
G O
|
A L T E R R O L E [ S I M A T I C H M I V I E W E R r o l e ] A D D M E M B E R [ S I M A T I C H M I V I E W E R U s e r ]
|
G O
|
A L T E R R O L E [ d b _ d a t a r e a d e r ] A D D M E M B E R [ S I M A T I C H M I V I E W E R U s e r ]
|
G O
|
A L T E R R O L E [ d b _ d d l a d m i n ] A D D M E M B E R [ S I M A T I C H M I r o l e ]
|
G O
|
A L T E R R O L E [ d b _ d a t a r e a d e r ] A D D M E M B E R [ S I M A T I C H M I r o l e ]
|
G O
|
A L T E R R O L E [ d b _ d a t a w r i t e r ] A D D M E M B E R [ S I M A T I C H M I r o l e ]
|
G O
|
A L T E R R O L E [ d b _ d a t a r e a d e r ] A D D M E M B E R [ S I M A T I C H M I V I E W E R r o l e ]
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ G l a s s I D T e m p ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ G l a s s I D T e m p ] (
|
[ G l a s s I D T e m p ] [ n v a r c h a r ] ( m a x ) N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ g l a s s I n ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ g l a s s I n ] (
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ WY
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ±{
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ¢US»st;`pe] [ f l o a t ] N U L L ,
|
[ i t e m _ q u a n t i t y ] [ i n t ] N U L L ,
|
[ R a c k T y p e I D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ R a c k I D ] [ f l o a t ] N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( m a x ) N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ g l a s s O u t ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ g l a s s O u t ] (
|
[ ^÷S] [ f l o a t ] N U L L ,
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ R a c k T y p e I D ] [ f l o a t ] N U L L ,
|
[ r a c k I D ] [ f l o a t ] N U L L ,
|
[ e¶g
|
NvS¦^] [ i n t ] N U L L ,
|
[ e¶g
|
Nv^÷S] [ i n t ] N U L L ,
|
[ ±{
Q»st^÷S] [ i n t ] N U L L ,
|
[ ö«WS¦^] [ f l o a t ] N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ S±{
Q^÷S] [ i n t ] N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ g l a s s O u t 2 ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ g l a s s O u t 2 ] (
|
[ ^÷S] [ f l o a t ] N U L L ,
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ R a c k T y p e I D ] [ f l o a t ] N U L L ,
|
[ r a c k I D ] [ f l o a t ] N U L L ,
|
[ e¶g
|
NvS¦^] [ i n t ] N U L L ,
|
[ e¶g
|
Nv^÷S] [ i n t ] N U L L ,
|
[ ±{
Q»st^÷S] [ i n t ] N U L L ,
|
[ ö«WS¦^] [ f l o a t ] N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ S±{
Q^÷S] [ i n t ] N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ g l a s s O u t 3 ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ g l a s s O u t 3 ] (
|
[ ^÷S] [ f l o a t ] N U L L ,
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ R a c k T y p e I D ] [ f l o a t ] N U L L ,
|
[ r a c k I D ] [ f l o a t ] N U L L ,
|
[ e¶g
|
NvS¦^] [ i n t ] N U L L ,
|
[ e¶g
|
Nv^÷S] [ i n t ] N U L L ,
|
[ ±{
Q»st^÷S] [ i n t ] N U L L ,
|
[ ö«WS¦^] [ f l o a t ] N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ S±{
Q^÷S] [ i n t ] N U L L ,
|
[ úQGröeô] [ d a t e t i m e ] N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ m o d e S w i t c h ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ m o d e S w i t c h ] (
|
[ m o d e ] [ b i t ] N U L L
|
) O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ n e w t e s t t a b l e ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ n e w t e s t t a b l e ] (
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ WY
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ±{
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ i t e m _ q u a n t i t y ] [ i n t ] N U L L ,
|
[ R a c k T y p e I D ] [ f l o a t ] N U L L ,
|
[ R a c k I D ] [ f l o a t ] N U L L ,
|
[ ÛGrz^] [ f l o a t ] N U L L ,
|
[ ÛGr] [ f l o a t ] N U L L ,
|
[ úQGr] [ f l o a t ] N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ O r d e r $ ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ O r d e r $ ] (
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ WY
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ±{
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ¢US»st;`pe] [ f l o a t ] N U L L ,
|
[ i t e m _ q u a n t i t y ] [ i n t ] N U L L ,
|
[ R a c k T y p e I D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ R a c k I D ] [ f l o a t ] N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ l a s t _ u p d a t e _ t i m e ] [ d a t e t i m e ] N U L L ,
|
[ n u m b e r ] [ i n t ] N U L L ,
|
[ úQP[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ S±{
Q^÷S] [ f l o a t ] N U L L ,
|
[ ¢US÷S÷S] [ n v a r c h a r ] ( m a x ) N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ Q u e s t i o n s T B ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ Q u e s t i o n s T B ] (
|
[ c u s t o m e r _ o r d e r _ n u m b e r ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ l a s t _ u p d a t e _ d a t e ] [ d a t e t i m e ] N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ R a c k ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ R a c k ] (
|
[ ^÷S] [ i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
|
[ R A C K ] [ f l o a t ] N U L L ,
|
[ ½[¦^] [ f l o a t ] N U L L ,
|
[ ű{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st;`S¦^] [ f l o a t ] N U L L ,
|
[ {|W] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
C O N S T R A I N T [ P K _ R a c k ] P R I M A R Y K E Y C L U S T E R E D
|
(
|
[ ^÷S] A S C
|
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N ) O N [ P R I M A R Y ]
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ R e p o r t ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ R e p o r t ] (
|
[ I D ] [ b i g i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
|
[ m a r k D a t e ] [ d a t e ] N U L L ,
|
[ G l a s s I D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ T h e O n l y G l a s s I D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ O r d e r N u m ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ C u s t o m N u m ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
C O N S T R A I N T [ P K _ R e p o r t ] P R I M A R Y K E Y C L U S T E R E D
|
(
|
[ I D ] A S C
|
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N ) O N [ P R I M A R Y ]
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ s t o r a g e ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ s t o r a g e ] (
|
[ ^÷S] [ b i g i n t ] I D E N T I T Y ( 1 , 1 ) N O T N U L L ,
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ű{÷Sÿ¶g÷S ÿ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ »st¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »st½[¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ »stS¦^ÿm m ÿ] [ f l o a t ] N U L L ,
|
[ R a c k T y p e I D ] [ f l o a t ] N U L L ,
|
[ r a c k I D ] [ f l o a t ] N U L L ,
|
[ e¶g
|
NvS¦^] [ i n t ] N U L L ,
|
[ e¶g
|
Nv^÷S] [ i n t ] N U L L ,
|
[ ±{
Q»st^÷S] [ i n t ] N U L L ,
|
[ ö«WS¦^] [ f l o a t ] N U L L ,
|
[ i t e m _ q u a n t i t y ] [ i n t ] N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ úQP[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ S±{
Q^÷S] [ f l o a t ] N U L L ,
|
C O N S T R A I N T [ P K _ s t o r a g e ] P R I M A R Y K E Y C L U S T E R E D
|
(
|
[ ^÷S] A S C
|
) W I T H ( P A D _ I N D E X = O F F , S T A T I S T I C S _ N O R E C O M P U T E = O F F , I G N O R E _ D U P _ K E Y = O F F , A L L O W _ R O W _ L O C K S = O N , A L L O W _ P A G E _ L O C K S = O N ) O N [ P R I M A R Y ]
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ t _ r e p o r t _ p r o c e s s i n g _ o r d e r ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ t _ r e p o r t _ p r o c e s s i n g _ o r d e r ] (
|
[ i d ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ c u s t o m e r _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ s h i p p i n g _ d a t e ] [ d a t e t i m e ] N U L L ,
|
[ c u s t o m e r _ o r d e r _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ c u s t o m e r _ o r d e r _ n u m b e r _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ i t e m _ m e m o _ o n e ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ p r o c e s s i n g _ o r d e r _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ p r o c e s s i n g _ o r d e r _ i t e m _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ i t e m _ h e i g h t ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ i t e m _ w i d t h ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ t h i c k n e s s ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ i t e m _ m e m o _ o n e _ l a s t _ n o ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ l a s t _ u p d a t e _ t i m e ] [ d a t e t i m e ] N U L L ,
|
[ u s e d ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ u s e d _ t i m e ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ r e m a r k ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ c u s t o m e r _ p r o d u c t _ d e s c ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ s e r i a l _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ i t e m _ q u a n t i t y ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ t o t a l _ q u a n t i t y ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ c u s t o m e r _ p r o d u c t _ d e s c _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ s e r i a l _ n u m b e r _ n u m b e r ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ w o r k _ s h o p ] [ n v a r c h a r ] ( 2 5 5 ) N U L L
|
) O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ T e m p ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ T e m p ] (
|
[ ¢[7bãN÷S] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ ¤N'åe g] [ d a t e t i m e ] N U L L ,
|
[ ¢US÷S] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ ű{÷S_ ¶g÷S] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ ±{
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ WY÷S] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ WY
Q»st;`pe] [ f l o a t ] N U L L ,
|
[ »stI D ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ »st¦^_ m m ] [ f l o a t ] N U L L ,
|
[ »st½[¦^_ m m ] [ f l o a t ] N U L L ,
|
[ »stS¦^_ m m ] [ f l o a t ] N U L L ,
|
[ WY
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ±{
Q»st^÷S] [ f l o a t ] N U L L ,
|
[ ¢US»st;`pe] [ f l o a t ] N U L L ,
|
[ i t e m _ q u a n t i t y ] [ f l o a t ] N U L L ,
|
[ R a c k T y p e I D ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ P[±{÷S] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ R a c k I D ] [ f l o a t ] N U L L ,
|
[ ±{pe] [ i n t ] N U L L ,
|
[ »st/U NI D ] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ Sű{÷S] [ n v a r c h a r ] ( 2 5 5 ) N U L L ,
|
[ l a s t _ u p d a t e _ t i m e ] [ d a t e t i m e ] N U L L ,
|
[ n u m b e r ] [ i n t ] N U L L ,
|
[ úQP[±{÷S] [ n v a r c h a r ] ( m a x ) N U L L ,
|
[ S±{
Q^÷S] [ f l o a t ] N U L L ,
|
[ ¢US÷S÷S] [ n v a r c h a r ] ( m a x ) N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
/ * * * * * * O b j e c t : T a b l e [ d b o ] . [ w e i y i I D ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E T A B L E [ d b o ] . [ w e i y i I D ] (
|
[ »st/U NI D ] [ n v a r c h a r ] ( m a x ) N U L L
|
) O N [ P R I M A R Y ] T E X T I M A G E _ O N [ P R I M A R Y ]
|
|
G O
|
A L T E R T A B L E [ d b o ] . [ T e m p ] A D D C O N S T R A I N T [ D F _ T e m p _ n u m b e r ] D E F A U L T ( ( 0 ) ) F O R [ n u m b e r ]
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ i n s e r t _ c h a i ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
- - 4Nöeh ÒceQpenc
|
C R E A T E p r o c [ d b o ] . [ i n s e r t _ c h a i ]
|
@ d a y s i n t
|
a s
|
b e g i n
|
d e c l a r e @ ¢[7bãN÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ ¤N'åe g n v a r c h a r ( 5 0 )
|
d e c l a r e @ ¢US÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ ű{÷S_ ¶g÷S n v a r c h a r ( 5 0 )
|
- - d e c l a r e @ Sű{÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ »stI D n v a r c h a r ( 5 0 )
|
d e c l a r e @ »st¦^_ m m n v a r c h a r ( 5 0 )
|
d e c l a r e @ »st½[¦^_ m m n v a r c h a r ( 5 0 )
|
d e c l a r e @ »stS¦^_ m m n v a r c h a r ( 5 0 )
|
d e c l a r e @ ±{
Q»st^÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ ¢US»st;`pe n v a r c h a r ( 5 0 )
|
d e c l a r e @ i t e m _ q u a n t i t y n v a r c h a r ( 5 0 )
|
d e c l a r e @ ûm Råe g n v a r c h a r ( 5 0 )
|
d e c l a r e c u r s o r 1 c u r s o r f o r
|
s e l e c t c u s t o m e r _ n u m b e r , s h i p p i n g _ d a t e , c u s t o m e r _ o r d e r _ n u m b e r , c u s t o m e r _ p r o d u c t _ d e s c _ n u m b e r , p r o c e s s i n g _ o r d e r _ n u m b e r , i t e m _ h e i g h t , i t e m _ w i d t h , t h i c k n e s s , s e r i a l _ n u m b e r _ n u m b e r , t o t a l _ q u a n t i t y , i t e m _ q u a n t i t y , l a s t _ u p d a t e _ t i m e f r o m [ 1 9 2 . 1 6 8 . 3 . 1 6 ] . s h e b e i . d b o . t _ r e p o r t _ p r o c e s s i n g _ o r d e r
|
w h e r e w o r k _ s h o p = 2 0 0 0 a n d l a s t _ u p d a t e _ t i m e > g e t d a t e ( ) - @ d a y s - - a n d p r o c e s s i n g _ o r d e r _ n u m b e r n o t i n ( s e l e c t »stI D f r o m O r d e r $ g r o u p b y »stI D ) - - ÿb0R@b g¡l gûm Rv»stI D
|
o p e n c u r s o r 1
|
f e t c h n e x t f r o m c u r s o r 1 i n t o @ ¢[7bãN÷S, @ ¤N'åe g, @ ¢US÷S, @ ű{÷S_ ¶g÷S, @ »stI D , @ »st¦^_ m m , @ »st½[¦^_ m m , @ »stS¦^_ m m , @ ±{
Q»st^÷S, @ ¢US»st;`pe, @ i t e m _ q u a n t i t y , @ ûm Råe g
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
d e c l a r e @ p r i c e s i n t
|
d e c l a r e @ ò]0Rpe i n t
|
s e t @ ò]0Rpe= 0
|
s e t @ p r i c e s = @ i t e m _ q u a n t i t y - @ ò]0Rpe - - ;`pe- ò]Ï~ûm RvpeÏ
|
w h i l e @ p r i c e s > 0
|
b e g i n
|
d e c l a r e @ »st/U NI D n v a r c h a r ( 5 0 )
|
s e t @ ò]0Rpe= @ ò]0Rpe+ 1
|
s e t @ »st/U NI D = @ »stI D + ' - ' + C O N V E R T ( n v a r c h a r , @ ò]0Rpe)
|
- - s e t @ Sű{÷S= @ ű{÷S_ ¶g÷S
|
i n s e r t i n t o T e m p ( ¢[7bãN÷S, ¤N'åe g, ¢US÷S, ű{÷S_ ¶g÷S, »stI D , »st¦^_ m m , »st½[¦^_ m m , »stS¦^_ m m , ±{
Q»st^÷S, ¢US»st;`pe, i t e m _ q u a n t i t y , ±{pe, »st/U NI D , Sű{÷S, l a s t _ u p d a t e _ t i m e , S±{
Q^÷S, ¢US÷S÷S) - - ûm RW[µk ±{pe ؤ<P:N1
|
s e l e c t @ ¢[7bãN÷S, @ ¤N'åe g, @ ¢US÷S, @ ű{÷S_ ¶g÷S, @ »stI D , @ »st¦^_ m m , @ »st½[¦^_ m m , @ »stS¦^_ m m , @ ±{
Q»st^÷S, @ ¢US»st;`pe, @ i t e m _ q u a n t i t y , 0 , @ »st/U NI D , @ ű{÷S_ ¶g÷S, @ ûm Råe g, @ ±{
Q»st^÷S, L E F T ( @ »stI D , 1 3 )
|
s e t @ p r i c e s = @ p r i c e s - 1
|
e n d
|
f e t c h n e x t f r o m c u r s o r 1 i n t o @ ¢[7bãN÷S, @ ¤N'åe g, @ ¢US÷S, @ ű{÷S_ ¶g÷S, @ »stI D , @ »st¦^_ m m , @ »st½[¦^_ m m , @ »stS¦^_ m m , @ ±{
Q»st^÷S, @ ¢US»st;`pe, @ i t e m _ q u a n t i t y , @ ûm Råe g
|
e n d
|
c l o s e c u r s o r 1 - - sQí8nh
|
d e a l l o c a t e c u r s o r 1
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ C h i l d B o x ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ P r o _ C h i l d B o x ]
|
@ ű{÷S_ ¶g÷S n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
i f ( s e l e c t M A X ( C O N V E R T ( i n t , S±{
Q^÷S) ) f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S) > 0 - - g^÷Sv
|
b e g i n
|
e x e c P r o _ C h i l d B o x _ R u l e 1 @ ű{÷S_ ¶g÷S
|
e n d
|
e l s e
|
b e g i n
|
i f ( ( s e l e c t t o p ( 1 ) m o d e f r o m m o d e S w i t c h ) = ' f a l s e ' ) o r ( s e l e c t P A T I N D E X ( ' % J Y C - % ' , @ ű{÷S_ ¶g÷S) ) > 0 - - !j_1 b/fÖNìNvű{÷S
|
b e g i n
|
u p d a t e T e m p s e t P[±{÷S= @ ű{÷S_ ¶g÷S w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S
|
e n d
|
e l s e
|
b e g i n
|
e x e c P r o _ C h i l d B o x _ R u l e 2 @ ű{÷S_ ¶g÷S
|
e n d
|
e n d
|
e n d
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ C h i l d B o x _ R u l e 1 ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
- - P[±{ÄR1 5 0 N¶g
|
C R E A T E p r o c [ d b o ] . [ P r o _ C h i l d B o x _ R u l e 1 ]
|
@ ű{÷S_ ¶g÷S n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
d e c l a r e @ B o x _ c h i l d I D n v a r c h a r ( 5 0 ) - - °eP[±{÷S
|
d e c l a r e @ C o u n t i n t - - h:y,{àQ*N±{
|
s e t @ C o u n t = 1
|
w h i l e ( s e l e c t c o u n t ( * ) f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d P[±{÷S i s n u l l ) > 0
|
b e g i n
|
s e t @ B o x _ c h i l d I D = @ ű{÷S_ ¶g÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ C o u n t )
|
u p d a t e T e m p s e t P[±{÷S= @ B o x _ c h i l d I D w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d »st/U NI D i n ( s e l e c t t o p ( 5 0 ) »st/U NI D f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d P[±{÷S i s n u l l o r d e r b y ±{
Q»st^÷S, »st½[¦^_ m m d e s c , »stI D )
|
s e t @ C o u n t = @ C o u n t + 1
|
e n d
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ C h i l d B o x _ R u l e 2 ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ P r o _ C h i l d B o x _ R u l e 2 ]
|
@ ű{÷S_ ¶g÷S n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
d e c l a r e @ B o x _ c h i l d I D n v a r c h a r ( 5 0 ) - - °eP[±{÷S
|
d e c l a r e @ C o u n t i n t - - h:y,{àQ*N±{
|
d e c l a r e @ g'Y±{
QpeÏ i n t - - g'Y±{
QpeÏ
|
d e c l a r e @ ±{
Q g'YS¦^ i n t - - ±{
Q g'YS¦^
|
s e t @ ±{
Q g'YS¦^= ( s e l e c t M A X ( C O N V E R T ( i n t , »stS¦^_ m m ) ) f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S)
|
i f ( @ ±{
Q g'YS¦^= 1 0 )
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 4 5
|
e n d
|
e l s e i f ( @ ±{
Q g'YS¦^= 6 )
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 6 0
|
e n d
|
e l s e i f ( @ ±{
Q g'YS¦^= 5 )
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 7 0
|
e n d
|
e l s e
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 5 0
|
e n d
|
s e t @ C o u n t = 1
|
i f ( @ g'Y±{
QpeÏ< = 5 0 )
|
b e g i n
|
w h i l e ( s e l e c t c o u n t ( * ) f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d P[±{÷S i s n u l l ) > 0
|
b e g i n
|
s e t @ B o x _ c h i l d I D = @ ű{÷S_ ¶g÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ C o u n t )
|
u p d a t e T e m p s e t P[±{÷S= @ B o x _ c h i l d I D , úQP[±{÷S= @ B o x _ c h i l d I D w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d »st/U NI D i n ( s e l e c t t o p ( @ g'Y±{
QpeÏ) »st/U NI D f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d P[±{÷S i s n u l l o r d e r b y ±{
Q»st^÷S, »st½[¦^_ m m d e s c , »stI D )
|
s e t @ C o u n t = @ C o u n t + 1
|
e n d
|
e n d
|
e l s e
|
b e g i n
|
w h i l e ( s e l e c t c o u n t ( * ) f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d P[±{÷S i s n u l l ) > 0
|
b e g i n
|
s e t @ B o x _ c h i l d I D = @ ű{÷S_ ¶g÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ C o u n t )
|
i n s e r t i n t o w e i y i I D ( »st/U NI D ) - - ûm RW[µk ±{pe ؤ<P:N1
|
s e l e c t t o p ( @ g'Y±{
QpeÏ) »st/U NI D f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d P[±{÷S i s n u l l o r d e r b y ±{
Q»st^÷S, »st½[¦^_ m m d e s c , »stI D
|
u p d a t e T e m p s e t úQP[±{÷S= @ B o x _ c h i l d I D w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d »st/U NI D i n ( s e l e c t »st/U NI D f r o m w e i y i I D )
|
u p d a t e T e m p s e t P[±{÷S= @ B o x _ c h i l d I D w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d »st/U NI D i n ( s e l e c t t o p ( 5 0 ) »st/U NI D f r o m w e i y i I D )
|
d e l e t e t o p ( 5 0 ) w e i y i I D
|
s e t @ C o u n t = @ C o u n t + 1
|
s e t @ B o x _ c h i l d I D = @ ű{÷S_ ¶g÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ C o u n t )
|
u p d a t e T e m p s e t P[±{÷S= @ B o x _ c h i l d I D w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d »st/U NI D i n ( s e l e c t »st/U NI D f r o m w e i y i I D )
|
d e l e t e w e i y i I D
|
s e t @ C o u n t = @ C o u n t + 1
|
e n d
|
e n d
|
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ C o p y s ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ P r o _ C o p y s ]
|
@ d a y i n t
|
a s
|
b e g i n
|
b e g i n t r a n
|
b e g i n t r y
|
e x e c P r o _ D e l e t e
|
d e c l a r e @ X[(W i n t
|
s e t @ X[(W= ( s e l e c t c o u n t ( * ) f r o m [ 1 9 2 . 1 6 8 . 3 . 1 6 ] . s h e b e i . d b o . t _ r e p o r t _ p r o c e s s i n g _ o r d e r w h e r e w o r k _ s h o p = 2 0 0 0 a n d l a s t _ u p d a t e _ t i m e > g e t d a t e ( ) - @ d a y )
|
i f ( @ X[(W> 0 )
|
b e g i n
|
- - p r i n t 1
|
e x e c i n s e r t _ c h a i @ d a y
|
d e c l a r e @ c o u n n t i n t
|
d e c l a r e @ D a t e i n g d a t e t i m e
|
- - ågâ g'Yvn u m b e r
|
s e t @ c o u n n t = ( s e l e c t m a x ( n u m b e r ) f r o m O r d e r $ )
|
i f ( @ c o u n n t i s n u l l )
|
b e g i n
|
s e t @ c o u n n t = 0
|
e n d
|
s e t @ c o u n n t = @ c o u n n t + 1
|
- - ¡{ÿű{÷S:N N G + peW[ x<h_ RúQP[±{÷S
|
e x e c P r o _ U p d a t e _ B o x I D @ c o u n n t
|
- - ¡{ÿ±{
Q»st;`pe
|
e x e c P r o _ S u m
|
- - ¡{e¶g{|W
|
e x e c P r o _ T y p e
|
- - bYt[v4Nöehpenc ReQ0RO r d e r s h-N
|
s e t @ D a t e i n g = G E T D A T E ( )
|
- - úQÇv
|
i n s e r t i n t o Q u e s t i o n s T B ( c u s t o m e r _ o r d e r _ n u m b e r , l a s t _ u p d a t e _ d a t e )
|
s e l e c t ¢US÷S, @ D a t e i n g f r o m O r d e r $ w h e r e
|
¢US÷S i n ( s e l e c t ¢US÷S f r o m O r d e r $ w h e r e »stI D i n ( s e l e c t »stI D f r o m T e m p g r o u p b y »stI D ) g r o u p b y ¢[7bãN÷S, ¢US÷S) a n d
|
¢US÷S n o t i n ( s e l e c t c u s t o m e r _ o r d e r _ n u m b e r f r o m Q u e s t i o n s T B g r o u p b y c u s t o m e r _ o r d e r _ n u m b e r )
|
g r o u p b y ¢[7bãN÷S, ¢US÷S h a v i n g m a x ( ±{pe) ! = 0
|
- - (W^
Qv
|
i n s e r t i n t o Q u e s t i o n s T B ( c u s t o m e r _ o r d e r _ n u m b e r , l a s t _ u p d a t e _ d a t e )
|
s e l e c t ¢US÷S, @ D a t e i n g f r o m O r d e r $ w h e r e
|
¢US÷S i n ( s e l e c t ¢US÷S f r o m O r d e r $ w h e r e »stI D i n ( s e l e c t »stI D f r o m T e m p g r o u p b y »stI D ) g r o u p b y ¢[7bãN÷S, ¢US÷S) a n d
|
¢US÷S n o t i n ( s e l e c t c u s t o m e r _ o r d e r _ n u m b e r f r o m Q u e s t i o n s T B g r o u p b y c u s t o m e r _ o r d e r _ n u m b e r ) a n d
|
¢US÷S i n ( s e l e c t ¢US÷S f r o m s t o r a g e g r o u p b y ¢[7bãN÷S, ¢US÷S)
|
g r o u p b y ¢[7bãN÷S, ¢US÷S
|
|
d e l e t e O r d e r $ w h e r e
|
¢US÷S i n (
|
s e l e c t ¢US÷S f r o m O r d e r $ w h e r e
|
¢US÷S i n ( s e l e c t ¢US÷S f r o m O r d e r $ w h e r e »stI D i n ( s e l e c t »stI D f r o m T e m p g r o u p b y »stI D ) g r o u p b y ¢[7bãN÷S, ¢US÷S) a n d
|
¢US÷S n o t i n ( s e l e c t ¢US÷S f r o m s t o r a g e g r o u p b y ¢[7bãN÷S, ¢US÷S)
|
g r o u p b y ¢[7bãN÷S, ¢US÷S h a v i n g m a x ( ±{pe) = 0 )
|
|
i n s e r t i n t o O r d e r $ s e l e c t * f r o m T e m p w h e r e »stI D n o t i n ( s e l e c t »stI D f r o m O r d e r $ g r o u p b y »stI D ) - - ÿb0R@b g¡l gûm Rv»stI D
|
- - RdT e m p h
|
d e l e t e T e m p
|
e n d
|
e n d t r y
|
b e g i n c a t c h
|
s e l e c t E r r o r _ n u m b e r ( ) a s E r r o r N u m b e r , - - ïãNx
|
E r r o r _ s e v e r i t y ( ) a s E r r o r S e v e r i t y , - - ï%Nͧ~+R ÿ§~+R\N1 0 t r y c a t c h Uc· N0R
|
E r r o r _ s t a t e ( ) a s E r r o r S t a t e , - - ï¶r`x
|
E r r o r _ P r o c e d u r e ( ) a s E r r o r P r o c e d u r e , - - úQ°sïvX[¨PÇ zbæÑShVv Tðy0
|
E r r o r _ l i n e ( ) a s E r r o r L i n e , - - ÑS uïvL÷S
|
E r r o r _ m e s s a g e ( ) a s E r r o r M e s s a g e - - ïvwQSOáOo`
|
r o l l b a c k t r a n - - - 1uNúQ ÿÙÌÞVÚn0R _ËY ÿ,{ NagíåS_N¡l gÒceQbR0
|
e n d c a t c h
|
i f ( @ @ t r a n c o u n t > 0 )
|
c o m m i t t r a n
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ D e l e t e ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
- - Rdo r d e r s $ h 1 5 )YKNMRv
|
C R E A T E p r o c [ d b o ] . [ P r o _ D e l e t e ]
|
a s
|
b e g i n
|
d e l e t e O r d e r $ w h e r e l a s t _ u p d a t e _ t i m e < g e t d a t e ( ) - 4 0
|
d e l e t e Q u e s t i o n s T B w h e r e l a s t _ u p d a t e _ d a t e < g e t d a t e ( ) - 2 0
|
e n d
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ I n s e r t X u h a o ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ P r o _ I n s e r t X u h a o ]
|
@ ű{÷S_ ¶g÷S n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
d e c l a r e @ »st/U NI D n v a r c h a r ( 2 5 5 ) - - h:y»st/U NI D
|
d e c l a r e @ ±{
Q»st^÷S i n t - - h:y±{
Q»st^÷S
|
s e t @ ±{
Q»st^÷S= 1
|
d e c l a r e c u r s o r _ X u h a o c u r s o r f o r
|
s e l e c t »st/U NI D f r o m T e m p w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S o r d e r b y S±{
Q^÷S a s c , C O N V E R T ( i n t , »st½[¦^_ m m ) d e s c , »stI D
|
o p e n c u r s o r _ X u h a o
|
f e t c h n e x t f r o m c u r s o r _ X u h a o i n t o @ »st/U NI D
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
u p d a t e T e m p s e t ±{
Q»st^÷S= @ ±{
Q»st^÷S w h e r e ű{÷S_ ¶g÷S= @ ű{÷S_ ¶g÷S a n d »st/U NI D = @ »st/U NI D
|
s e t @ ±{
Q»st^÷S= @ ±{
Q»st^÷S+ 1
|
f e t c h n e x t f r o m c u r s o r _ X u h a o i n t o @ »st/U NI D
|
e n d
|
c l o s e c u r s o r _ X u h a o
|
d e a l l o c a t e c u r s o r _ X u h a o
|
e n d
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ S u m ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
- - ¡{P[±{
Q;`pe
|
c r e a t e p r o c [ d b o ] . [ P r o _ S u m ]
|
a s
|
b e g i n
|
- - d e c l a r e @ ű{÷S_ ¶g÷S n v a r c h a r ( 1 0 0 )
|
d e c l a r e @ P[±{÷S n v a r c h a r ( 1 0 0 )
|
d e c l a r e c u r s o r 1 c u r s o r f o r
|
- - s e l e c t d i s t i n c t P[±{÷S f r o m # # T e m p
|
s e l e c t d i s t i n c t P[±{÷S f r o m T e m p
|
o p e n c u r s o r 1
|
f e t c h n e x t f r o m c u r s o r 1 i n t o @ P[±{÷S
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
- - s e l e c t s u m ( i t e m _ q u a n t i t y ) f r o m T a b l e _ N a m e 1 w h e r e ű{÷S_ ¶g÷S= ' '
|
u p d a t e T e m p s e t ±{
Q»st;`pe= ( s e l e c t C O U N T ( * ) f r o m T e m p w h e r e P[±{÷S= @ P[±{÷S) w h e r e P[±{÷S= @ P[±{÷S
|
f e t c h n e x t f r o m c u r s o r 1 i n t o @ P[±{÷S
|
e n d
|
c l o s e c u r s o r 1
|
d e a l l o c a t e c u r s o r 1
|
e n d
|
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ S u m O u t ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ P r o _ S u m O u t ]
|
a s
|
b e g i n
|
d e c l a r e @ P[±{÷S n v a r c h a r ( 1 0 0 )
|
d e c l a r e c u r s o r 6 c u r s o r f o r
|
s e l e c t d i s t i n c t P[±{÷S f r o m g l a s s O u t 2
|
o p e n c u r s o r 6
|
f e t c h n e x t f r o m c u r s o r 6 i n t o @ P[±{÷S
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
i f ( s e l e c t M A X ( C O N V E R T ( i n t , S±{
Q^÷S) ) f r o m g l a s s O u t 2 w h e r e P[±{÷S= @ P[±{÷S) > 0 - - g^÷Sv
|
b e g i n
|
i f ( s e l e c t t o p ( 1 ) c o u n t ( * ) f r o m g l a s s O u t 2 w h e r e P[±{÷S= @ P[±{÷S g r o u p b y S±{
Q^÷S h a v i n g c o u n t ( * ) > 1 o r d e r b y c o u n t ( * ) d e s c ) > 0
|
b e g i n
|
- - RWY
|
u p d a t e g l a s s O u t 2 s e t ±{
Q»st^÷S= 0 w h e r e P[±{÷S= @ P[±{÷S
|
e x e c p r o c _ X u h a o @ P[±{÷S
|
e n d
|
e n d
|
e l s e - - àe^÷Sv
|
b e g i n
|
e x e c p r o c _ X u h a o @ P[±{÷S
|
e n d
|
u p d a t e g l a s s O u t 2 s e t ±{
Q»st;`pe= ( s e l e c t C O U N T ( * ) f r o m g l a s s O u t 2 w h e r e P[±{÷S= @ P[±{÷S) w h e r e P[±{÷S= @ P[±{÷S
|
- - s e l e c t s u m ( i t e m _ q u a n t i t y ) f r o m T a b l e _ N a m e 1 w h e r e ű{÷S_ ¶g÷S= ' '
|
- - u p d a t e g l a s s O u t s e t ±{
Q»st;`pe= ( s e l e c t C O U N T ( * ) f r o m g l a s s O u t w h e r e P[±{÷S= @ P[±{÷S) w h e r e P[±{÷S= @ P[±{÷S
|
f e t c h n e x t f r o m c u r s o r 6 i n t o @ P[±{÷S
|
e n d
|
c l o s e c u r s o r 6
|
d e a l l o c a t e c u r s o r 6
|
- - Yt[b ûm RÛúQGrh
|
i n s e r t i n t o g l a s s O u t ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m g l a s s O u t 2
|
|
i n s e r t i n t o g l a s s O u t 3 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S, úQGröeô)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S, g e t d a t e ( ) f r o m g l a s s O u t 2
|
d e l e t e g l a s s O u t 2
|
e n d
|
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ T y p e ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
- - ¡{e¶g{|W
|
C R E A T E p r o c [ d b o ] . [ P r o _ T y p e ]
|
a s
|
b e g i n
|
- - s e l e c t * f r o m # # T e m p w h e r e i t e m _ w i d t h > @ S t r _ w i d t h
|
- - c½[¦^[INÏköN»stv{|W\N4 0 0 :N1 , 4 0 0 - 6 0 0 :N2 , 6 0 0 - 8 0 0 :N3 , 8 0 0 åN
|
N:N5
|
u p d a t e T e m p s e t R a c k T y p e I D = 1 w h e r e »st½[¦^_ m m < 4 0 0 . 0 0
|
u p d a t e T e m p s e t R a c k T y p e I D = 2 w h e r e »st½[¦^_ m m b e t w e e n 4 0 0 a n d 6 5 1
|
u p d a t e T e m p s e t R a c k T y p e I D = 3 w h e r e »st½[¦^_ m m b e t w e e n 6 5 2 a n d 8 5 0
|
u p d a t e T e m p s e t R a c k T y p e I D = 5 w h e r e »st½[¦^_ m m > 8 5 0
|
e n d
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ P r o _ U p d a t e _ B o x I D ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
- - ¡{ű{÷S x<h_ J Y C -
|
C R E A T E p r o c [ d b o ] . [ P r o _ U p d a t e _ B o x I D ]
|
@ B o x N u m i n t - - OÂSpe ű{÷S;`pe
|
a s
|
b e g i n
|
- - @ O r d e r s I D @b g¢US÷S @ B o x I D @b gvű{÷S
|
d e c l a r e @ O r d e r s I D n v a r c h a r ( 1 0 0 )
|
d e c l a r e @ B o x I D n v a r c h a r ( 1 0 0 )
|
d e c l a r e @ B o x B O X X n v a r c h a r ( 1 0 0 )
|
d e c l a r e c u r s o r 1 c u r s o r f o r
|
s e l e c t ¢US÷S, ű{÷S_ ¶g÷S f r o m T e m p g r o u p b y ű{÷S_ ¶g÷S, ¢US÷S
|
o p e n c u r s o r 1
|
f e t c h n e x t f r o m c u r s o r 1 i n t o @ O r d e r s I D , @ B o x I D ;
|
- - s e t @ B o x N u m = 1 ;
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
- - Ygű{÷Sò]Ï~ 0R¾ 9 9 9 9 9 9 RÍ°e1 _ËY
|
i f ( @ B o x N u m > 9 9 9 9 9 9 9 o r @ B o x N u m = 0 )
|
b e g i n
|
s e t @ B o x N u m = 1
|
e n d
|
i f ( ( @ B o x I D i s n o t n u l l ) a n d ( @ B o x I D ! = ' ' ) a n d ( @ B o x I D ! = 0 ) )
|
b e g i n
|
s e t @ B o x B O X X = ' J Y C - ' + C O N V E R T ( n v a r c h a r , @ B o x N u m )
|
e n d
|
e l s e
|
b e g i n
|
s e t @ B o x B O X X = ' J Y C \ ' + C O N V E R T ( n v a r c h a r , @ B o x N u m )
|
e n d
|
- - îO9e4Nöeh-N T N¢US T Nű{÷S bű{÷S 9e:NN G + @ B o x N u m
|
u p d a t e T e m p s e t ű{÷S_ ¶g÷S= @ B o x B O X X , n u m b e r = @ B o x N u m w h e r e ¢US÷S= @ O r d e r s I D a n d ű{÷S_ ¶g÷S= @ B o x I D
|
- - e x e c P r o _ I n s e r t X u h a o @ B o x B O X X - - R^÷S
|
e x e c P r o _ C h i l d B o x @ B o x B O X X - - RP[±{÷S
|
s e t @ B o x N u m = @ B o x N u m + 1 ;
|
f e t c h n e x t f r o m c u r s o r 1 i n t o @ O r d e r s I D , @ B o x I D
|
e n d
|
c l o s e c u r s o r 1
|
d e a l l o c a t e c u r s o r 1
|
e n d
|
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ a a ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
c r e a t e p r o c [ d b o ] . [ p r o c _ a a ]
|
a s
|
b e g i n
|
d e c l a r e @ g'Y±{
QpeÏ i n t
|
d e c l a r e @ ű{÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ P[±{÷S n v a r c h a r ( 5 0 )
|
|
d e c l a r e @ ò]0RGrpe i n t
|
d e c l a r e @ ±{
Q»st;`pe i n t
|
s e l e c t [ ű{÷Sÿ¶g÷S ÿ] , P[±{÷S, c o u n t ( * ) , ±{
Q»st;`pe, [ »stS¦^ÿm m ÿ] f r o m s t o r a g e g r o u p b y P[±{÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, [ »stS¦^ÿm m ÿ]
|
o p e n c u r s o r 2
|
f e t c h n e x t f r o m c u r s o r 2 i n t o @ ű{÷S, @ P[±{÷S, @ ò]0RGrpe, @ ±{
Q»st;`pe
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
- - p r i n t ( @ S¦^)
|
f e t c h n e x t f r o m c u r s o r 2 i n t o @ ű{÷S, @ P[±{÷S, @ ò]0RGrpe, @ ±{
Q»st;`pe
|
e n d
|
c l o s e c u r s o r 2 - - sQí8nh
|
d e a l l o c a t e c u r s o r 2
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ C h u P i a n ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ p r o c _ C h u P i a n ]
|
@ P[±{÷SúQ n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
- - - - - - _ËYMSP[±{ hQèSbS
|
d e c l a r e @ »st/U NI D n v a r c h a r ( 2 5 5 ) - - h:y»st/U NI D
|
d e c l a r e @ N u m b e r i n t - - h:y,{àQGr
|
d e c l a r e @ C o u n t i n t - - h:y,{àQ*N±{
|
d e c l a r e @ B o x _ c h i l d I D n v a r c h a r ( 5 0 ) - - °eP[±{÷S
|
s e t @ N u m b e r = 1
|
s e t @ C o u n t = ( s e l e c t M A X ( ±{pe) f r o m O r d e r $ w h e r e P[±{÷S= @ P[±{÷SúQ) + 1
|
d e c l a r e c u r s o r _ T a G l a s s I d c u r s o r f o r
|
s e l e c t »st/U NI D f r o m s t o r a g e w h e r e P[±{÷S= @ P[±{÷SúQ o r d e r b y C O N V E R T ( i n t , r a c k I D ) d e s c , e¶g
|
Nv^÷S d e s c
|
o p e n c u r s o r _ T a G l a s s I d
|
f e t c h n e x t f r o m c u r s o r _ T a G l a s s I d i n t o @ »st/U NI D
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
i f ( @ N u m b e r < = 5 0 )
|
b e g i n
|
s e t @ B o x _ c h i l d I D = @ P[±{÷SúQ+ ' - ' + C O N V E R T ( n v a r c h a r , @ C o u n t )
|
s e t @ N u m b e r = @ N u m b e r + 1
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷SúQ a n d »st/U NI D = @ »st/U NI D
|
u p d a t e O r d e r $ s e t ±{pe= @ C o u n t w h e r e P[±{÷S= @ P[±{÷SúQ a n d »st/U NI D = @ »st/U NI D
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ B o x _ c h i l d I D w h e r e P[±{÷S= @ P[±{÷SúQ a n d »st/U NI D = @ »st/U NI D
|
e n d
|
e l s e
|
b e g i n
|
s e t @ C o u n t = @ C o u n t + 1
|
s e t @ N u m b e r = 2
|
s e t @ B o x _ c h i l d I D = @ P[±{÷SúQ+ ' - ' + C O N V E R T ( n v a r c h a r , @ C o u n t )
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷SúQ a n d »st/U NI D = @ »st/U NI D
|
u p d a t e O r d e r $ s e t ±{pe= @ C o u n t w h e r e P[±{÷S= @ P[±{÷SúQ a n d »st/U NI D = @ »st/U NI D
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ B o x _ c h i l d I D w h e r e P[±{÷S= @ P[±{÷SúQ a n d »st/U NI D = @ »st/U NI D
|
e n d
|
f e t c h n e x t f r o m c u r s o r _ T a G l a s s I d i n t o @ »st/U NI D
|
e n d
|
c l o s e c u r s o r _ T a G l a s s I d - - sQí8nhc u r s o r _ T a G l a s s I d
|
d e a l l o c a t e c u r s o r _ T a G l a s s I d
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ C h u p i a n T y p e 1 ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ p r o c _ C h u p i a n T y p e 1 ]
|
@ ű{÷S n v a r c h a r ( 5 0 )
|
a s
|
b e g i n
|
d e c l a r e @ P[±{÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ ±{
Q»st;`pe i n t
|
d e c l a r e @ P[±{
Q g'YS¦^ n v a r c h a r ( 5 0 )
|
d e c l a r e @ ò]0RGrpe i n t
|
d e c l a r e @ g'Y±{
QpeÏ i n t
|
d e c l a r e c u r s o r _ M y B o x c u r s o r f o r
|
s e l e c t P[±{÷S, ±{
Q»st;`pe, M A X ( [ »stS¦^ÿm m ÿ] ) , c o u n t ( * ) f r o m s t o r a g e w h e r e [ ű{÷Sÿ¶g÷S ÿ] = @ ű{÷S g r o u p b y P[±{÷S, ±{
Q»st;`pe
|
o p e n c u r s o r _ M y B o x
|
f e t c h n e x t f r o m c u r s o r _ M y B o x i n t o @ P[±{÷S, @ ±{
Q»st;`pe, @ P[±{
Q g'YS¦^, @ ò]0RGrpe
|
- - MSP[±{÷S Yt
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
d e c l a r e @ »st/U NI D 2 n v a r c h a r ( 2 5 5 ) - - h:y»st/U NI D
|
d e c l a r e @ Grpe i n t - - h:y,{àQGr
|
d e c l a r e @ ±{pe i n t - - h:y,{àQ*N±{
|
d e c l a r e @ °eP[±{÷S n v a r c h a r ( 5 0 ) - - °eP[±{÷S
|
i f ( @ P[±{
Q g'YS¦^= ' 1 0 ' )
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 4 5
|
e n d
|
e l s e i f ( @ P[±{
Q g'YS¦^= ' 6 ' )
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 6 0
|
e n d
|
e l s e i f ( @ P[±{
Q g'YS¦^= ' 5 ' )
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 7 0
|
e n d
|
e l s e
|
b e g i n
|
s e t @ g'Y±{
QpeÏ= 5 0
|
e n d
|
- - án³ N±{agöN
|
i f ( @ ò]0RGrpe> = @ g'Y±{
QpeÏ)
|
b e g i n
|
s e t @ Grpe= 0
|
s e t @ ±{pe= ( s e l e c t M A X ( ±{pe) f r o m O r d e r $ w h e r e P[±{÷S= @ P[±{÷S) + 1
|
d e c l a r e c u r s o r _ M y G l a s s _ i d c u r s o r f o r
|
s e l e c t »st/U NI D f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D n o t i n ( s e l e c t »st/U NI D f r o m g l a s s O u t 2 g r o u p b y »st/U NI D ) o r d e r b y C O N V E R T ( i n t , r a c k I D ) d e s c , e¶g
|
Nv^÷S d e s c
|
o p e n c u r s o r _ M y G l a s s _ i d
|
f e t c h n e x t f r o m c u r s o r _ M y G l a s s _ i d i n t o @ »st/U NI D 2
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
i f ( @ Grpe= @ g'Y±{
QpeÏ)
|
b e g i n
|
b r e a k
|
e n d
|
e l s e i f ( @ Grpe< 5 0 )
|
b e g i n
|
s e t @ °eP[±{÷S= @ P[±{÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ ±{pe)
|
s e t @ Grpe= @ Grpe+ 1
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ °eP[±{÷S w h e r e »st/U NI D = @ »st/U NI D 2
|
u p d a t e O r d e r $ s e t ±{pe= @ ±{pe w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
e n d
|
e l s e
|
b e g i n
|
i f ( @ Grpe= 5 0 )
|
b e g i n
|
s e t @ ±{pe= @ ±{pe+ 1
|
e n d
|
s e t @ °eP[±{÷S= @ P[±{÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ ±{pe)
|
s e t @ Grpe= @ Grpe+ 1
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ °eP[±{÷S w h e r e »st/U NI D = @ »st/U NI D 2
|
u p d a t e O r d e r $ s e t ±{pe= @ ±{pe w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
e n d
|
f e t c h n e x t f r o m c u r s o r _ M y G l a s s _ i d i n t o @ »st/U NI D 2
|
e n d
|
c l o s e c u r s o r _ M y G l a s s _ i d - - sQí8nhc u r s o r _ M y G l a s s _ i d
|
d e a l l o c a t e c u r s o r _ M y G l a s s _ i d
|
b r e a k
|
e n d
|
e l s e i f ( ( @ ±{
Q»st;`pe- ( s e l e c t c o u n t ( * ) f r o m O r d e r $ w h e r e P[±{÷S= @ P[±{÷S a n d ±{pe> 0 ) ) = @ ò]0RGrpe) - - àe±{÷S ÿ±{
Q;`pe\N5 0 Töeò]Ï~0R¾v
|
b e g i n
|
i f ( @ ò]0RGrpe< = 5 0 ) - - àe±{÷S g^÷S ÿYt[bvÿpeÏ< 5 0 ÿ gT NybvöeP
|
b e g i n
|
s e t @ ±{pe= ( s e l e c t M A X ( ±{pe) f r o m O r d e r $ w h e r e P[±{÷S= @ P[±{÷S) + 1
|
s e t @ °eP[±{÷S= @ P[±{÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ ±{pe)
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ °eP[±{÷S w h e r e P[±{÷S= @ P[±{÷S
|
- - u p d a t e O r d e r $ s e t ±{pe= @ ±{pe w h e r e P[±{÷S= @ P[±{÷S
|
e n d
|
e l s e
|
b e g i n
|
s e t @ Grpe= 0
|
s e t @ ±{pe= ( s e l e c t M A X ( ±{pe) f r o m O r d e r $ w h e r e P[±{÷S= @ P[±{÷S) + 1
|
d e c l a r e c u r s o r _ M y G l a s s _ i d 2 c u r s o r f o r
|
s e l e c t »st/U NI D f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D n o t i n ( s e l e c t »st/U NI D f r o m g l a s s O u t 2 g r o u p b y »st/U NI D ) o r d e r b y C O N V E R T ( i n t , r a c k I D ) d e s c , e¶g
|
Nv^÷S d e s c
|
o p e n c u r s o r _ M y G l a s s _ i d 2
|
f e t c h n e x t f r o m c u r s o r _ M y G l a s s _ i d 2 i n t o @ »st/U NI D 2
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
i f ( @ Grpe< 5 0 )
|
b e g i n
|
s e t @ °eP[±{÷S= @ P[±{÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ ±{pe)
|
s e t @ Grpe= @ Grpe+ 1
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ °eP[±{÷S w h e r e »st/U NI D = @ »st/U NI D 2
|
u p d a t e O r d e r $ s e t ±{pe= @ ±{pe w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
e n d
|
e l s e
|
b e g i n
|
s e t @ ±{pe= @ ±{pe+ 1
|
s e t @ °eP[±{÷S= @ P[±{÷S+ ' - ' + C O N V E R T ( n v a r c h a r , @ ±{pe)
|
s e t @ Grpe= @ Grpe+ 1
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
u p d a t e g l a s s O u t 2 s e t P[±{÷S= @ °eP[±{÷S w h e r e »st/U NI D = @ »st/U NI D 2
|
u p d a t e O r d e r $ s e t ±{pe= @ ±{pe w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D 2
|
e n d
|
f e t c h n e x t f r o m c u r s o r _ M y G l a s s _ i d 2 i n t o @ »st/U NI D 2
|
e n d
|
c l o s e c u r s o r _ M y G l a s s _ i d 2 - - sQí8nhc u r s o r _ M y G l a s s _ i d 2
|
d e a l l o c a t e c u r s o r _ M y G l a s s _ i d 2
|
e n d
|
b r e a k
|
e n d
|
f e t c h n e x t f r o m c u r s o r _ M y B o x i n t o @ P[±{÷S, @ ±{
Q»st;`pe, @ P[±{
Q g'YS¦^, @ ò]0RGrpe
|
e n d
|
c l o s e c u r s o r _ M y B o x
|
d e a l l o c a t e c u r s o r _ M y B o x - - sQí8nhc u r s o r _ M y B o x
|
e n d
|
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ C h u p i a n T y p e 2 ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ p r o c _ C h u p i a n T y p e 2 ]
|
@ ű{÷S n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
d e c l a r e @ úQP[±{÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ ò]0RGrpe2 i n t
|
d e c l a r e c u r s o r _ T a B o x 2 c u r s o r f o r
|
s e l e c t úQP[±{÷S, c o u n t ( * ) f r o m s t o r a g e w h e r e [ ű{÷Sÿ¶g÷S ÿ] = @ ű{÷S g r o u p b y úQP[±{÷S
|
o p e n c u r s o r _ T a B o x 2
|
f e t c h n e x t f r o m c u r s o r _ T a B o x 2 i n t o @ úQP[±{÷S, @ ò]0RGrpe2
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
- - ò]0RpeÏ= = ±{
Q»st;`pe
|
i f ( ( s e l e c t c o u n t ( * ) f r o m O r d e r $ w h e r e úQP[±{÷S= @ úQP[±{÷S) = @ ò]0RGrpe2 )
|
b e g i n
|
i n s e r t i n t o g l a s s O u t 2 ( ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S)
|
s e l e c t ^÷S, ¢[7bãN÷S, ¤N'åe g, ¢US÷S, [ ű{÷Sÿ¶g÷S ÿ] , ±{
Q»st;`pe, WY÷S, WY
Q»st;`pe, »stI D , [ »st¦^ÿm m ÿ] , [ »st½[¦^ÿm m ÿ] , [ »stS¦^ÿm m ÿ] , R a c k T y p e I D , r a c k I D , e¶g
|
NvS¦^, e¶g
|
Nv^÷S, ±{
Q»st^÷S, ö«WS¦^, P[±{÷S, »st/U NI D , Sű{÷S, S±{
Q^÷S f r o m s t o r a g e
|
w h e r e úQP[±{÷S= @ úQP[±{÷S
|
e n d
|
- - - - - - hQèSbS[b
|
f e t c h n e x t f r o m c u r s o r _ T a B o x 2 i n t o @ úQP[±{÷S, @ ò]0RGrpe2
|
e n d
|
c l o s e c u r s o r _ T a B o x 2
|
d e a l l o c a t e c u r s o r _ T a B o x 2 - - sQí8nhc u r s o r _ T a B o x 2
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ X u h a o ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ p r o c _ X u h a o ]
|
@ P[±{÷S n v a r c h a r ( 1 0 0 )
|
a s
|
b e g i n
|
- - ûm R^÷S
|
d e c l a r e @ »st/U NI D n v a r c h a r ( 1 0 0 )
|
d e c l a r e @ ^÷S n v a r c h a r ( 1 0 0 )
|
s e t @ ^÷S= 1
|
d e c l a r e c u r s o r _ G l a s s O u t X u c u r s o r f o r
|
s e l e c t »st/U NI D f r o m g l a s s O u t 2 w h e r e P[±{÷S= @ P[±{÷S o r d e r b y S±{
Q^÷S a s c , [ »st½[¦^ÿm m ÿ] d e s c , »stI D
|
o p e n c u r s o r _ G l a s s O u t X u
|
f e t c h n e x t f r o m c u r s o r _ G l a s s O u t X u i n t o @ »st/U NI D
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
u p d a t e g l a s s O u t 2 s e t ±{
Q»st^÷S= @ ^÷S w h e r e P[±{÷S= @ P[±{÷S a n d »st/U NI D = @ »st/U NI D
|
s e t @ ^÷S= @ ^÷S+ 1
|
f e t c h n e x t f r o m c u r s o r _ G l a s s O u t X u i n t o @ »st/U NI D
|
e n d
|
c l o s e c u r s o r _ G l a s s O u t X u
|
d e a l l o c a t e c u r s o r _ G l a s s O u t X u
|
e n d
|
G O
|
/ * * * * * * O b j e c t : S t o r e d P r o c e d u r e [ d b o ] . [ p r o c _ Z o n g ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E p r o c [ d b o ] . [ p r o c _ Z o n g ]
|
a s
|
b e g i n
|
i f ( ( s e l e c t c o u n t ( * ) f r o m g l a s s O u t ) = 0 ) - - åg wúQGrh/f&Tò] gpenc
|
b e g i n
|
d e c l a r e @ ű{÷S n v a r c h a r ( 5 0 )
|
d e c l a r e c u r s o r _ A l l c u r s o r f o r
|
s e l e c t [ ű{÷Sÿ¶g÷S ÿ] f r o m s t o r a g e g r o u p b y [ ű{÷Sÿ¶g÷S ÿ]
|
o p e n c u r s o r _ A l l
|
f e t c h n e x t f r o m c u r s o r _ A l l i n t o @ ű{÷S
|
- - _ËYMS@b gvű{÷S
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
- - ÖNìNvű{÷S ánNúQ
|
i f ( ( s e l e c t P A T I N D E X ( ' % J Y C - % ' , @ ű{÷S) ) > 0 a n d ( s e l e c t c o u n t ( * ) f r o m O r d e r $ w h e r e [ ű{÷Sÿ¶g÷S ÿ] = @ ű{÷S) = ( s e l e c t c o u n t ( * ) f r o m s t o r a g e w h e r e [ ű{÷Sÿ¶g÷S ÿ] = @ ű{÷S) )
|
b e g i n
|
d e c l a r e @ P[±{÷S n v a r c h a r ( 5 0 )
|
d e c l a r e @ ±{
Q»st;`pe i n t
|
d e c l a r e @ ò]0RGrpe i n t
|
d e c l a r e c u r s o r _ T a B o x c u r s o r f o r
|
s e l e c t P[±{÷S, ±{
Q»st;`pe, c o u n t ( * ) f r o m s t o r a g e w h e r e [ ű{÷Sÿ¶g÷S ÿ] = @ ű{÷S g r o u p b y P[±{÷S, ±{
Q»st;`pe
|
o p e n c u r s o r _ T a B o x
|
f e t c h n e x t f r o m c u r s o r _ T a B o x i n t o @ P[±{÷S, @ ±{
Q»st;`pe, @ ò]0RGrpe
|
w h i l e @ @ f e t c h _ s t a t u s = 0
|
b e g i n
|
e x e c p r o c _ C h u P i a n @ P[±{÷S
|
- - - - - - hQèSbS[b
|
f e t c h n e x t f r o m c u r s o r _ T a B o x i n t o @ P[±{÷S, @ ±{
Q»st;`pe, @ ò]0RGrpe
|
e n d
|
c l o s e c u r s o r _ T a B o x
|
d e a l l o c a t e c u r s o r _ T a B o x - - sQí8nhc u r s o r _ M y B o x
|
b r e a k - - úQGr
|
e n d
|
- - bìNvű{÷S
|
e l s e i f ( ( s e l e c t P A T I N D E X ( ' % J Y C \ % ' , @ ű{÷S) ) > 0 )
|
b e g i n
|
i f ( s e l e c t c o u n t ( * ) f r o m O r d e r $ w h e r e [ ű{÷Sÿ¶g÷S ÿ] = @ ű{÷S a n d úQP[±{÷S i s n o t n u l l ) > 0
|
b e g i n
|
e x e c p r o c _ C h u p i a n T y p e 2 @ ű{÷S - - !j_2
|
e n d
|
e l s e
|
b e g i n
|
e x e c p r o c _ C h u p i a n T y p e 1 @ ű{÷S - - !j_1
|
e n d
|
e n d
|
i f ( ( s e l e c t c o u n t ( * ) f r o m g l a s s O u t 2 ) ! = 0 ) - - åg wúQGrh/f&Tò] gpenc
|
b e g i n
|
b r e a k
|
e n d
|
f e t c h n e x t f r o m c u r s o r _ A l l i n t o @ ű{÷S
|
e n d
|
c l o s e c u r s o r _ A l l
|
d e a l l o c a t e c u r s o r _ A l l - - sQí8nhc u r s o r _ A l l
|
|
e x e c P r o _ S u m O u t - - ¡{úQGrhP[±{
Q;`pe v^ûm RÛúQGrh
|
e n d
|
e n d
|
G O
|
/ * * * * * * O b j e c t : D d l T r i g g e r [ O n T r i g g e r D b o S c h e m a ] S c r i p t D a t e : 2 0 2 3 / 1 2 / 1 1 8 : 4 5 : 0 0 * * * * * * /
|
S E T A N S I _ N U L L S O N
|
G O
|
S E T Q U O T E D _ I D E N T I F I E R O N
|
G O
|
C R E A T E t r i g g e r [ O n T r i g g e r D b o S c h e m a ] O N d a t a b a s e F O R c r e a t e _ t a b l e , c r e a t e _ v i e w A S B E G I N D E C L A R E @ x m l E v e n t D a t a x m l S E L E C T @ x m l E v e n t D a t a = e v e n t d a t a ( ) D E C L A R E @ s c h e m a N a m e n v a r c h a r ( m a x ) D E C L A R E @ o b j e c t N a m e n v a r c h a r ( m a x ) D E C L A R E @ D y n S q l n v a r c h a r ( m a x ) S E T @ s c h e m a N a m e = c o n v e r t ( n v a r c h a r ( m a x ) , @ x m l E v e n t D a t a . q u e r y ( ' / E V E N T _ I N S T A N C E / S c h e m a N a m e / t e x t ( ) ' ) ) S E T @ o b j e c t N a m e = c o n v e r t ( n v a r c h a r ( m a x ) , @ x m l E v e n t D a t a . q u e r y ( ' / E V E N T _ I N S T A N C E / O b j e c t N a m e / t e x t ( ) ' ) ) I F ( @ s c h e m a N a m e = ' ' ) B E G I N S E T @ D y n S q l = N ' a l t e r s c h e m a [ d b o ] t r a n s f e r [ ' + @ s c h e m a N a m e + N ' ] . [ ' + @ o b j e c t N a m e + N ' ] ' E X E C s p _ e x e c u t e s q l @ s t a t e m e n t = @ D y n S q l E N D E N D S E T Q U O T E D _ I D E N T I F I E R O N S E T A N S I _ N U L L S O N
|
G O
|
E N A B L E T R I G G E R [ O n T r i g g e r D b o S c h e m a ] O N D A T A B A S E
|
G O
|
|
