The idea of providing enhanced access to the competent is good in theory, but in the real world, the access gets provided to technically incompetent people who are just good...

Lynn Pettis (9/24/2009)

---

Taking Michael Valentine Jones version and making it a bit more the way I'd write it, it would look like this:

select

...

Ankur Bajaj (9/24/2009)

...

If having the facility to install Oracle server on windows OS does not limit its utility or performance then what is the reason Microsoft does not allow(or have...

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...