var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is there a way to use wildcard characters...
to reference columns.
i have a table that has a column that is repeated 25 times, sort of.
tbl_c_1 char 5
tbl_c_2 char 5
tbl_c_3 char 5
tbl_c_4 char 5
tbl_c_5 char 5
tbl_c_25 char 5
everytime i want to query for any of tbl_c_? that contain a specific value i have to reference all 25 in my query. is there a better way?
I cannot change the table.
WHERE tbl_c_1 LIKE @x+'%'
AND tbl_c_25 LIKE @x+'%'
scan o ramma
The problem is not in your code. The problem is in your database design.
Your schema is not normalized. You need to store that data as separate records in a child table, rather than as distinct columns in the parent table. Then you search would be easy.
Ineffecient coding is often the result of poor design.
i agree with you on that but unfortunately the one who created this mess for me is no longer working here. he left here for a better paying job doing the same thing, go figure. i am currently in the process of cleaning up this mess, about 30 of the tables his did the same thing and it will affect about 250+ programs. i was just hoping for a quick/temporary fix in the mean time.
Thanks anyways all...
Why not correct the table, and then create a view
Could do that, but it would probably have to be an updatable view, as well as a crosstab, which means INSTEAD OF triggers, blah blah blah....
nah, ya think?
Well, ok...the margaritas are starting to kick in
Don't you feel bad for people stuck in these situations?
Oh wait, that's me