Showing related tags and posts accross the entire site.
-
select convert ( char ( 10 ), [LogDate] , 101 ), count (*) from [ Logs] group by convert ( char ( 10 ), [LogDate] , 101 ) order by convert ( char ( 10 ), [LogDate] , 101 ) desc
-
t-sql statement to delete every other row of a table. I used for a testing app to test it when it does 50% updates and 50% inserts DELETE FROM [tbl_Asteryx_Profiles] where ProfileID % 2 > 0 used with... UPDATE [tbl_Profiles] SET StringValue = @StringValue, BinaryValue = @BinaryValue, LastUpdated ...