See the questions is i dont want to pass any input parameters in the stored procedure which you suggested

Thanks a lot for the suggestion it worked

Thanks it worked

Hi,

   i agree with you and i try to ask question only after iam stuck otherwise itry to resolve it myself becz i think that is the real...

IF YOU DONT WANT TO ANWSER SIMPLY DONT REPLY PLEASE OK .LET OTHERS HELP ME  BECAUSE I GUESS THERE ARE STILL SOME PEOPLE IN THIS WORLD WHO HELP OTHERS WITHOUT...

yes i need  a stored procedure which accepts parameters building_id, assessed_date, and assessed_value as parameters and create a record in table C.

can you tell me how i can do that.

thanks

OK,

  I guess it is getting ConFUSING. let me tell you the solution and i just want to know whether iam on the right track or not.

Inthis case what iam...

The information above shows For example electricity cost for  three year for every month and thats it.That is all information i have .

i did tried the suggestion stated in the above post but it never worked as it does not get into the while loop.

Any Suggestions

Thanks

----------------------------

declare

@startret