aren't you equating varchar to float in the dynamic query ?

Is data conversion the actual error ?

Remove TGT. from Merge statement inside when matched.

Thanks

2) place them into a temporary table and rank them using the code a fragment of which i posted,

3) insert into base table all the records with rank (rNum)=1

My only...

Velkry Was it helpful ?

CREATE PROCEDURE EXAMPLE (@parameter)

---- To illustrate how I intend to Use Execption Handling inside my Cursor

AS

BEGIN

BEGIN TRY

DECLARE @TABLENAME VARCHAR (10)

DECLARE DROPTABLE CURSOR

FOR SELECT NAME...

Exactly , in...

Yeah the dynamic sql that is generated...

I don't think this will help here since both rows need to be merged (to combine the IND the first one and OUTD of the second one)

I would merge each...

Gina, Can you please post me a Template for handling...

DECLARE @TABLENAME VARCHAR (10)

DECLARE DROPTABLE CURSOR

FOR SELECT NAME FROM INFORMATION_SCHEMA.TABLES -- OR SYSTABLES

WHERE NAME LIKE '%SHI%'

OPEN DROP TABLE

FETCH NEXT FROM DROPTABLE

INTO @TABLENAME

WHILE (@@FETCH_STATUS...

Try using CTE with ROW_NUMBER() . Delete from CTE where rowNUM > 1

am-244616 (10/11/2011)

---

Guys,

I am trying to setup merge replication between two 600 table database, is there a generic script to reset the identity increment on one database to have even numbers...

Thanks CheeseHead.Completely Agree. 🙂

Thanks Gianluca,

Does this mean : [tempdb.sp_executsql @sql ] would get executed in Temp DB ?