Mmmm. Must admit only done this in testing, mind you I would be happy if this was the only mistake I made, you should see some of my big faux...

Unfortunately no, sorry. I have no experience of Merge Replication, and when I did touch on Replication years ago, the problems I had put me off it for life. I...

I don't think what tool you use matters (although I'd prefer DTS) but the process you use to transfer the data. I have not done it personally but I believe...

Ok, Dave, your solution is easier, quicker to implement

No not really. After re reading the original post 8...

Horrible but....

SELECT LEFT(emp_name,CHARINDEX(' ',emp_name+' ')-1) AS 'FirstName',

(CASE

 WHEN CHARINDEX(' ',emp_name,CHARINDEX(' ',emp_name)+1) = 0

  THEN ''

 WHEN (CHARINDEX(' ',emp_name,CHARINDEX(' ',emp_name)+1) -

   CHARINDEX(' ',emp_name) - 1) = 1

  THEN SUBSTRING(emp_name,CHARINDEX(' ',emp_name)+1,...

OK I did this without knowing your table defs. The principle is based on that you may have data missing for certain months but want to show those months with...

Style is only used when converting to character.

Use

SELECT @date = CONVERT(datetime, @reporteddate)

Also the test of @@ERROR will not be used as failure in date conversion will cause Level 16 error...

Why not simply delete the duplicates and then alter your index?

And how do propose to do that Frank...

RESTORE DATABASE TestDatabase FROM DISK = 'D:\MSSQL7\BACKUP\LiveDatabase.DMP'

    WITH REPLACE,

         MOVE 'LiveDatabase_Data' TO 'D:\MSSQL7\Data\TestDatabase_Data.MDF',

         MOVE 'LiveDatabase_Log'  TO 'D:\MSSQL7\Data\TestDatabase_Log.LDF'

Replace the folder locations to suit your environment

CREATE TABLE calendar (

CalDate datetime PRIMARY KEY,

CalYear int,

CalMonth int )

INSERT INTO calendar values ('2003-04-01',2003,4)

INSERT INTO calendar values ('2003-05-01',2003,5)

INSERT INTO calendar values ('2003-06-01',2003,6)

INSERT INTO calendar values ('2003-07-01',2003,7)

etc

SELECT c.CalYear,

 c.CalMonth,

 SUM(ISNULL(a.sales,0)) AS 'Total...

You're welcome, hope it is of some use.

Difficult without table defs but this may get you going but will need adjusting.

SELECT p.PatientID,

 rl.date

INTO #patient

FROM Patient p

 INNER JOIN RecordLog rl

  ON rl.PatientID = p.PatientID

  AND [on-record]

SELECT p.PatientID,

 al.date as 'StartDate',

 (SELECT ISNULL(MIN(al2.date),GETDATE())

  FROM ActiveLog al2

  WHERE al2.PatientID =...

No problem and I would not class it as a 'newbie' question. Like all things you either know the answer or not. The art is in knowing who to ask...

SQL will convert and truncate data where appropriate. When converting to varchar (implicitly or explicitly) and the value is too large SQL will insert and * instead.

See 'CAST and CONVERT'...

What about

IF EXISTS(select uid from a_big_table inner join a_bigger_table on uid)

BEGIN

...

END