That's not quite true, though it certainly isn't as easy as it might be. If you are prepared to venture...

So you are just ignoring almost all of the advice everyone has given you and still asking for help?

If you are not prepared to listen, or at least to...

Not sure, but have you tried using an expression, rather than parameters, to do this? Then you can quite clearly see where your variables are going.

You could also try something...

rishiextc (2/1/2012)

---

You can do it as follows,

1. SET IDENTITY_INSERT Table_name ON

2. INSERT into Table_Name (Column_1, Column_2......) Values (Value_1, Value_2.....)

(make sure while inserting you specify name of required...

That's how IDENTITY columns work. Read more here.

If you really want to reset the seed value, read up on DBCC Checkident.

If you rewrite your proc slightly to use dynamic SQL in the non-validating bits, you can get round the validation issues.

Once you've built your dynamic SQL string, try doing a straight

select @sql

before executing it. That should allow you to see where things are going wrong.

No problem.

I was responding to this statement:

I generally use SQL2K8 and i'm used to the format on it. Unfortunately the company i'm working for are on 2K5 and they're not...

What is there about your proc which works on 2008 and not 2005?

I explained the behaviour of STR() (or so I thought).

For your purposes, it is not suitable. If instead you cast your variables as, say, varchar(30) and then print them, you...

krishnaprasad14 (1/31/2012)

---

Thank you for the reply. But here we are not deleteing existed records in UNMATCH table.

[For example, today we got 3 records into Unmatch obkect and tomorrow may be...

Koen Verbeeck (1/30/2012)

---

Use an Execute SQL Task to create a backup of the database.

Use another...

I'm afraid that I don't 100% understand what you are doing. But as you are operating on a single server, I would be tempted to do the whole thing in...

So is it the case that you only ever want to insert new data and that you are not worried about updates?

Is the PK ID an identity column? Just wondering...

Or maybe you...