- smc_source_1.zip
- SMC_Source
- Smc.jar
- SMC_Demo
- DataAccess
- DataAccess
- Domain
- Domain
- ServicesProvider
- ServicesProvider
- SMC_Demo
- SMCWebsite
- SQL Database Script
- SMC_Source.zip
|
��U S E [ C a r A u t o m a t i o n ]
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 ] . [ s s p _ C a r D a s h b o a r d ] S c r i p t D a t e : 1 0 / 2 0 / 2 0 0 8 1 8 : 5 6 : 0 5 * * * * * * /
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 E D U R E [ d b o ] . [ s s p _ C a r D a s h b o a r d ]
- - A d d t h e p a r a m e t e r s f o r t h e s t o r e d p r o c e d u r e h e r e
A S
B E G I N
S E L E C T C a r . C a r _ I D
, C a r . C u r r e n t _ S t a t e _ I D
, C a r . P r e v i o u s _ S t a t e _ I D
, C u r r e n t S t a t e . S t a t e _ N a m e a s C u r r e n t _ S t a t e
, P r e v i o u s S t a t e . S t a t e _ N a m e a s P r e v i o u s _ S t a t e
, C u r r e n t S t a t e . S t a t e _ P a g e _ U R L
, C a r . C r e a t e d _ B y _ I D
F R O M C a r , S t a t e M a s t e r C u r r e n t S t a t e , S t a t e M a s t e r P r e v i o u s S t a t e
w h e r e C a r . C u r r e n t _ S t a t e _ I D = C u r r e n t S t a t e . S t a t e _ I D
a n d C a r . P r e v i o u s _ S t a t e _ I D = P r e v i o u s S t a t e . S t a t e _ I D
o r d e r b y C a r . c a r _ I D a s c
E N D
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.