Lynn Pettis ...

Exactly ! this is my requirement. Is this code works on fiscal year to date start from July to June?

Thanks Lynn Pettis for your code...

code showing many rows . It is possible to have one row result year to date ,only i have to pass the @processdate and...

Experts !

Below iam posting the table, sample insert and query ,which i am using. I need when ever i give the end date like '1/7/2014' the results comes from...

Thank you !

I tried this as you advised below but how to count the no of days in fiscal year to date?

SELECT

DATEADD(MONTH, DATEDIFF(MONTH, 0, service_date) - (12...

Dear

I have already post the insert/create table results excel file in winrar compress folder . I don't know. Why people afraid to open that it is not a explosive...

Hi Sean/ Luis

What's the final solution ?

Hi Sean,

Do not be scary some time knowing is not important but trust !

For future about output column F & G in excel having calculation results.

Hi Sean,

Thanks

Please find in the attachment Create Table.sql,Insert Script.sql and sample new.xlsx ( contains results).

I hope not miss any thing.

Hi Sean

First of all I apologized may be my way of writing not correct !

Actually data is already inside database I want to write the sql query to get the...

Hi Experts !

Actually the data inserted in attached screenshot , I need to make a query to use this data to get Column F & G results...

Hi

You mean the below table script?

In spread sheet the data and time is separate, yes I want to show it separately. The date and time is together in...

Hi

Please find attached the picture. I am new this is my first time to make any graph in reporting services.

My requirement

2) add to db1 any data in db2 thats not in db1

Yes this is production database but please suggest if i go offline will the data mirroring from...

Yes all the tables have a primary key. Actually both databases are same needs to merge db2 data to db1.

Thank you...

It works for me.

Great