Help please. Select data between financial Year

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Help please. Select data between financial Year

Author

Topic

billat001
Starting Member

2 Posts

Posted - 2007-02-28 : 20:23:54

Help please. Select data between financial Year

--------------------------------------------------------------------------------

How can I select data between a financial year. The financial year begin in july(7) and end in june(6).

Lets say I want all data between the begining of financial year (7) to January (1)

so I would select all data between 7 and 1. (6 months period)

and lets say I want all data between the beginning of financial year(7) to october (10) so I would just select all data between 7 and 10. (3 months period).

Below is data from a customer table.

Customer Name Month
----------------------------------------------------
APPADENE FOREST PRODUCTS 7
APPADENE FOREST PRODUCTS 8
APPADENE FOREST PRODUCTS 9
APPADENE FOREST PRODUCTS 10
APPADENE FOREST PRODUCTS 11
APPADENE FOREST PRODUCTS 2
APPADENE FOREST PRODUCTS 3
APPADENE FOREST PRODUCTS 4
APPADENE FOREST PRODUCTS 5
APPADENE FOREST PRODUCTS 6
BLUELEAF CORPORATION PTY LTD 3
BLUELEAF CORPORATION PTY LTD 4
BLUELEAF CORPORATION PTY LTD 5
WESPINE INDUSTRIES PTY LTD 5
WESPINE INDUSTRIES PTY LTD 6
WESPINE INDUSTRIES PTY LTD 3
WESPINE INDUSTRIES PTY LTD 4
WESPINE INDUSTRIES PTY LTD 5
WESPINE INDUSTRIES PTY LTD 6
BLUELEAF CORPORATION PTY LTD 6
WESPINE INDUSTRIES PTY LTD 8
WESPINE INDUSTRIES PTY LTD 9
WESPINE INDUSTRIES PTY LTD 11
WESPINE INDUSTRIES PTY LTD 12
NANNUP TIMBER PROCESSING PTY LTD 3
WESPINE INDUSTRIES PTY LTD 1
NANNUP TIMBER PROCESSING PTY LTD 4
NANNUP TIMBER PROCESSING PTY LTD 5
NANNUP TIMBER PROCESSING PTY LTD 6
WESPINE INDUSTRIES PTY LTD 3

--------------------------------------------------------------------------------

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-28 : 20:32:13

Is there a year column in the table ?

billat001
Starting Member

2 Posts

Posted - 2007-02-28 : 20:55:10

Yes there is a year column and from your question I think you have answer my question.

mahesh_bote
Constraint Violating Yak Guru

298 Posts

Posted - 2007-03-01 : 02:16:58

hey,

if u have year column in ur table, u can overcome the prob. have u tried to write select statement to fetch the data? if yes, then what problem u r facing? rather u post that select statement

Mahesh

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources