Post reply

Dynamic insert into a table from Stored Procedure

  • February 10, 2012 at 4:58 am

    #264364

    I need a way to format the expression like ((A or B) and C) or D and insert into the table(S_No, Expression1, Expression2, Operator) as

    1 D ((A or B) and C) or

    2 C (A or B) and

    3 A B or

    Pls some one help on this

  • February 10, 2012 at 6:01 am

    #1445495

    I don't understand exactly what you're after.

    Can you post an example with some sample data and the destination table definition?

    Read the article linked in my signature line and you will find out how to post on the forums to get quick answers to your questions.

    -- Gianluca Sartori

  • February 10, 2012 at 6:14 am

    #1445504

    I have stored procedure which has two parameter

    P1 ----- ((A or B) and C) or D

    P2 ----- A, D

    In this case it should return true.

    Check the P1 and P2 value and also the 'and ' or 'or' variable.

  • February 10, 2012 at 6:39 am

    #1445513

    I don't get it.

    Did you read the article I mentioned?

    Code, please.

    -- Gianluca Sartori

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply