Changing file name extensions in Windows Mobile

Now, of course you can do this by connecting your mobile to your PC and just finding the file – but sometimes you don’t have your laptop with you, right? Today I came across a utility which lets me do this – it’s PocketPlus from Spb. Definitely worth checking out I think. Spb also have a very nice Mobile Shell, which seems to rival PointUI (which I also think is very good). PointUI wins out for me at the moment though, because I’m having to use my old Windows Mobile 2003 device. Also, it seems to have been written by … Continue reading Changing file name extensions in Windows Mobile

Dynamic ordering with T-SQL

This is an oldie, but a goodie. I was talking to Dave Gardiner about a question he had recently, the question of how to dynamically sort the results of a T-SQL query. He was thinking of something like this: –Not so useful – only works in a stored procedureIF (@order = ‘Column1’)     SELECT * from Table1 ORDER BY Column1 ELSE IF (@order = ‘Column2’)     SELECT * from Table1 ORDER BY Column2 And one of the suggestions in his comments was to use the CASE statement: –Not bad, but only works if the types are compatibleSELECT *FROM Table1ORDER BY … Continue reading Dynamic ordering with T-SQL