What would be the benefit of creating an index on a date field?

It seems to me that the time portion of either smalldatetime or datetime would tend to generate many...

A lot of my projects involve using MS-Access to connect to Sql Server, but AFAIK there is no equivalent open source version of Access. I've looked at Kexi, Rekall and...

I posted in another forum just today, take a look at

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=367982

Here is an extremely simple example of what you might try.

I am using a pass-thru query in Access to display the number of members updated within the past five days AND they...

Somebody else on this list posted the original formula to accomplish that, but I kept forgetting the syntax so I created a UDF like this:

CREATE FUNCTION [dbo].[fnNoTime]

(@DateTime datetime)

RETURNS datetime...

There is one way to get around the GO statement.

In the middle of an sp, I needed to do an ALTER TABLE but the code that followed it didn't recognize...

The difference is that the free version just sits in the background & automatically clicks the Yes button for you.

The paid version actuallly has hooks into Outlook that allow you...

Hello Rudy, You mentioned that you're using Standard Edition...

AFAIK only the Developer Edition will allow you install the actual database engine with all the extras on a non-server OS, that's...

I've heard of a product called ClickYes but haven't tried it myself. Pricing starts at $39 but there is a 30-day trial version, take at look at:

http://www.contextmagic.com/express-clickyes/

I agree with Rudy - especially re: the 10 years of full support.

How can any of us possibly become a true expert on any MS product with these short product...

Thanks again Matt. What they want to do is EDIT the exported report before it is printed, so snapshots wouldn't work. Ditto for XPS. I suggested PDF's and Acrobat, but...

Here is a good discussion thread, maybe this will help:

http://www.dbforums.com/showthread.php?t=903076

If the dBase tables are part of an actual DOS-era dBase application, then importing is your only safe option.

Even thought dBase is 100% Y2K-compliant within its own environment, there's a...

My biggest problem with MS is that each new product version adds and alters features that are incompatible in such a way that you have to re-learn the old features....

Thanks Matt, for the suggestion. I detest Trend anyway, it sucks up too much CPU power. But the Access file runs just fine, it is only the RTF export that...