![]() Range of sites that will help you to use OPENROWSET well. The file must be physically on the server of the database.StartDate would correspond to the beginning of the fiscal week and EndDate at the end of the fiscal week.Ĭhoix2: You create an EXCEL file in which you enter the data either as in Choix1, or as it suits you. !\ : You can also create your table like this: WeekCalendarForFiscalYear with 4 fields. You have to think about indexing these fields. In FiscalYear, you are in the fiscal year (2016, 2017, 2018, etc.). SQL Accounting is introduces, the integrated business backbone delivers an unrivaled combination of power (features), control (multi dimension reporting. Talk to us today to learn more about financial aid and. In WeekNumber, you put the number of the fiscal week. The Perils Of SQL InjectionSecret pages with videoscould look.In DateOfToday, you put the date of the day. ![]() ![]() I advise you to do it either by using a table (Choice1) or by creating an EXCEL file (Choice2).Ĭhoice1: Create a WeekCalendarForFiscalYear table with 4 fields. Writing a query to do this, seems to me very complicated.
0 Comments
Leave a Reply. |