Hello Erin

I would like to use same technique while inserting records into existing table. Is it possible by any way?

As per my knowledge IDENTITY function can be used only...

Actually i have hard-coded value for @Rec but it gets calculated for each record being inserted from source table into destination.

For this purpose I cannot directly insert values from source...

Below is just a part of code

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

DECLARE @Rec int

DECLARE @FieldType2 int

DECLARE @FieldLabel2 VARCHAR(50)

DECLARE @Ctr int

DECLARE ExtraAux CURSOR FOR

SELECT FieldType, FieldLabel FROM Tab2Field WHERE BlockType = @BlockType AND FieldNumber NOT IN...

If you are using SQL Server 2008 then you can directly debug it using green triangle button available in toolbar.

In Query Analyzer window, write the line - EXECUTE <ProcName> <Param1,Param2.....>...

I think solution given by you as well as GilaMonster has solved the issue. I separated case statement for each of 4 columns and it worked.

Thanks all

This code gives error on line 1 as:

None of the result expressions in a CASE specification can be NULL.

I have replaced [CASE...] with proper cases but still ....

Thanks for that. But, do you mean to say that to insert values into textvalue, datevalue, numbervalue, memovalue columns, I need to repeat the case statement 4 times?

Actually,my requirement is,...

Issue is resolved... in a bit strange way.

Problem seemed to be due to permission issue. I was executing a Setup by double clicking on its EXE. This script...