/* In isql utility program, select statement work with view and creating temporary table. */
1> select a.id, b.name, a.group_name, a.table_name, a.time
2> into c#list
3> from collect_list_v a, collection_v b
4> where a.id = b.id
5> go

1> select * from #clist
2> go

1> select grouplist.name from grouplist
2> where grouplist.name not like "[Kkdt]%"
3> and not exists
4> (select * from #clist
5> where #clist.group_name = grouplist.name)
6> go

How can select statements above be converted into stored procedure so that can run program once a month?