Search results for query: *

nervmind, the max aggregate worked, where it wasn't working before. I missed one MAX in the setting and it screwed it all up. Thanks again for all the help!

The Lead_id is directly linked to a specific person.(The primary key on another table) They can elect what geographical interests they have when looking for a new home. For each choice they make, a new record is added to the lead_Interest table. The interest are located in one column, each...

if the starting Data looks like this: Lead_info Mountains Coast Lake River 1 yes 1 yes 1 yes 1 yes 2 yes 3...

I tried the group by option but that doesn't work. I end up with one record for each lead_id but lose all but one piece of geographical data.

I'm trying to develop a pivot table where the values from one row are put into separate columns on my output. My problem is not separating the vaules into columns, but rather, re-assmbling them into one record with a distinct key, because each row can have more than one selected value for the...

Im haveing a problem extracting the latest timestamp from a table where the only thing that may differentiate records is the timestamp. Name result timestamp gary busey 1 9/1/2010 14:14 gary busey 1 9/2/2010 14:14 Darth Vader 1 9/1/2010 14:14 Darth Vader 1 9/5/2010 14:14 gary busey 2...

I'm trying to insert a key value into the last field in the row (new_lead.) This is based on data that we have collected over time from clients. I keep having issues getting it to work. I'm not sure how to code it at this point, based on the error 'Error Code : 1248 Every derived table must...