We purchased SQL Server 2005 Developer Edition for our development and QA environments, and SQL Server 2005 Enterprise Edition for our production environemnts. I would say, even for non-critical...

Wouldn't you have to write this:

select DATEADD(dd,DATEDIFF(dd,0,Mydate),'19000101')

like this:

select DATEADD(dd,DATEDIFF(dd,'19000101',MyDate),'19000101')

if you wanted to eliminate the implicit conversion between int and datetime?

😎

Adding surrogate keys just to ensure a data record is unique may not be the best use of surrogate keys. But if a data record does not have a...

I think I see a misunderstanding of the use of natural keys vs surrogate keys in one of the posts. Yes, WHERE State = 'MN' is clearer than WHERE...

I'd have to say I'm in the middle as well. It really depends on the system you are building or supporting. In a data warehouse, I feel they...

Try this:

select replace(replace(replace(replace(convert(varchar(30), getdate(), 121),'-',''),' ',''),':',''),'.','')

😎

We are running two x64 servers, and do not have AWE enabled, and everything works fine. In your x64 environment you should be fine.

This is also a good article on how to ask for help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Technically a table can only have one primary key. You can have more than one unique index, and these are called alternate or candadate keys.

😎

Check out this thread:

http://www.sqlservercentral.com/Forums/Topic443935-146-4.aspx#bm445106

😎

Here is another way to do it:

CREATE Function GetMonthEnd(@Date DateTime)

Returns DateTime

AS

Begin

Return (dateadd(mm, datediff(mm, 0, @Date) + 1, 0) - 1)

End

Could you provide the DDL for the entire sp, not just the query it is running?

thanks

I'll have to remember that as well. Didn't have time to do any testing, had an unscheduled meeting.

😎

Jeff,

Have you tried an accent sensitive collation?

😎

Is there any additional data in the file you get, such as PO or Order numbers that can be used to tie sales and returns together?

😎