Jurgen's Blog

Merry x-mas and a happy new-year

2011-12-23T10:11:00.002+01:00

I would like to wish you all the best for 2012!

A view on storing file data in SQL Server

2011-11-04T14:59:00.001+01:00

Storing file data (BLOBs) (eg. pdf, word, excel ...) in SQL server always has been some kind of dark magic to a lot of people.

Before SQL Server 2008 we could store the BLOB data in VARBINARY(MAX) datatypes, in which you also had to convert the BLOB data into the binary format yourself ...

With SQL 2008, the FILESTREAM datatype was introduced. FILESTREAM enables us to integrate SQL Server with the NTFS file system ... BLOBs are stored as real files on the file system.

More on FILESTREAM: http://msdn.microsoft.com/en-us/library/bb933993.aspx

--Enable FILESTREAM

EXEC sp_filestream_configure @enable_level = 3;

--CREATE THE TABLE

CREATE TABLE TestFS

(

ID INT IDENTITY(1,1),

FileName NVARCHAR(200),

Content VARBINARY(MAX) FILESTREAM

)

As from the new version of SQL Server, SQL 2012 (aka 'Denali'), a new feature has been introduced ... FILETABLE, based on the existing FILESTREAM feature in SQL Server. In fact, the FILETABLE feature is nothing more than storing files in special filetables in SQL server, but you will be able to access them from the file system. It is said that FILETABLE will be the next generation of FILESTREAM ...

More on FILETABLE: http://msdn.microsoft.com/en-us/library/ff929144(v=sql.110).aspx

--Create the table

CREATE TABLE DocumentStore AS FILETABLE

WITH (

FileTable_Directory = 'DocumentTable'

FileTable_Collate_Filename = database_default

);

GO
Have fun
Jurgen

SQL Server Denali - LAG and LEAD

2011-09-15T09:20:00.000+02:00

This is a short post on 2 new T-SQL features called LAG and LEAD, they are kind like Bonny & Clyde, they are mentioned in the same phrase...

LAG and LEAD accesses the data from respectively the previous and the next row in a table without using self joins.

Syntax:

LAG (scalar_expression [,offset] [,default])
OVER ( [ partition_by_clause ] order_by_clause )

LEAD (scalar_expression [ ,offset ] , [ default ] )
OVER ( [ partition_by_clause ] )

USE
AdventureWorks2008R2

GO

SELECT TerritoryName, BusinessEntityID, SalesYTD,

LAG (SalesYTD, 1, 0) OVER (PARTITION BY TerritoryName ORDER BY SalesYTD DESC) AS PrevRepSales

FROM Sales.vSalesPerson

WHERE TerritoryName IN (N'Northwest', N'Canada')

ORDER BY TerritoryName;

SELECT BusinessEntityID, YEAR(QuotaDate) AS SalesYear, MONTH(QuotaDate) AS SalesMonth, SalesQuota AS CurrentQuota, LEAD(SalesQuota, 1,0) OVER (ORDER BY YEAR(QuotaDate), MONTH(QuotaDate)) AS NextQuota

FROM Sales.SalesPersonQuotaHistory

WHERE BusinessEntityID = 275 and YEAR(QuotaDate) IN ('2005','2006');

Have Fun!

New Date and Time functions in "Denali" CTP3

2011-07-19T10:10:00.000+02:00

I've been playing around with the CTP3 of Denali and stumbled upon some new functions...

The new functions are :

DATEFROMPARTS(@year, @month, @day)

returns a DATE value

DATETIMEFROMPARTS(@year, @month, @day, @hour, @minute, @seconds, @milliseconds)

returns a DATETIME value

TIMEFROMPARTS(@hour, @minute, @seconds, @fractions, @precision)

returns a TIME value
where @fractions is an integer expression and @precision is an integer literal specifying the precision of the time value to be returned.)
@fractions depend on @precision eg if the precision is 7 then each fraction represents 100 nanoseconds.

Remarks:

If the arguments are invalid, then an error is raised
If any of the parameters are null, null is returned

Some Examples:

SELECT DATEFROMPARTS(2011, 07, 20) AS 'Todays Date'

SELECT DATETIMEFROMPARTS (2011, 07, 20, 09, 51, 07, 321) AS 'Todays Date and Time'

SELECT TIMEFROMPARTS (09, 51, 07, 321 , 3) AS 'Todays Time'

have fun,
Jurgen

redgate's Sqlinthecity

2011-07-04T10:32:00.003+02:00

On July 15th 2011 I will be attending the SqlInTheCity event of Red-Gate.

Stand out from the crowd with Microsoft technology

2011-05-09T12:52:00.000+02:00

Execute a stored procedure on SQLServer Startup

2011-04-21T15:35:00.002+02:00

For a project we needed to run some T-SQL scripts when the SQL Express Database Engines on the client machines started (we need to have data available offline).
To get the job done, SQL Server has the possibility to execute a stored procedure at it's startup.

For this you will need to execute:

1: sp_procoption  @ProcName  =  'stored procedure name',

2:               @OptionName  =  'startup',

3:               @OptionValue  = 'on'  

4:

To turn it off again:

1: sp_procoption  @ProcName  =  'stored procedure name',

2:               @OptionName  =  'startup',

3:               @OptionValue  = 'off'  

4:

To see which procedures will be executed at startup:

1: SELECT  Name

2: FROM  sysobjects

3: WHERE  objectproperty(id, 'ExecIsStartup' )  =  1

4:

Have fun
J.

SQL Server to Active Directory

2011-04-05T10:50:00.000+02:00

A few days ago, I needed to access the Active Directory to get a list of users into a database. When I was looking out for a solution I stumbled upon the following solution, which is pretty simple to use in SQL Server:

1. Create a linked server

EXEC master.dbo.sp_addlinkedserver @server = N'ADSI', @srvproduct=N'Active Directory Services 2.5', @provider=N'ADsDSOObject', @datasrc=N'adsdatasource'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ADSI', @useself=N'True', @locallogin=NULL, @rmtuser=NULL, @rmtpassword=NULL

2. Query your active directory

SELECT * FROM OPENQUERY (ADSI, 'SELECT userPrincipalName, displayName, distinguishedName,

sAMAccountName, mail, company, accountExpires, whenCreated

FROM ''LDAP:///OU=myou,OU=myou2,OU=myou3,DC=myDC,DC=myDC2''

WHERE objectCategory = ''Person'' AND objectClass = ''user''

AND NOT accountExpires=0

AND NOT company = ''a company name''

ORDER BY company')

There is one drawback however, by default you can only get the first 1000 records from your active directory, but no worries, there is a workaraound! Follow this link to see the solution

Have fun!

Microsoft recognized by Gartner as a Leader in Business IntelligenceMicrosoft recognized by Gartner as a Leader in Business Intelligence

2011-01-30T09:17:00.000+01:00

Microsoft recognized by Gartner as a Leader in Business Intelligence based on “Ability to Execute” and “Completion of Vision”

Read more on the blog of Micorsoft Business Intelligence

Ontdek Vlaanderen's bekendste kantoor...

2011-01-26T10:31:00.001+01:00

Print Xaml in background - Part2 - the PrintTicket

2011-01-21T16:26:00.003+01:00

Following my previous post on Printing Xaml code to XPS, here's the second part.
In this part, I explain how to attach "Page Settings" to the XpsDocument. This can be done by using the System.Printing.PrintTicket in your code.

In my example, I print to A3, landscape.

Define the printticket

1:private  static  PrintTicket  pt = new  PrintTicket ();

Fill it with the necessary data:

1:PrintQueue  pq = LocalPrintServer .GetDefaultPrintQueue();

2:

3:pt = new  System.Printing.PrintTicket

4:             {   OutputColor  = OutputColor .Color,

5:                 PageMediaType  = PageMediaType .Plain,

6:                 PageOrientation  = PageOrientation .Landscape,

7:                 PageMediaSize  =

new PageMediaSize(PageMediaSizeName .ISOA3),

8:                 PageBorderless  = PageBorderless .Borderless

9:             };

10:System.Printing.ValidationResult result =

pq.MergeAndValidatePrintTicket(pq.UserPrintTicket, pt);

Code the printing itself:

1: XpsDocument  document =

2:         new  XpsDocument (path + @"\\sample.xps" , System.IO.FileAccess .Write);

3: XpsDocumentWriter  writer =

4:     XpsDocument .CreateXpsDocumentWriter(document);

5: writer.WritingPrintTicketRequired +=

6:         new  WritingPrintTicketRequiredEventHandler (writer_WritingPrintTicketRequired);

7: writer.Write(myfixedDocumentToPrint, pt);

And finally the writer_WritingPrintTicketRequired function

1: static  void  writer_WritingPrintTicketRequired(object  sender,

2:                         WritingPrintTicketRequiredEventArgs  e)

3: {

4:     e.CurrentPrintTicket = pt;

5: }

Have fun...

Print Xaml in background

2011-01-14T16:00:00.001+01:00

Printing Xaml (WPF) files in background? Is it possible? Yes, and it's easy!

The following code example will show you how.

Step 1: Create a console application

Step 2: Add references to ReachFramework.dll and WindowsBase.dll

Step 3: Create a xaml usercontrol

Step 4 Create your code in you main function

Xaml user Control example:

1: <Border BorderThickness="1" Height="57" Margin="12,37,267,0" Name="border1" VerticalAlignment="Top">

2:     <Border.BorderBrush>

3:         <LinearGradientBrush EndPoint="1,0.5" StartPoint="0,0.5">

4:             <GradientStop Color="#FFF10202" Offset="0" />

5:             <GradientStop Color="#FF0CDEED" Offset="1" />

6:         LinearGradientBrush>

7:     Border.BorderBrush>

8:     <StackPanel Orientation="Vertical" HorizontalAlignment="Stretch" VerticalAlignment="Center">

9:         <CheckBox Content="Test checkbox 1" Height="16" Name="checkBox1" Margin="5,0" BorderThickness="0" BorderBrush="{x:Null}" />

10:         <CheckBox Content="Test checkbox 2" Height="16" Name="checkBox2" Margin="5,0" IsChecked="True" BorderThickness="0" BorderBrush="{x:Null}" />

11:     StackPanel>

12: Border>

13: <Label Content="This is a test of printing to an XPS Document" Height="28" HorizontalAlignment="Left" Margin="12,1,0,0" Name="label1" VerticalAlignment="Top" Width="479" FontWeight="Black" Foreground="#FF0000E1" />

14: <Image Height="200" HorizontalAlignment="Left" Margin="244,76,0,0" Name="image1" Stretch="Fill" VerticalAlignment="Top" Width="247" Source="/WpfApplication;component/Images/Penguins.jpg" />

15: <TextBox Height="200" HorizontalAlignment="Left" Margin="12,99,0,0" Name="textBox1" VerticalAlignment="Top" Width="224" Text="Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum." TextWrapping="Wrap" BorderBrush="{x:Null}" />

16: <Rectangle Height="1" HorizontalAlignment="Left" Margin="5,30,0,0" Name="rectangle1" Stroke="Black" VerticalAlignment="Top" Width="485" />

17:

Main fucnction code:

1: FixedDocument  myfixedDocumentToPrint = new  FixedDocument ();

2: FixedPage  myPageToPrint = new  FixedPage ();

3: PageContent  pc = new  PageContent ();

4: PrintPage  printpageXaml = new  PrintPage ();

5:

6: myPageToPrint.SnapsToDevicePixels = true ;

7: myPageToPrint.VerticalAlignment =

8:     System.Windows.VerticalAlignment .Stretch;

9: myPageToPrint.HorizontalAlignment =

10:     System.Windows.HorizontalAlignment .Stretch;

11: myPageToPrint.Height = 11.69 * 96;

12: myPageToPrint.Width = 8.27 * 96;

13:

14: myPageToPrint.Children.Add(printpageXaml);

15: ((IAddChild )pc).AddChild(myPageToPrint);

16: myfixedDocumentToPrint.Pages.Add(pc);

17:

18: var  assembly = System.Reflection.Assembly .GetExecutingAssembly();

19: var  path = assembly.Location.Replace(assembly.ManifestModule.Name, "" );

20:

21: XpsDocument  document =

22:     new  XpsDocument ( path + @"\\sample.xps" , System.IO.FileAccess .Write);

23: XpsDocumentWriter  writer =

24:     XpsDocument .CreateXpsDocumentWriter(document);

25: writer.Write(myfixedDocumentToPrint);

26: writer = null ;

27: document.Close();

28:

Important remark: you function has to be STAThread.

You see, nothing difficult about this one ... have fun.

Writing a recursive query using Common Table Expressions

2010-11-24T09:46:00.010+01:00

In our following example, 2 tables are linked to each other.

The product table is linked to the category table. In the category table, categories can have several levels of parent-child relations.

For examaple:
The category table can contain:

Food -> Beverages -> Beer

Food -> Beverages -> Sodas -> Cola

The Product table however can contain:

Duvel -> Beer

How to get the products and their corresponding category fast, by defining the root category as a parameter?

You can do this with a recursive query using CTE (common table expresssions)

Our category table and product table:

The common table expression which will return all items for category 'Food'

1: WITH  RecursiveQuery  AS

2: (

3:  SELECT   c1.ID,  c1.Category  ,  CAST(  AS  NVARCHAR( 50))  AS  Parent  ,  0 AS  Level  ,  c1.ParentCategory

4:  FROM     Category  c1

5:  WHERE    c1.ParentCategory  IS  NULL

6:   AND  c1.Category  =

7:  UNION  ALL

8:  SELECT   c2.ID,  c2.Category  ,  RecursiveQuery.Category  AS  Parent  ,  Level  +  1 AS  Level,  c2.ParentCategory

9:  FROM     Category  c2

10:  JOIN  RecursiveQuery  ON  RecursiveQuery.ID  =  c2.ParentCategory

11: )

12:

The select statement returning the products with their respective category based upon the main category 'Food'

1: SELECT   Category,

2:   ISNULL(Products.Product  ,  )  AS  Product,

3:   ISNULL(Products.UnitPrice,  0)  AS  UnitPrice

4: FROM     RecursiveQuery

5: INNER  JOIN  Products  ON  Products.CategoryID  =  RecursiveQuery.ID

6: ORDER  BY  Level  ,Parent,  Category

7:

See the result:

Have Fun!

SQL Server Day 2010

2010-11-23T14:32:00.002+01:00

Thursday, December 2nd, 2010.
San Marco Village in Schelle (Antwerp)

Book those calendars now!

Export Excel sheet to PDF document using Aspose

2010-02-04T15:02:00.006+01:00

Last month I stumbled upon a business issue, which would allow an application to extract a single worksheet out of an excel document and save it as a PDF document.

Using Aspose, this can be done easily!

public class XlsToPdf
    {
        public void ExportSheet()
        {

            ///lets say we have an xls document containing 6 sheets
            ///each strongly named like sheet1 => sheet6
            ///suppose that you need to save sheet5 as a pdf document.

            string sourceWorkBook = "source.xls";
            string destinationDocument = "Destination.pdf";

            Aspose.Cells.Workbook sourceWb = new Aspose.Cells.Workbook();
            sourceWb.Open(sourceWorkBook);

            foreach (Aspose.Cells.Worksheet workSheet in sourceWb.Worksheets)
            {
                if (!workSheet.Name.ToUpper().Contains("sheet5"))
                    workSheet.IsVisible = false;
            }


            ///First thing to do is to save the xls in xml format, 
            ///but the formattype used already refers to PDF
            string destinationDocumentXml = "destination.xml";
            sourceWb.Save(destinationDocumentXml, 
                Aspose.Cells.FileFormatType.AsposePdf);


            Aspose.Pdf.Pdf pdfDocument = new Aspose.Pdf.Pdf();
            //bind the created xml to the PDFDoc you intialized.
            pdfDocument.BindXML(destinationDocumentXml, null);
            //Save...
            pdfDocument.Save(destinationDocument);

            ///If necessary, you can cleanup and remove 
            ///the intermediate files created
            ///using DirectoryInfo and files delet techniques from the System.IO
            ///...code goes here
        }
    }

You can find the Aspose help here: Cells and PDF

Have fun

Parser error : “The async attribute on the page directive is not allowed in this page”

2009-05-29T13:48:00.011+02:00

Last week I bumped upon this error while I was trying to do an asynchrounous WCF service call from my "MS Project 2007 Web Access"-custom user control.

Turns out that you cannot set the Async="true" atttibute in the page directive af an aspx page in the Project Web Access.

The reason for this? Very simple ... the that SharePoint’s SPPageParserFilter class blocks some page directive attributes. When you use other attrubutes than the following list, you will get the error "The 'xxx' attribute on the page directive is not allowed in this page."

The list:

autoeventwireup
buffer
classname
codebehind
codepage
compileroptions
contenttype
culture
debug
description
enabletheming
enableviewstate
enableviewstatemac
errorpage
explicit
inherits
language
lcid
lineparagmas
maintainscrollpositiononpostback
masterpagefile
responsencoding
smartnavigation
strict
stylesheettheme
targetschema
theme
title

To take care of this issue we chose to have a webservice call which will handle the Ascynhrounous WCF call, and from our web user control we called this webservice method sycnhrounous.... Maybe this is not the best solution, but we really had an issue, so a quick fix was necessary here...

To semi-colon or not to semi-colon

2009-05-29T11:26:00.006+02:00

Do you need to end your T-SQL statements with a semi-colon (;)?
No, at least not yet. As stated in the following web page (http://msdn.microsoft.com/en-us/library/ms143729.aspx) "Not ending Transact-SQL statements with a semi-colon." will be replaced by "End Transact-SQL statements with a semi-colon ( ; )." in
future versions...

Is it a good practice to end your statements with a semi-colon?
Yes, because:
- it will be mandatory in the future.
- you need to use it with CTE.(where the preceeding statement needs to end with a ";")
- you need to end MERGE statements with a ";"

Community Day 2009

2009-05-12T15:50:00.003+02:00

Third Edition of Microsoft Community Day, a networking and knowledge sharing event.
Register yourself and be there!

Architect Forum - May 6th 2009

2009-04-14T09:02:00.005+02:00

The forum will be on Security and Identity Lifecycle Management.
More information on the Architects Rule! blog here...

SQL Server 2008 SP1 Released

2009-04-10T08:18:00.005+02:00

Microsoft has released their final version of Service Pack 1 for SQL Server 2008, less than a year after the Release of SQL Server 2008.

No new features have been added to SP1, byt there are some improvements on usabiltiy.

SQL Server 2008 SP1 is availalable for download here!

Adding toolbox items crashes VS2008

2009-02-23T13:19:00.003+01:00

Problem:

When right-clicking the toolbox in an open Visual Studio 2008 environment, I had some strange behavior when selecting "Choose Items ... ".
In fact there was no behavior at all ... my development environment just crashed!!!

Rather annoying if you try to add some new items don't you think?

Cause:

The problem is caused by the Power Commands 2008 Addons for Visual Studio.

Resolution:

Uninstall the Power Commands 2008 Addons...

Continue next step after exception

2009-02-11T11:24:00.009+01:00

In some case it is handy to catch the exception and then continue with the next step right after the line that threw the exception.
There are several ways to do this, one is writing a try {} catch{} block around every line of code (which will of course pollute your code).

I found some code bits on the internet, which wrap this in a function.
I created a new Console application to demonstrate this.

First we create a class handling this functionality:


public static class Executer
    {
        public static void Execute(Action action, string errorMessageToLog)
        {
            try
            {
                action();
            }
            catch
            {
                Console.WriteLine(errorMessageToLog);
            }
        }
    }

Then we create the code in the Main function of our console application:


static void Main(string[] args)
        {
            for (int counter = 10; counter > -10; counter--)
            {
                Executer.Execute(() =>
                    Console.WriteLine((10 / counter).ToString()), "Error Occured");
            }
            Console.Read();
        }

When we run the code, you will notice that when counter = 0, a division by zero will occur, so this will throw an error. This error is displayed to the console and the next value of counter will be processed.

Length of LOB data to be replicated exceeds configured maximum 65536.

2009-01-21T15:24:00.012+01:00

This week I came across the following error :
Length of LOB data to be replicated exceeds configured maximum 65536

When we where uploading pictures to store in a column of data type "Image" into our SQL server 2005 database.
The error is thrown when replication is enabled on the server, so the fix for this is rather easy ... increase the size that can be replicated using the following T-SQL Statement


sp_configure ‘max text repl size’, 2147483647

Or via the Management Studio :

Right Click a server in Object Explorer and click Properties
Select Advanced
Under the Miscellaneous Category, change the Max Text Replication Size to the value you want.

Max Text Replication Size definition (as defined in the SSMS): Specifies the maximum data that can be added to a replicated column in
a single INSERT, UPDATE , WRITETEXT or UPDATETEXT statement

Playing with DateTime in SQL2005

2009-01-21T12:30:00.024+01:00

For a project I'm working on I needed to extract semester and quarter from a date.
This brought me to the idea of storing these values in a table.

The following code sample is a table valued function which generates detailed calendar output.


Create Function [dbo].[DateTimeFunctions.ReturnExtendedCalendar]
  (@TableStartDate DateTime , @TableEndDate DateTime , @FYStart DateTime)
Returns @ExtendedResultSet Table
    ( MonthStart DateTime , MonthEnd DateTime , [Year] Int , [Month] Int , 
     [Quarter] Int , Semester Int , [MonthName] Varchar(20) , [FiscalYear] Int , 
     [FiscalMonth] Int , [FiscalQuarter] Int , FiscalSemester Int)
As
Begin
 Declare @CalendarTable Table 
   ( MonthStart DateTime , MonthEnd DateTime , [Year] Int , [Month] Int , 
     [Quarter] Int , Semester Int , [MonthName] Varchar(20) , [FiscalYear] Int , 
     [FiscalMonth] Int , [FiscalQuarter] Int , FiscalSemester Int)
     
 Declare @FirstDayOfCurrentYear DateTime
 Declare @FiscalStartDiff Int

 Select @FirstDayOfCurrentYear = Cast(Cast(Convert(Varchar(4), DatePart(yyyy ,GetDate())) + '-01-01' As Varchar(20)) As DateTime)

 Select @FiscalStartDiff = DateDiff(mm , @FYStart , @FirstDayOfCurrentYear)

 While @TableStartDate <= @TableEndDate
 Begin
  Insert Into @CalendarTable
    (
     MonthStart , MonthEnd , [Year] , [Month] , [Quarter] , Semester , [MonthName] ,
     [FiscalYear] , [FiscalMonth] , [FiscalQuarter] , FiscalSemester
    )
  Values ( @TableStartDate ,
     DateAdd(ms, -3, DateAdd(mm, DateDiff(m, 0, @TableStartDate) + 1, 0)) ,
     DatePart(yyyy , @TableStartDate ) ,
     DatePart(mm , @TableStartDate ) ,
     DateName(qq , @TableStartDate),
     Case When DatePart(mm , @TableStartDate ) Between 1 and 6 Then 1
       Else 2
     End ,
     DateName(mm , @TableStartDate) ,
     DatePart(yyyy , DateAdd(mm  , @FiscalStartDiff , @TableStartDate )) , 
     DatePart(mm , DateAdd(mm  , @FiscalStartDiff , @TableStartDate )),
     DatePart(qq , DateAdd(mm  , @FiscalStartDiff , @TableStartDate )),
     Case When DatePart(qq , DateAdd(mm  , @FiscalStartDiff , @TableStartDate )) 
         In (1 , 2 )Then 1
       Else 2
     End
    )
     
  Set @TableStartDate = DateAdd(mm , 1 , @TableStartDate)
 End

 Insert @ExtendedResultSet (MonthStart , MonthEnd , [Year] , [Month] , [Quarter] , 
     Semester , [MonthName] , [FiscalYear] , [FiscalMonth] , [FiscalQuarter] , FiscalSemester)
 Select MonthStart , MonthEnd , [Year] , [Month] , [Quarter] , 
     Semester , [MonthName] ,[FiscalYear] , [FiscalMonth] , [FiscalQuarter] , FiscalSemester 
 From @CalendarTable

 Return
End

Execution of the function is as follows :


Set DateFirst 1
Set @TableStartDate = DateAdd(yyyy ,-10 , '2009-01-01')
Set @TableEndDate = DateAdd(yyyy , 0 , '2009-12-31')
Set @FYStart = Convert(DateTime, '2009-04-01')

Select * From [dbo].[DateTimeFunctions.ReturnExtendedCalendar]
         (@TableStartDate , @TableEndDate , @FYStart)