#TSQL
5 posts from Sep 28, 2009 to Oct 13, 2013, newest first.
Creating a Compound NULLIF in AVG Function With SqlServer
My use case is I’ve got a session survey column on the Silicon Valley Code Camp session evaluation page.& 160; The results of a question like “How is this course overall” can be 0,1,2,3,4,5 where 0…
Tip for Using SQLServer To Count By Alpha Names in a list
& 160; So, this is not a big tip, but worth at least 10 minutes to figure it out on your own.& 160; Here is to saving you 10 minutes: & 160; SELECT LEFT (userlastname, 1) as alpha, count (id) FROM…
Writing A Transact SQL (TSQL) Procedure For SQL Server 2008 To Delete Rows From Table Safely
In this post, we will show and explain a small TSQL Sql Server 2008 procedure that deletes all rows in a table that are older than some specified date.& 160; That is, say the table has 10,000,000…