Stored Procedure Help.

[limester]

I am looking to create a stored procedure that will populate a text box depending on the result of a field. The field has many values and for each one it will require different text.

To query for the field I will need to join another table:

table1.field1 where table1.field2=table2.field2

If anyone can help me with a starting point to this it would be greatly appreciated.

thanks.

 

[Dashley]

limestr

The case statement should work for you.

SELECT    t.fieldstuff = 
        CASE type
            WHEN 'vAL1' THEN 'thisname'
            WHEN 'val2' THEN 'othername'
            WHEN 'Val3' THEN 'somename'
            ELSE 'return somthing else'
        END,

FROM Mytable T

WHere Bla Bla Bla

As far as you join you going to have to provide more info ... the table name and what fields you want

 

[limester]

Hi Dashley,

Thank you for your reply!

I think using a case statemnet is exactly what I need to do!

I will work on this and reply as to my success or failure.

Thanks again!

 

[Dashley]

Limester,


Thanks
Hope all goes well.