optimize the code

Question

Hi ,

I am prachi kulkarni i  want to optimize some code for that i want to write sql procedures which will return dataset with 2tables.How can i go about it or please suggest me some other solutions i want to reduce looping .

I want to do database group by and count queries into temp tables to create a simple dataset which can be used directly.

How to achieve the required thing?Please suggest me way. 

 

Prachi