http://www.freetds.org/

http://www.unixodbc.com/

Also staying away from using CONVERT should perform slightly better, as SQL Server does not need to query the syslanguages system table.

Every litlle bit helps

You should use sp_rename for this case.

As per BOL the max number of table in a SELECT statement is 256.

Here is something from Inside SQL Server 2000

Multiple-Table Joins

According to some folklore, SQL Server "does not optimize"...

Yup, while

exec master..xp_cmdshell 'time' seems to hang

exec master..xp_cmdshell 'time/t' will work fine.

The only way I've found to start such a programm is to use DTS (yuk!) with a win32...

Having fun with more dynamic dynamic sql

DECLARE @stmt NCHAR(1000)

SET @stmt = 'USE Frank_3 ' + CHAR(13) + 'DECLARE @stmt NCHAR(1000)' + CHAR(13)...

There is an undocumented (for obvious good reasons ) xp in SQL Server named xp_servicecontrol. You can use it to start and stop...

Just out of curiosity, James.

Why a UDF?

Take a look at OBJECT_ID() in BOL.

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

Why use a trigger?

If I understand you correct create relationships between the various tables.

The datatypes DECIMAL and NUMERIC are the same in SQL Server.

Will ...SET RMCPL_MD_POINTS= +@EchVpoin not work?

Change it to something like

SET @EchVpoin = 1/2.

or

SET @EchVpoin = 1./2

to force SQL Server not to assume that you want an integer result

Quick and dirty, this should work

select Cust_No, Tel_No,

(SELECT COUNT(*)

FROM

WHERE Cust_No = s.Cust_No

AND Tel_No <= s.Tel_No) AS Seq_No

FROM s

This might also be interesting

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

http://www.sommarskog.se/arrays-in-sql.html might give some ideas.