Any chance of some Tim magic so that derived table names eg

SELECT
_Forename + ' ' + _Surname + ' ('+X1+')',
_Surname + _Forename + CAST(COALESCE(_fkCompanies,0) AS VARCHAR(10)) +CAST(COALESCE(_fkSites,0) AS VARCHAR(10))
FROM (SELECT _Surname, _Forename, _fkCompanies, _fkSites, CAST (COUNT(*) AS VARCHAR(3)) AS X1
     FROM Career C1
     LEFT OUTER JOIN Contacts Who ON Who._ID = _fkContacts
     WHERE _Left IS NULL AND _Surname IS NOT NULL AND _Forename IS NOT NULL
     GROUP BY _Surname, _Forename, _fkCompanies, _fkSites
     HAVING Count(*) > 1) AS T1


can be query specific (without me having to rename them) to save having to alter the sql if I have several instances going at the same time?

Roy Lambert

Roy,

<< can be query specific (without me having to rename them) to save having
to alter the sql if I have several instances going at the same time? >>

You must have missed this post from me:

http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_sql&page=1&msg=3720#3720



--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>You must have missed this post from me:
>
>http://www.elevatesoft.com/forums?action=view&category=edb&id=edb_sql&page=1&msg=3720#3720


Nah. Just forgot it Anyway I'm stuck on b9 <vbg>

Roy Lambert