Thanks for your help :-):-)

there is foreign key constraint

ive been thinking a lot.

Can someone help me out ?

There are 5 conditional variables.

Not all apply to all alerts.

conditional variables are:

- @subledger_name

- @cost_centre

- @rate

- @amount

- @JobOrder

Only rate and amount go together all other are independent.

Alert is generated for 1...

Yes, currently i have nested replaces for all possible variables.

And currently alert messages are defined in procedure.

That's why i want to make alerts dynamic because new alerts are defined on...

I have attached variables list. User can select any variable from this list

This is a good example but unfortunately there are many many alerts with different messages. Therefore i have to stick to input string in generic string in alert_types table.

Thanks for your detailed response.

But let me add some info.

I have a table for alert registration (Alert_types). Then alerts are generated from document table and stored in alert_que table.

The process...

its a simple insert into statement

insert into Alert_Types

values (1,'document_detail_view','Document ID: @document_id

Customer Name: @customer_name

Item name: @item_name

Quantity: @qty')

before forwarding to webservice i recall the body in a variable

is there a way so that i can use it against views ?

Exactly what i was looking for!

Thank you.:-)

Set @job_order = Rtrim(Ltrim((SELECT job_order FROM #trig)))

i used this statement just for example

consider it can handle multiple values.

i dont want to handle code for inserted and deleted separately.

and i dont...

job_order is primary key so always single value:

Set @job_order = Rtrim(Ltrim((SELECT job_order FROM #trig)))