Community Member Profile

Recent Blog Comments By Dave

• Getting @@RowCount After SQL INSERT INTO Statement

  Posted on Oct 27, 2010 at 7:53 AM

  Hi Ben, The output would be like this: Row 1: 2, OldName, Desc., Dept., 1 Row 2: 2, OldName, Desc., Dept., 2 Row 3: 2, OldName, Desc., Dept., 3 Row 4: 2, OldName, Desc., Dept., 4 So the Sql statement will process the records from LLEntry table. And each time i... read more »

• Getting @@RowCount After SQL INSERT INTO Statement

  Posted on Oct 26, 2010 at 4:01 PM

  Hi, I'm trying to figure out how to insert the row count as a value. For example: insert into TempImport (Code, OldName, Description, Def, NewName) Select '2', Name, Description, 'Department', (@@RowCount) from LLEntry where LLEntryID > '0' and LLDefID = '4' I'... read more »