Am I on the right track? For some reason I think I am way off but, my
little brain can't see an alternate method. I am just looking to populate
the @CallID column with a unique value for every record inserted.



DECLARE @CallID VARCHAR(7)



DECLARE C1 CURSOR FOR



EXEC [CallHistory].[dbo].[sp_Generate_CallID] NULL



OPEN C1

FETCH NEXT FROM C1 INTO @CallID



WHILE @@FETCH_STATUS = 0

BEGIN



SELECT QUOTENAME('\\mktgimg\Archive$\','''') + [Extension] +
QUOTENAME('\','''') + [Wav_File] + QUOTENAME('.wav','''') AS Pathname,

[Extension] AS PortExtension,

CAST([Call_Date] + QUOTENAME(' ','''') + [Call_Time] +
QUOTENAME(':00.000','''') AS DATETIME) AS StartDateTime,

[Call_Duration] AS Duration,

[Call_Type] AS CallType, [Call_Direction] AS CallDirection,
@CallID AS CallID

--INTO #CallHistory_Recordings

FROM [CallRecords]

FETCH NEXT FROM C1 INTO @CallID

END

CLOSE c1

DEALLOCATE c1




MS Sql Server LazyDBA home page