Brandie, OK, you're right. 🙂

But there was a stupid me, looking at the cache with the old data. I'am so ashamed...

Sorry to tell you, that your suggestions did'nt work

I tried

[font="Courier New"]INSERT INTO

FieldNames

(SELECT FieldNamesTable1, FieldNamesTable2

FROM Table1 T1

JOIN Table2 T2 ON T1.ConnectField = T2.ConnectField)

ORDER BY AFieldName -- (not used,...

Gail, thank you for your effort.

I hope your test gives us a solution 🙂

I use SqlServer 2005

Gail thanks for your answer.

But there is a reason for the order in the new made table.

What I forgot to mention is that the inserted table has an autoincrement (PK...

There is an article at Microsoft http://support.microsoft.com/kb/914277

How to configure SQL Server 2005 to allow remote connections.

It has a chapter:

Enable remote connections for Sql Server 2005 Express.

You may have...

I think you can run the 2 in parallel. Express is a named instance (MyServer\SQLEXPRESS) and you...

Jose, thanks.

Could I also use an empty string (eg '') for the table(s) to compare all the tables?

Sorry, but the "how to use" is missing.

I only see two scrollbars, without any text.

Please could you add a "how to use" in this discussion.

The problem is that the names...

Frank Kalis has some interesting pages on the DATETIME type.

Look at page 5 for some birthday sql:

http://www.sql-server-performance.com/articles/dev/datetime_datatype_p5.aspx

And on page 6 there is this nice one:

SELECT (0+CONVERT(CHAR(8),GETDATE(), 112) - CONVERT(CHAR(8), @d,...

See also my script (dec 27 2006, Henk Schreij):

Script for all Foreign Keys of all tables of a DB

I am not in the position to place a User Defined Function in the database....

Sorry, I wasn't looking for a UDF.

What I want is something likea patindex to find the char and then stuff it with a -.

Something like

PATINDEX ('%[^a-z 0-9 . _}%',...

Yes, I did use REPLACE:

[font="Courier New"]SELECT REPLACE(REPLACE(AName, 'ä', '-'), 'é', '-') AS AName[/font]

But then came another diacritic, and then again, and again, etc.

I found out there are ca 35...

The layout of the virtual briefcase a problem. I could easy find an article using my comments. Now it is spread over a lot of pages with a lot of extra...

From the Netherlands.

We have a similar system as Italia for datetime syntax:

eg 31-07-2007 14:23:46.000

Btw: try to use ISO standard dates, SqlServer accepts these for every (country) setting