quote:

---

Originally posted by sunitabeck

Quoting from MSDN Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

So you might try adding a "SELECT @CompId" at the very end of the stored procedure - and then "zCompID = command.ExecuteScalar()" in the VB code will give you what you are looking for.

Also, be sure to insert a SET NOCOUNT ON at the very beginning of the stored proc.

---

DELETE FROM ATTRIBUTE_INSTANCE WHERE ATTRIBUTE_INSTANCE.ATTRIBUTE_NAME 
			IN ( SELECT CONCAT(ATTRIBUTE_TEMPLATE.TEMPLATE_ID,'.',ATTRIBUTE_TEMPLATE.ATTRIBUTE_NAME) FROM 
			ATTRIBUTE_TEMPLATE, TEMP_ENTITY_TABLE WHERE 
			ATTRIBUTE_TEMPLATE.TEMPLATE_ID=TEMP_ENTITY_TABLE.ENTITY_ID);		

IN ( SELECT CAST(ATTRIBUTE_TEMPLATE.TEMPLATE_ID AS VARCHAR(20)) + '.' + ATTRIBUTE_TEMPLATE.ATTRIBUTE_NAME 
    FROM ............
   )

quote:

---

Originally posted by ramesh.ld9

thank u

---