Convert it to the DATE data type.

The title of this topic seems a little strong for what is really just a gripe about what Microsoft charges for SQL Server Developer Edition.

Getting back to the initial question: "So, are men and women different?"

The answer is obviously yes. That's why men are called men and women are called women.

evanrich (10/4/2010)

...I do have one bit of knowledge to share with any other NEW people that read this... and this this: If you don't know anything about what...

It sounds like you are seeking a technical solution for what is really a business problem: your desire to continue a monopoly on report development.

If your company cannot continue to...

This is probably the fastest code for the conversion (assuming that the year is an integer in the form YYYY)

select dateadd(month,(12*@Year)-22801+@Month,@Day-1)

If the year is two digits, you will have to...

How does the size of the .rar file compare to the size of the .mdf file?

Wouldn't it be simpler to provide your support vendor with a copy of a database...

With transaction log backups (and a full backup), you can restore to any point in time, but with differential backups, you can only restore to the point where the differential...

If the phone number is always stored in format 999-999-9999, then the code below should work without dynamic SQL.

declare @phone nvarchar(50)

set @phone = N'7243426833';

select @phone = stuff(stuff(@phone,7,0,'-'),4,0,'-')

declare @pt table (localphone...

Since you can't actually reorganize the table while it is a heap, I am sticking by that statement.

Solutions involving a reload of the table are possible, but that just...

PaulB-TheOneAndOnly (9/30/2010)

Michael Valentine Jones (9/30/2010)

Since, it is a heap...

Do you have the operator configured to do a Net Send, instead of email?

Lynn Pettis (9/30/2010)

... I have seen his attitude change once when the OP explained he was dumped into the situation he was in and that he was not a DBA/Database...

Did you make the profile a public default profile?

Were there any error messages in the Database Mail Log?

Since, it is a heap with no particular organization,...