waterye

Feedback

# re: Online Format SQL 2006-01-24 16:58 大嘴巴

老兄，有沒有這樣的API？
誰有的話發給我好嗎？ come2u at gmail
謝謝  回復  更多評論   

# re: Online Format SQL 2006-01-24 17:09 Water Ye

SQL source formatter ant task

http://www.it-eye.nl/weblog/2006/01/02/sql-formatter-ant-task/  回復  更多評論   

# re: Online Format SQL 2007-04-05 18:20 asdasd

SELECT MYTABLE.PARENT_COMPANY_ID AS COMPANY_ID, CO2.NAME,
CT.COMPANY_TYPE_NAME, CST.COMPANY_SUB_TYPE_NAME, MYTABLE.DOC_COUNT
FROM
(
SELECT CO.PARENT_COMPANY_ID, COUNT(DISTINCT CN.CONTACT_ID) AS DOC_COUNT
FROM TBLCOMPANY CO, TBLCONTACTCOMPANYADDRESS CCA, TBLCONTACT CN
WHERE CO.COMPANY_TYPE_ID IN (12,16,20,22,23,25,26,28) AND
CO.COMPANY_SUB_TYPE_ID IN (2,3,9,10) AND
CO.ACTIVE = '1' AND
CCA.COMPANY_ID = CO.COMPANY_ID AND
CCA.ACTIVE = '1' AND
CN.CONTACT_ID = CCA.CONTACT_ID AND
CN.ACTIVE = '1' AND
CN.SPECIALITY_ID IN (27, 64, 98, 12, 32)
GROUP BY CO.PARENT_COMPANY_ID ) MYTABLE,
TBLCOMPANY CO2, TBLCOMPANYTYPE CT, TBLCOMPANYSUBTYPE CST
WHERE CO2.COMPANY_ID = MYTABLE.PARENT_COMPANY_ID AND
CO2.COMPANY_TYPE_ID = CT.COMPANY_TYPE_ID AND
CO2.COMPANY_SUB_TYPE_ID = CST.COMPANY_SUB_TYPE_ID
ORDER BY CO2.NAME ASC  回復  更多評論