Hi ,

I found where i am getting error ,for each and every userid the below set statement is getting more than one row.

i.e. for userid =1 the usertoterritory table...

Jeff Moden (3/3/2010)

Yes,each procedure i am calling will insert the row into history table...

Hi,

I have created a procedure to do this and created a cursor inside a procedure.

I got it .

I am executing the procedure with execute as 'name'

looks like i don't have permission for the name i have given .

Thanks

I got it ...

here is what i am trying to do ,intially i am creating a procedure and inserting the values as 0,0,0.and later updating using updation criteria.

Yes it helped ,Thank you

Thank you

I have looked every where for this,

I want datetime to convert into varchar (ex:16-feb-10)

but i found convert(varchar, columnname , 6) which is converting into 16 feb 10..

can anyone help?

Structures are the same,

If i use first method do i lose the data in table A,since i want to add the rows from table B to table A.

Thanks a lot ..

I am sorry for my confusion.i got the results using the syntax thanks for that ...

My results are including the datefield column below(2010-01-01) ,Can you also tell me how...

hi,

it should fetch the next 3 months for my given date which is going to be a parameter in my stored procedure ,for whatever date we give it should fetch...

can anyone please give me any ideas on this topic it is tricky one from my side....

I am using this query to get the forecast that i can compare with forecast in history report which ran on oct 2009 .i am getting error arthematic flow since...