This will calculate the FY start and and date for any given date.

select

a.DT,

FYStartDate =...

Generally speaking, it make no more sense to store date and time in separate columns that it does to store dollars and cents in separate columns.

If the table is big, and you need good performance on date lookups, you...

I think the issues will become obvious when someone asks you to write a query returning data for a range of time like 2009-08-13 02:45:00 through 2009-10-15 06:13:00

select

...

declare @time table (DT datetime , TM varchar(20))

insert into @time

select '2009-08-03 00:00:00.000', '12:00:00'

select DATE_TIME = DT+TM, * from @time

Results:

DATE_TIME ...

I believe you are allowed to change your user name.

There are many issues with no real black and white solutions.

If anyone can install whatever software they chose, them you end up with enormous cost supporting applications. If user...

If you are searching VARCHAR columns for exact matches, an index on a checksum column (or computed checksum column, or a checksum in a view) can be a good solution.

These...

Access to parts of the application is not controlled by granteing access to databases objects. Access is controlled by having tables in the database that define the access granted...

The ususal was to handle this is to use an n-tier application, and only grant database access to the account that the application server uses to connect to the database....

You could start with taking a random sample from each table into a temp table to use for initial screening:

select top 10000 * into #t from MyTable order by newid()

This...

Some people can only see disagreements as a direct personal attack, so they just don't do well on an open forum.

This guy went nuts when people dared to disagree with...

http://solihinho.wordpress.com/2009/01/01/query-for-listing-sql-server-job-schedule/

The Cluster Administrator application will list the disks under the clusters Resources with Physical Type = Physical Disk

pwatson-904240 (9/15/2009)

---

Thanks both for responding.

Lynn, yeah, I noticed the mistake I made, I actually meant that the year ends on the last Saturday and starts on the last Sunday of...