I've found the web to have allot of SQL syntax available, for example:
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=27

http://www.3gwt.net/demo/SQL_redux.html

http://whatis.techtarget.com/definition/0,,sid9_gci826135,00.html

Or one of my favorites:
http://www.sqldatabasetutorial.com/data/sqlcheetsheet.pdf

Simply map these cheat-sheets to Query commands, If you don't know 
QUERY.PUB.SYS, their's a manual for that on docs.hp.com

Mike.

Jim Chance wrote:
> I'm seeking quick notes, cheat sheet, cross reference list of common HP3000 query commands to MS T-SQL commands to provide to someone who has done HP3000 query/COBOL/JCL development for 20 yerars and what the equivalent is - command/statement wise within the MS SQL server 2k/2k5/2k8 query analyzer/SSMS wolrd. 
>  
> Do any of you have such a cross reference list, or know of where or from whom I could obtain one? 
>  
> Thanks. 
>
> Jim Chance, DBA Practical Technology Solutions Founder
> Ashland, Ohio, 44805
> Cell: 419-651-6704
> Fax: 732-601-6704
> [log in to unmask]
> www.practical-technology-solutions.com
>
> A+, PMP Certified, IT purveyor since 1985. SQL Server, Crystal, Project Management, HP3000, UNIX, Migrations/Conversions, ERP expert. 
>
> Rent our condo in sunny warm Estero, Florida:
> http://www.vacationrentals.com/vacation-rentals/23683.html
>
>
>       
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>   


-- 
Michael Anderson,
J3k Solutions
Sr.Systems Programmer/Analyst
832.515.3868

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *