Why not just make the field an identity column? If you need globally
unique, make it a guid.


Carolyn Jewel
Database Administrator
Nelson Family of Companies
707.939.3287
707.540.1041 cell


-----Original Message-----
From: Courday Farnam
[mailto:mssqldba-ezmlmshield-x27658414.[Email address protected]
Sent: Friday, June 29, 2007 1:57 PM
To: LazyDBA Discussion
Subject: Cursor / SP / QuoteName woes

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





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page