Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SELECT TC.Name,TM.Type,TM.width,TC.N2NAME,TC.ACTUALNAME,TC.APORTNAME,TC.ZPORTNAME, TC.CircuitType ,TC.C2CTypeName,TC.C2CBandwidth,TM.Coverage, TM.CITY,
Count(1) CNT,SEQ,USAGE
FROM
Uc.master as TM,
UC.tmcircuit AS TC
GROUP BY Name,TM.Type,
N2NAME,ACTUALNAME,TC.APORTNAME,TC.ZPORTNAME, CircuitType ,
C2CTypeName,TC.C2CBandwidth,TM.Coverage, TM.CITY,SEQ,USAGE
my problem is COUNT function..........
Put Before SQL
SQL SELECT
TC.Name,
TM.Type,
TM.width,
TC.N2NAME,
TC.ACTUALNAME,
TC.APORTNAME,
TC.ZPORTNAME,
TC.CircuitType,
TC.C2CTypeName,
TC.C2CBandwidth,
TM.Coverage,
TM.CITY,
Count(1) CNT,
SEQ,
USAGE
FROM
Uc.master as TM,
UC.tmcircuit AS TC
GROUP BY TC.Name,
TM.Type,
TM.width,
TC.N2NAME,
TC.ACTUALNAME,
TC.APORTNAME,
TC.ZPORTNAME,
TC.CircuitType,
TC.C2CTypeName,
TC.C2CBandwidth,
TM.Coverage,
TM.CITY,
SEQ,
USAGE;
Best Regards.
Tonial.
i need to write that procedure in the form of QV script. and also i need to load that data from "master.qvd" and "tmcircuit.qvd"
Try this:
Master:
LOAD *, 1 AS CNT FROM master.qvd (qvd);
Inner Join (Master)
LOAD * From tmcisrcuit.qvd(qvd);
Best Regards.
Tonial.