Two queries

Enthu

Can anybody tell me how to set value of output variable of stored procedure to a tuple value in data deploy. We are trying to get a unique ID from the database by calling a stored procedure which increments a column in the table and then returns it as New ID. I need to set the value of new id to one of my tuple in root-group.

second, can we use group based filter. We are having couple of parent-child groups. say group A is parent group and group B is child. many a times our child group has no values but since it has 2 foreign key from group A and all values in child group are not null. many a times we don't any values for child group. Is their any way to simply discard the whole group.

Enthu

Attaching sp_deployment file here. How can I set value of output parameter in stored procedure(myproc).

Is it possible to set value of output variable as value of column TYPE_ID of group ARTICLE_TITLE?