c r e a t e   P R O C E D U R E   [ d b o ] . [ E a s y E M a g _ P _ G e t R e c o r d B y P a g e ]   
 
 (   
 
 @ s T a b l e   n v a r c h a r ( 1 0 0 ) ,     - - h
T  
 
 @ s P k e y   n v a r c h a r ( 5 0 ) ,                         - - ;N.(  N[	g)   
 
 @ s F i e l d   n v a r c h a r ( 1 0 0 0 ) = ' * ' ,           - - W[k  
 
 @ i P a g e C u r r   i n t ,                                   - - S_MRupe  
 
 @ i P a g e S i z e   i n t ,                                   - - kuU_pe  
 
 @ s C o n d i t i o n   n v a r c h a r ( 1 0 0 0 ) ,     - - agN( 
N w h e r e )   
 
 @ s O r d e r   n v a r c h a r ( 1 0 0 )   ,                   - - c^( 
N o r d e r   b y ,  a s c Td e s c W[&{)   
 
 @ C o u n t s   i n t = 0   o u t p u t ,                       - - U_agpe( ]	g<P: YK<P, 0 gbLc o u n t )   
 
 @ p a g e C o u n t   i n t = 1   o u t p u t           - - g~gRuTv;`upe  
 
 )   
 
 A S   
 
 S E T   N O C O U N T   O N   
 
 D E C L A R E   @ s C 1   n v a r c h a r ( 1 0 0 0 ) , @ s C 2   n v a r c h a r ( 1 0 0 0 )   
 
 D E C L A R E   @ i A s c   i n t , @ i D e s c   i n t , @ i T y p e   t i n y i n t   
 
 D E C L A R E   @ s T 1   n v a r c h a r ( 1 0 0 0 ) , @ s T 2   n v a r c h a r ( 1 0 0 0 ) , @ s T 3   n v a r c h a r ( 1 0 0 0 ) , @ s T 4   n v a r c h a r ( 1 0 0 0 ) , @ s S Q L   n v a r c h a r ( 4 0 0 0 )   
 
 / * - - - - - - - - - - - - - - - - - - - - - - $Rew h e r e   agN/f&Tzz<P- - - - - - - - - - - - - - - - - - - * /   
 
 I F   L E N ( @ s C o n d i t i o n ) > 2   
 
   S E L E C T   @ s C 1 = '   W H E R E   ' + @ s C o n d i t i o n + '   ' ,   @ s C 2 = '   W H E R E   ' + @ s C o n d i t i o n + '   A N D   '   
 
   E L S E   
 
   B E G I N   
 
     S E L E C T   @ s C 1 = ' ' ,   @ s C 2 = '   W H E R E   '   
 
   E N D   
 
 
 
 S E L E C T   @ s T 1 = U P P E R ( @ s O r d e r ) ,   @ s T 2 = @ s O r d e r ,   @ i T y p e = 0 ,   @ s O r d e r = ' ' ,   @ s T 4 = U P P E R ( @ s P k e y )   
 
 / * - - - - - - - - - - - - - - - - - - - - - - - Sg⋄vpencLpe- - - - - - - - - - - - - - - - - - - - - * /   
 
 I F   L E N ( @ s T 2 ) > 2   
 
 B E G I N   
 
   S E L E C T   @ i A s c = 0 ,   @ i D e s c = 0   
 
   I F   @ s T 4 = S U B S T R I N G ( @ s T 1 , 0 , L E N ( @ s T 4 ) )   - - X[(W;N^  
 
           B E G I N   
 
     S E L E C T   @ i A s c = C H A R I N D E X ( ' A S C ' , @ s T 1 ) ,   @ i D e s c = C H A R I N D E X ( ' D E S C ' , @ s T 1 )   
 
   E N D   
 
   I F   ( @ i A s c > 0   a n d   @ i D e s c = 0 )   O R   ( ( @ i A s c > 0   A N D   @ i D e s c > 0 )   A N D   ( @ i A s c < @ i D e s c ) )   
 
     S E L E C T   @ i T y p e = 1 ,   @ s T 3 = ' > ( S E L E C T   M A X ( '   
 
   E L S E   I F   ( @ i A s c = 0   a n d   @ i D e s c > 0 )   O R   ( ( @ i A s c > 0   A N D   @ i D e s c > 0 )   A N D   ( @ i A s c > @ i D e s c ) )   - - [ P a g e ] 
 
   B E G I N   
 
     S E L E C T   @ i T y p e = 1 ,   @ s T 3 = ' < ( S E L E C T   M I N ( '   
 
   E N D   
 
   S E T   @ s O r d e r = '   O R D E R   B Y   ' + @ s T 2   
 
 E N D   
 
 / * - - - - - - - - - - - - - - - - - - - - - - - - - Sg⋄vpencLpe- - - - - - - - - - - - - - - - - - - - - - * /   
 
 
 
 S E T   @ s S Q L = ' S E L E C T   @ C o u n t s = C o u n t ( 0 )   F R O M   ' + @ s T a b l e + @ s C 1   
 
 E X E C   s p _ e x e c u t e s q l   @ s S Q L , N ' @ C o u n t s   i n t   O U T ' , @ C o u n t s   O U T   
 
 S E T   @ p a g e C o u n t = ( @ C o u n t s + @ i p a g e S i z e - 1 ) / @ i p a g e S i z e   
 
 I F   @ i P a g e C u r r > @ p a g e C o u n t   
 
   S E T   @ i P a g e C u r r = @ p a g e C o u n t   
 
 S E L E C T   @ i P a g e C u r r = ( C A S E   W H E N   @ C o u n t s < ( @ i P a g e C u r r - 1 ) * @ i P a g e S i z e   T H E N   C E I L I N G ( @ C o u n t s / @ i P a g e S i z e )   W H E N   @ i P a g e C u r r < 1   T H E N   1   E L S E   @ i P a g e C u r r   E N D )   
 
 I F   ( @ i P a g e C u r r > 1 )   A N D   ( @ i T y p e = 1 )   
 
   S E T   @ s S Q L = ' S E L E C T   T O P   ' + C A S T ( @ i P a g e S i z e   A S   n v a r c h a r ) + '   ' + @ s F i e l d + '   F R O M   ' + @ s T a b l e + @ s C 2 + @ s P k e y + @ s T 3 + @ s P k e y + ' )   F R O M   ( S E L E C T   T O P   ' + C A S T ( ( @ i P a g e C u r r - 1 ) * @ i P a g e S i z e   A S   n v a r c h a r ) + '   ' + @ s P k e y + '   F R O M   ' + @ s T a b l e + @ s C 1 + @ s O r d e r + ' )   A S   t b T e m p ) ' + @ s O r d e r   
 
 E L S E   I F   ( @ i P a g e C u r r > 1 )   A N D   ( @ i T y p e = 0 )   
 
   S E T   @ s S Q L = ' S E L E C T   ' + @ s F i e l d + '   F R O M   ' + @ s T a b l e + @ s C 2 + @ s P k e y + '   I N   ( S E L E C T   T O P   ' + C A S T ( @ i P a g e S i z e   A S   n v a r c h a r ) + '   ' + @ s P k e y + '   F R O M   ' + @ s T a b l e + @ s C 2 + @ s P k e y + '   N O T   I N ( S E L E C T   T O P   ' + C A S T ( ( @ i P a g e C u r r - 1 ) * @ i P a g e S i z e   A S   n v a r c h a r ) + '   ' + @ s P k e y + '   F R O M   ' + @ s T a b l e + @ s C 1 + @ s O r d e r + ' ) ' + @ s O r d e r + ' ) ' + @ s O r d e r   
 
 E L S E   
 
 B E G I N   
 
         S E T   @ s S Q L = ' S E L E C T   T O P   ' + C A S T ( @ i P a g e S i z e   A S   n v a r c h a r ) + '   ' + @ s F i e l d + '   F R O M   ' + @ s T a b l e + @ s C 1 + @ s O r d e r   
 
 E N D   
 
 E X E C ( @ s S Q L )   
 
 - - p r i n t   @ s S Q L   
 
 p r i n t   @ C o u n t s   
 
 p r i n t   @ p a g e C o u n t   
 
 S E T   N O C O U N T   O F F     
 
 