Thank you for your answers. The idea was to create function that will simulate AutoNumber on a varchar column and will be used in INSERT statements. Other solution is using...

You can create SQL string and than execute it in a stored procedure, like this:

Create PROCEDURE varcolSearch

@colname varchar(30) = 'DefaultCol' AS

declare @U nvarchar(1000)

set @U='Select T1.col1, t1.col2,...

quote:

---

I have had this problem before and the solution was to create the procedure from QA not EM.

Do you have to create...

quote:

---

Just put the set statements before your procedure call,

eg:

SET ANSI_NULLS ON

SET ANSI_WARNINGS ON

EXEC dbo.DestViewCreator ...

Hope this helps

Phill Carter

--------------------

---

November 19, 2003 at 3:15 am