you just concatenate the fields with the hardcoded stuff;

update tablename

set email = fname + '.'+ lname + '@domain.com'

here's a substring example in case you wanted first initial + lastname:

update...

I'm not sure if this will work, but what about this:

--edited to add an inner join to get the staff id's  last tip

CREATE PROCEDURE [dbo].[prc001GetTipOfTheDay]

 (@intStaffID int)

AS

Select Top 1...

Here's my answer ot the second half of your question:

a text column is used when you have data that is going to be really big; a varchar has a max...

I believe I picked this up as one of the scripts submitted to the site;

there's an export and inport function below; i never tested this myself:

--**************************************

--    

-- Name: Procedure to...

I guess I should clarify; The Process in VB takes 30 seconds; the process runs hundreds/thousands of similar queries,one for each transaction it tries to post to the accounting tables,...

unfortunately, the db is in another state, and administered by a dba there; I was trying to diagnose issues by remote;

both Auto Update Statistics and Auto create Statistics are turned...

To expand on this issue I was hoping to read more specifics, and followed up on this myself:

If I was creating a new database, what collation would I use to...

I'm certainly no expert on the issue, but from what I gather, this program "clusters" two SQL servers, but they do not need to share the same storage location...it allows...

I received my book the same time that SQLBill did; thanks everyone.

It's time to beat your own drum though... i noticed that on the site that covers books and reviews,...

I think you'll have to use more than just the customers first and last names to cull duplications out.

I would think that it would be very easy to have...

You might want to check your backup strategy.

I bet it started at 4am and your database was locked because of it.

That might be the root cause of your failure.

Lowell

Thanks Allen That's good to know; maybe Brian Knight could update his article to mention something about how it is not possible to rename SQL server Instances;

It would make...

This does what you wanted; the select at the end shows how you can find the # days before /number of days until the users next birthday:

CREATE VIEW UserBirthDay

AS...

OK I'll bite;

I've never seen anything like WITH TIES;

I looked to see if it was a query hint, but it looks like its a named set, right? i found something...

I found an answer from a Microsoft Guru that seems to explain how to fix your issue:

Hope it helps:

From: "Bill Hollinshead [MS]" (billhol@online.microsoft.com)

Subject: RE: SQL 2000 Enterprise manager unknown error...