Nov 12, 2010 05:34 PM|dezwartemaan|LINK
I have a similar issue, but in a different view. I'd like to capture data for a report, but the people who built this table made it dynamic. text0-text9, rowindex, and a projectID.
I dont consider this to be a prudent practice myself, but the code is meant to be dynamic for entry.. just a pain in the rear to report it. :(
select projID, text0 as Text0A, text0 as Text0B...etc
Yes I know this isnt the right code. This is liekly to be two select scripts with rowindex=max(rowindex) and a Loop to decrement to 0, then renaming all Text0-9 in Rowindex 1 to be Text#A and so on. I just showed this to sortof give an idea of what i'm shooting
I think I can create 2 select scripts with the same identity number, and then merge/join them as one Query.
but.. for the life of me.. I cant seem to get this to work. :(