Way to go Wayne.  I knew there was a way in SQL2k, but could not remember it.  When I tried "Create Type" in SQL2k and it failed, I thought I...

Another reason to use Steve Jones suggestion is that the external process (sending the email) is not affecting your database update.  If the email server is down or slow, your...

I'm not sure, but I think that sysname also has some data rules defined for it, so that the value stored in it conforms to rules for identifiers.  Also note...

Have you set a "Launch Date" (not to be confused with "Release Date")

You could.  You would send a command line string using xp_cmdshell.  But you say this is from a website.  What platform are you using?

You could get the query results, write...

Also, in SQL Server 2005, you can create your own datatype, a user-defined type:

CREATE TYPE dbo.uInt FROM bigint NULL
--OR CREATE TYPE dbo.uInt FROM decimal(10,0) NULL
GO
CREATE RULE dbo.uIntRule AS @value BETWEEN...

You can run bcp utility to run the query and export the results to a file.  If you want to run this automatically on schedule, you can create a job...

What I have done is to create a job with a series of stored procedures. I use a sproc to Bulk Insert the contents of the file into a "working"...

I have done 4 Vista installs on my various notebooks/tabletpc, one Ultimate and the others Business Premium.  I have not really had any problem, doing both a clean-wipe install and...

Interesting question.  I did find a reference in mskb that the data files and logs are backed up with volume shadow copy service, and another reference that these types of...

(Assuming you are a student with a homework assignment )

Lookup references for Aggregate functions and Group By.  The solution is really pretty easy.

Hope...

First of all, it is not an oddity.  Null does not equal anything, not even another null.

Also, you should be using ANSI joins.

To handle what you need, try this:

SELECT *...

Recognize that Feb 27, 2008 is the "Launch Date".  The release date is not the same as the "Launch Date".  That only means there will be big events, satellite broadcasts,...

UPDATE SourceTable

SET EmployeeName = 'X-' + EmployeeName

WHERE Sourcetable.ID = MainTable.ID

Sure, it's possible.  You can setup the other server as a linked server, then write your query using that 4 part name for the linked server table.