Category Archives: Programming
Really?
In this day and age with security and all, why does this Microsoft provided Windows Phone training kit default it’s installation path to the root?
Windows Home Server Add-in
Here in the UK we had a bank holiday yesterday which of course meant we had 3 days off. So I spent some time with the wife over the last few days and decided that I would embark on new … Continue reading
T-SQL: Calculate Hours, Mins and Secs from StartTime and EndTime
select sum(TotalSeconds) / 3600 as Hours, (sum(TotalSeconds) % 3600) / 60 as Minutes, sum(TotalSeconds) % 60 as Secondsfrom(select ArrivalTime, DepartureTime, DateDiff(second, ArrivalTime, DepartureTime) as TotalSeconds from SSRwhere CustomerID = 10) xThanks to this site for the heads … Continue reading
T-SQL Queries
I was trying to figure out how to get a T-SQL to allow a user to enter part of a name to query on, for example the user could enter ML, click a search button which would return all companies … Continue reading
