UPDATE a --<--- I changed this!!!

SET a.col1 = b.col1,

a.col2 = b.col2

FROM #temptable1 a

RIGHT OUTER...

Here is a script but it is not ideal -

GSquared is right when he said you should try an identity col first.

This should work on SQL2000 although I did...

The following works for me. It uses dynamic sql: (I am all for a simpler solution if anybody else has one!)

DECLARE @MONTHS NVARCHAR(MAX)

SELECT @MONTHS = ''

SELECT @MONTHS = @MONTHS +...

You can try the PIVOT operator, but you have to specify the columns that it will pivot on, so it is not really dynamic...

To get test data:

CREATE TABLE sales(name nvarchar(20)...

Try

WHERE ISNUMERIC(REPLACE (REPLACE (ex,'.','X'), '/','')) = 0

The REPLACE (ex,'.','X') just changes the . to a letter as otherwise ISNUMERIC wil be true.

The other replace function just removes the // and...

I think this is what you want:

(I grouped both separately to remove the duplicates from each table.)

Select

E.Number, E.Name, E.Date As Date, M.Text1

From

Entries As E

INNER JOIN (SELECT Number...