Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
Derived table names |
Fri, Mar 26 2010 10:02 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Mar 26 2010 2:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Mar 27 2010 10:05 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |