Database

SELECT g.GenerationId,
	d.Fitness,
	d.RecordId
FROM
(
	SELECT DISTINCT GenerationId
	FROM [Source]
) AS g
	CROSS APPLY
	(
		SELECT TOP 1 s.RecordId, s.Fitness
		FROM [Source] AS s
		WHERE s.GenerationId = g.GenerationId
		ORDER BY s.Fitness DESC
	) AS d
ORDER BY g.GenerationId ASC

select  p_id, 
        p_name, 
        p_path,
        case when uw.username is not null then uw.username 
             when um.username is not null then um.username 
             else null
        end creator,
        uw.username,
        um.username
from    pics
left join usersmobile um
    on  pics.p_userId_mobile = um.p_userId_mobile
left join  UsersWWW uw
    on  pics.p_userId_www = uw.p_userId_www

Image
  imageid PK
  name
  path

users /*only one usertable*/
  userid PK
  username

accesstype
  accesstypeid PK
  accesstype  /*www and mobile*/

useraccess
  useraccessid PK
  userid       FK
  accesstypeid FK

unique key (userid,accesstypeid)

imagecreated
  imagecreatedid PK
  imageid        FK
  useraccessid   FK
  createdate

unique key (imageid,useraccessid) /*an image can only be created once*/

imagechanged
  imagechangedid PK
  imageid        FK
  useraccessid   FK
  changedate

andreas.schaerer wrote:

that triggers would do the job just fine

netJP12L wrote:

First name is John and there is no last name then upon concatanting both names i get null.

netJP12L wrote:

I have set the database "Concatenate Null yeilds Null" to True

poornas wrote:

hope you understood my requirement.