Good Morning, Sorry for the off-topic post
I have a complex SQL statement that I am trying to write, and need a little help. I have a table with three field, employee, action, and value. I want to make a crosstab view, with the value of action being the column names, and the values of value being the column data I know I can do this by hard coding the action values into a view, but I am wondering is there is a way to dynamically create this, so I do not need to modify it when additional actions are added to the process Any help is appreciated Thanks in advance Dave Sueltenfuss Application Developer Certified ColdFusion MX Developer Arch Wireless Phone: 508-870-6711 Fax: 508-870-8011 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4