In this case the execution of the procedure is not done through sp_executesql. So will this code always recompile while executing?

krayknot

your answer is not complete.

Different tables can be passed as input to the procedure. So can the execution plan of the procedure be different for different tables?

You also need to fix the issue while u r inserting data into the varchar column. You need to make sure that numeric data is being inserted/updated into that column.

Tally table method is the best way to do things like this.

I think the union method is the way to go. Probably the most efficient method of the lot.

check these links.

http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/query-cost.aspx.

This link contains another inner link. Read the comments section of the inner link.

check this out

http://support.microsoft.com/kb/195566

From BOL -

The total cost to the query optimizer for executing this operation and all operations preceding it in the same subtree.

Yes a view is a nice idea but it will work only if the serial numbers dont need to be presisted in the database.

Jonathan Kehayias (2/23/2009)

---

Great question. Unfortunately, the answer is no. Since the ring_buffer target is memory resident, it does not persist the information after restart. You can however,...

is created date unique for each record in that set of records.

nice article.

Is the deadlock info persisted after server/sql service restart.

Do you have any columns that have unique values. For using the rownumber function unique columns will be required to make the joins.

a very basic example...

create table #t...

Another method to do it ...

Add the column you want to store serial numbers as identity column

Alter table table1 Add serialnumner INT IDENTITY(1,1)