The Script working in Sqlserver2017 version .Please see the attachment.

Many thanks for your reply Scratt..

One question the final script is above in the main page or the final one in the comment post #1808182 ?   I am able to...

• This reply was modified 5 years, 1 month ago by  smer. Reason: Modified Script to work with Sqlserver 2017 Version
• This reply was modified 5 years, 1 month ago by  smer.

Hi scratt ,

I am able to run the script but getting error May be does not support Sqlserver2017 , i tried this script on Sqlserver2008R2  the SP created in the Sqlserver...

• This reply was modified 5 years, 1 month ago by  smer.
• This reply was modified 5 years, 1 month ago by  smer. Reason: able to run the script but finding another errors
• This reply was modified 5 years, 1 month ago by  smer. Reason: Able to execute on 2008R2 but not 2017 Sqlserver

Lynn Pettis  the collation of tables was changed as i point in the post 1.

But the Sqlsever database Views are in different Collation any advise how to set those views...

• This reply was modified 5 years, 1 month ago by  smer. Reason: re-attached screenshot

Yes you are right  and I tired several times to change the collation but same results .

The same issue processed 0 page.  I am restoring the full backup  in standby/ read only mode .  

If you see  the column name  ( NAME )  there are two different names  NAME1 and NAME2   we have to calculate the totals based on  NAME1 and NAME2.
Find the...

Hi Thom A,
By using over clause  the results still not getting ok  , please find the results attachment.

Hi Experts
Here is the below  Table defined and insert statements.
     CREATE TABLE [dbo].[TEST](
    [ITEM] [char](32) NOT NULL ,
    [DATE_START] [datetime] NOT NULL ,
    [EndDate] [datetime]...

May be like that !

declare @ProcessDate datetime = '1/15/2015'; -- spaces added to allow code to be posted

select

--- dateadd(month, datediff(month, 0, mt.START_DATETIME), 0) as StartMonth,

...

Many thanks great work ....

The results displaying fiscal to month, please modify the code fiscal to date that will display only one row result.

Lynn Pettis ...

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