Profile
Achievement
 
    
                highlyevolved's Recent Snippets
- All /
 « Prev 1 Next »
A Temp table is great for combining multiple SELECT statements in a Sproc and outputting as just one table.
Don't forget to Drop the table after the  SELECT * FROM #TempTableName at the end.
        
        
        
            2 
        
        
            1778 
        
                    posted 15 years ago by highlyevolved
            These statements convert a date/time field into just a date or a time field
        
        
        
            2 
        
        
            1613 
        
                    posted 15 years ago by highlyevolved