We are still having a problem with this. If anyone has any ideas they would be greatly appreciated.

😎

I would do this is four steps.

1. Create a new column on the table as a datetime column: xyz_new

2. Update the new column with the following code: update...

MD, glad to help!

😎

Check this thread for the code from one of my Script Tasks:

http://www.sqlservercentral.com/Forums/Topic443977-148-1.aspx#bm444004

You would then use the value returned from the Script Task in a File System Task to rename the...

To expand a little. We installed SQL Server 2005 DE on a development server (don't have our QA servers yet). We purchased one copy of SQL Server 2005...

From what I have been able to determine, you need the Professional version of Visual Studio or better to debug stored procedures. That was one of my big complaints...

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.

😎