Recent content by andyiain

Thanks for the reponse but alas I'm on sql 2000 (at least for the next couple of months) and it's multiple rows that are constantly updated. I guess a lot of case statements may do the job but it seems to me to be an ugly way of doing things. I currently have four columns to check the highest...

Hi Is there any way to get the highest number in a row. If it was in a column I could just use max but how can I find out what the largest number for a record is across several columns. Any ideas kind people? Andy

Thanks for that, worked a treat. I've now found a few cases not in the format hours colon month but I think I can pretty easily remove these before running any queries.

Hi, I've got me a database where the developers included a total hours column as a varchar format. Specifically it's of the form: hours colon minutes e.g. 8:30 I need to add up these hours and so after a lot of messing around a searching this forum I found this method...

Hi I have a list of people and events they engaged in together with the date and location of the event. These range from one off events to a series of related events (of between a handfull and several hunderd individual dates) but in all cases the reference numbers are unique and there is...

Hi, I'm trying to pull out some data including some free text notes that people have typed in a notes field. Because it's free there's all kinds of rubbish in there including carriage returns and tabs. This is then a problem for me if I ever need to import this data in to Excel because the...

Hi, I have some gloriously unweildy sql (below) and what I'd like to do is not group it by some of the items it is grouped by. I'd like to have the aggregates of LEFT(qlup.description, Charindex (' ',qlup.description) - 1) only. How would I go about not having to group by...

Hi, I have a table of bookings with a person ID and all the details of the booking. I'm trying to find, for each ID what the most common booking type is, the modal booking type. I'd like this both for the information itself and to use as the criteria in other queries. Ideally (for my little...