Thank You, for the reply - This is the realy query
and it executes for 3 - 4 seconds.
<cfquery name="get_info" datasource="#dbsrc#" dbtype="#dbtype#">
Select
Distinct
rtrim(Node1.Attrib_Code_Descr) as Node1
,rtrim(Node4.Attrib_Code_Descr) as Node4
,rtrim(Cust_Code_Srce) as Code
,rtrim(Cust_Name) as Descr
,rtrim(Cust_MerchCo_CustomerNo) as Descr6
,rtrim(CustGroup_Description) + ' (' + rtrim(Cust_MerchCo_CustGroupCode) + ')'
as Descr8
,rtrim(Regn_Merch_Region_Descr) + ' (' + rtrim(Cust_MerchCo_Region_No) + ')' as
Descr9
,rtrim(Reps_Merch_Rep_Descr) + ' (' + rtrim(Cust_MerchCo_Rep_No) + ')' as
Descr10
from dbo.MIS_Corp_Customer_Master
<cfif R_RepOutput EQ "Add">
left
</cfif>
<cfif R_RepOutput EQ "Remove">
inner
</cfif>
join dbo.MIS_Merch_Customers
on Cust_DB = Cust_DatabaseCode
and Cust_Code_Srce = Cust_MerchCo_CustomerNo
and Cust_MerchCo_No = '#T_SubUnitCode#'
left join dbo.MIS_Attribute_Master Node4
on Node4.Attrib_ID = 'NODE'
and Cust_Node_Level_4 = Node4.Attrib_Code
left join dbo.MIS_Attribute_Master Node1
on Node1.Attrib_ID = 'NODE'
and Cust_Node_Level_1 = Node1.Attrib_Code
left join dbo.MIS_Merch_CustGroups
on Cust_MerchCo_No = CustGroup_MerchCo_No
and Cust_MerchCo_CustGroupCode = CustGroup_MerchCoCustGroupCode
left join dbo.MIS_Merch_Regions
on Cust_MerchCo_No = Regn_MerchCo_No
and Cust_MerchCo_Region_No = Regn_MerchCo_Region_No
left join dbo.MIS_Merch_Reps
on Cust_MerchCo_No = Reps_MerchCo_No
and Cust_MerchCo_Rep_No = Reps_MerchCo_Rep_No
where Cust_DB = 'BPL'
and Cust_Code_Srce = Cust_Code_Srce
order by
rtrim(Node1.Attrib_Code_Descr)
,rtrim(Node4.Attrib_Code_Descr)
,rtrim(Cust_Name)
</cfquery>
<table>
<cfoutput query="get_info">
<tr>
<td>#Code#</td>
<td>#Descr#</td>
<td>#Descr8#</td>
<td>#Descr9#</td>
<td>#Descr10#</td>
</tr>
</cfoutput>
</table>
Please help!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278424
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
