Nov 09, 2011, 8:53 PM
Dynamic Column names
hey guys
i'm running a query that sets column names at run time, and i'm kinda at a loss as to how to setup the columns,
here's a section of my query
i'm running a query that sets column names at run time, and i'm kinda at a loss as to how to setup the columns,
here's a section of my query
SELECT
district.`name`,
(SELECT
COUNT(NETWORK)
FROM
ACTHIST AS table3
INNER JOIN abc_development.`stores` AS table1
ON CONVERT( table1.`cellsell_id` USING utf8 ) = CONVERT (table3.`STORE_ID` USING utf8)
INNER JOIN abc_development.`districts` AS table2
ON table2.`id` = table1.`district_id`
WHERE table3.NETWORK IN ('V24', 'VU24', 'VIPNEW', 'VIPUP')
AND table3.ACT_DT BETWEEN '2011-09-1'
AND '2011-09-30' AND table2.name = district.name) AS '" +month1name+"'",
since month1name is being set at runtime, how do i set it up in the aspx section ...Any help will be greatly Appreciated. Thanks
Last edited by Daniil; Nov 11, 2011 at 9:40 AM.
Reason: Please use [CODE] tags