The instance name is stored in master, but changing that is well documented.

You will also need to update the originating_server in sysjobs (does not apply to SQL 2005)

There will also...

I don't really see the point in what you are doing, because you can just break out the date and time parts when you need to.

You can break them out...

The easiest way is to left join each row to the prior row for the same customer, and do a difference between the dates from the current and prior row...

What if you need to do Banker's Rounding to the nearest 5 cents? :Whistling:

I would use it to store binary data.

select

a.Date,

LastSundayOfMonth =

dateadd(dd,(datediff(dd,-53684,dateadd(mm,datediff(mm,-1,a.Date),-1))/7)*7,-53684)

from

(

--Test Data

select Date = convert(datetime,'20080101')union all

select Date = convert(datetime,'20080201')union all

select Date = convert(datetime,'20080301')union all

select Date = convert(datetime,'20080401')union all

select Date = convert(datetime,'20080501')union all

select Date = convert(datetime,'20080601')union all

select Date = convert(datetime,'20080701')union...

The sad truth is that the Excel bugs are intentional "features" that were put in to match the behavior of Lotus 123 where the bug originated.

http://support.microsoft.com/kb/214326

I do not believe that you can restore a SQL Server 2005 database backup to SQL Server 2000.

This might be close to what you want.

Defragment Indexes stored procedure - new version:

http://weblogs.sqlteam.com/tarad/archive/2007/11/27/60415.aspx

I wouldn’t say that the value of certifications has declined in my eyes, simply because I have never given them any weight at all in choosing candidates.

Companies have to to be very selective in the technologies they adopt and anticipate the available labor pool that will be able to support it.

If you decide to adopt a...

The two tables don't have the same structure. Also, you didn't post the DDL for the primary keys.

select

[Date of Birth] = dateadd(month,(12*BirthYear)-22801+BirthMonth,BirthDay-1)

from

(

-- Test data

select

BirthYear= 1975,

BirthMonth= 12,

BirthDay= 30

) a

Results:

Date of Birth

------------------------

1975-12-30 00:00:00.000

(1 row(s) affected)

Unfortunately, the costs spent do matter, because if they declare the project a failure, then all the costs of the project will have to be written off immediately, instead of...

mhaskins (5/27/2008)

---

Michael Valentine Jones (5/27/2008)

---

I give people I interview a test of SQL questions, four that I expect that anyone worth hiring can solve, and one that I expect most...