its differences like stored procedure returns 12.9% excel places it as 13.1%

I am just pulling the data from stored procedure, if i execute same from excel i am getting variation in data. is there some thing I need to do in...

In stored procedure we are using numeric(38,2), will it make difference?

Hi,

Here adjacent records means consecutive date/days or consecutive months??

Surya

Here is another solution CTE and this is more genric than earlier solution

create table #Example

(

Company varchar(10),

Empno int,

Id int,

CourseId int,

Startdate datetime,

Stopdate ...

Hi,

Hopefully i understood ur problem well

Here is the solution

create table #Example

(

Company varchar(10),

Empno int,

Id int,

CourseId int,

Startdate datetime,

Stopdate datetime

)

insert into...

HI Jeff,

Thank you for your kind suggestion and help. Actually i am not using periods table its TIME Dimension and in IncomeStatement table i have no date i will stored...

Hi,

I got my problem solved by both Jeff and Chris solutions. I followed Jeff solution.

Thanks to all of you who spend their valuable time to me. I am...

I need to insert into #IncomeStatement if a account in a department does not have any entries for a month both credit and debit as '0'

Yeah the assumption is correct. I need to calculate if a transaction either credit or debit exists for each account in the department

My Sincere apologies for my faulty sample data . I am thankful to you all for your valuable time to provide me solution. I will give try for the solutions...

I guess u need change the column data type to text or ntext if your using sql server 2005 onwards

Hope this will solve ur problem

Thanks,

Surya

Hi Jeff,

Yeah i found the link. Once again thanks for your kind help.

Thanks,

Surya

Hi Jeff,

Thanks a ton for your kind help. Its working. Could you please explain a bit about quirky update So that i can reuse this when ever i need...

Hi Jeff,

I am able to carry forward ending balance to opening balance of next month, but ending balance of current month is being calculated properly.

Could you please help me in...