Advanced Search

Return to Snippet

Revision: 56149
at March 13, 2012 03:35 by ChristineFM
Initial Code 
SELECT 	        *
FROM		dbo.OnCall_stats
WHERE		Chargeable = 'yes'
	AND 	paid = '0'
ORDER BY 	Entry_Date DESC
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Retrieves a list of "on call" incidents for the most recent time period.  Selects all Support Analysts.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
On Call Statistics

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL