Click here to Skip to main content
15,888,521 members

Comments by saberbladez (Top 4 by date)

saberbladez 18-Jun-13 21:30pm View    
Hi cigwork,

The 'sOutlet' is a "dynamic column" which means that each time a new outlet is opened, there will be a new column. Example: existing outlets are sOutlet1, sOutlet2, sOutlet3. so if there is a new outlet opened, a new column will be created for the outlet, being sOutlet4. hence I am having the issue of mapping my row data to the columns itself
saberbladez 17-Jun-13 22:52pm View    
yea thought of that, but it's causing some performance issue, it's taking 3-4s for 1 query to be done, i am thinking of there is an alternative for this as we will be querying for 30outlets for now, in time to come maybe there will be 50outlets which will be another issue
saberbladez 17-Jun-13 22:52pm View    
Deleted
yea thought of that, but it's causing some performance issue, it's taking 3-4s for 1 query to be done, i am thinking of there is an alternative for this as we will be querying for 30outlets for now, in time to come maybe there will be 50outlets which will be another issue
saberbladez 17-Jun-13 22:39pm View    
Hello I have ammended my question maybe it will be clearer now :)