Thanks

Good question - have not had to use in so long - it is good to be remineded of those long forgotten operators ..

Not truly knowing your groups background and how deep in depth you wish to go with your training, may I suggest reviewing the "SPACKLE" articles here on SSC.

Just enter the...

I suggest that you look at the MERGE statement (new in sql 2008) that said here is a good discussion with excellent examples that might be of use to you.

http://www.simple-talk.com/sql/learn-sql-server/the-merge-statement-in-sql-server-2008/

With the limited information you have given, I suggest that you use BOL (Books On Line) the SQL help file and look at the item titled "Merge"

or use GOOGLE and...

Seems like I will have to invoke DBCC TIMEWARP:

http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx

But I am having this problem

those...

Hmm caught me on that one with Halloween coming up in the USA tomorrow thought this was one of those joke questions ... OH well so be it

Meow Now (10/30/2012)

---

One good thing about this question, I learned about a new feature in 2012. I missed the question, like most, because I made an assumption that the author...

I do not have an instance of SQL Server 2000 available for checking, but you might want to test by using this:

select * from master.dbo.sysperfinfo

If you do use the above,...

For a free tool (Microsoft's upgrade advisor) go to this link:

http://msdn.microsoft.com/en-us/library/ms144256.aspx

Here is an excellent read on the subject:

http://msdn.microsoft.com/en-us/library/aa259228(v=sql.80).aspx

Scroll down a little more than half the page to see examples.

Here is a quick example:

SET QUOTED_IDENTIFIER OFF

DECLARE @Toff...

From the justification of what the correct answer is:

Why then...

Nice question to start the week . .. Thanks

This might do it for you:

CREATE TABLE #T(userid INT, emailname VARCHAR(50))

INSERT INTO #T

SELECT 1, 'a@a.com Bill' UNION ALL

SELECT 2, 'a@a.com Billy'...

Here we go back to the basics once again ....

When designing a data base I always start in a manner that most think is backwards. That is I ask and ask again what does the user(s)...