1 of 5

declaring cursor to loop over some values in SQL server 2008 R2

I am just new to sql and exploring google from last few days but unable to get the answers of my Query Can anyone help me with

How to declare a cursor that contains some values and then cursor should loop over the values. And for each value: i) Have to execute the procedure and insert the data into the table variable ii)And select particular columns from the table variable+timestamp and then inserting them into the another table.