Hi,

I had a row "seen" but I got a error during Insert : The name or the number of column of the supplied values does not correspond to the definition of the table.

Thansk,

Eric

CREATE TABLE #TEMP2

(

cnetPatId integer,

cnetNumTel varchar(40),

easilyTypeNumTelId integer,

cnetnumeroPrincipal bit not null,

cnetSMS integer not null,

cnetCommentaire varchar(40),

easilyPatId integer null,

seen BIT DEFAULT 0

)

PRINT 'Matching avec les patients CNet'

INSERT INTO #temp2

SELECT CNet.pat_id,LEFT(CNet.[NUM_TEL_REEL], 18) AS CNETNumTel ,

CASE CNet.[TYPE_NUM_TEL_ID]

WHEN 1 THEN 1

WHEN 2 THEN 4

WHEN 3 THEN 3

WHEN 4 THEN 0

WHEN 5 THEN 5

END AS easilyTelCat,

CNet.[NUMERO_PRINCIPAL],CNet.[SMS],Cnet.[COMMENTAIRE],tmp1.patId

FROM [DI81SW].[CNET_EXP].[dbo].[NOYAU_NUM_TELEPHONE] AS CNet WITH (NOLOCK)

INNER JOIN #temp1 AS tmp1

ON tmp1.ancienPatId = CNet.pat_id

WHERE (CNet.[SMS] = 1)

and (LEFT(CNet.[NUM_TEL_REEL], 18) not in (select tel_numero collate SQL_Latin1_General_CP1_CI_AS FROM

[DI628SW].[NOYAU_PATIENT].[noyau].[TELEPHONE_PATIENT] AS TP WITH (NOLOCK)INNER JOIN [DI628SW].[NOYAU_PATIENT].[noyau].[TELEPHONE] AS T WITH (NOLOCK)

ON TP.TEL_ID = T.TEL_ID WHERE t.tel_envoi_sms = 1 AND tmp1.patid = TP.pat_id))