Is it quicker to use OBJECT_ID?  If so, any idea how much quicker?

ON MY honor as a student, I have neither given nor received aid on this assignment or exam

Surely this is a bit extreme.  I think that for many subjects this...

I'm not really sure what you mean.  But if it can speed up the application I'll like to try.  Please can someone expand on this idea.

I am not really referring to a #temp table.  But it is a table that is created at the beginning of the run and then dropped at the end of...

The full context of the loop is:

DECLARE @Counter_temp INT

SET @Counter_temp = 1

While @Counter_temp <= (SELECT MAX(Key_m) FROM Time_definition_SPLIT) begin 

 DECLARE @Instance_tag varchar

 SET @Instance_tag = (SELECT T.Instance_tag FROM Time_definition_SPLIT T WHERE T.Key_m =...

Mike,

Sometimes it is too late to be reactive (9/11).  However, proactive government has not been mastered in the West yet (Iraq).

Michael,

The fact that you can say that without fear or intimidation suggests that NHS England is smart because views are freely expressed and problems must surely then be open for...

It is probably worth considering that it is not the data it is what you do with it that counts.  My boss keeps reminding me that they managed to fly...

Sounds interesting.  But I'm not sure I understand what you are showing me.  I suppose the questions that I originally posted should have been: Firstly, does MS SQL Server support placeholders...

I think that social interactions are really important.  That is why I wear industrial strength ear protectors when I work.

I think that social interactions are really important.  That is why I wear industrial strength ear protectors when I work.

CAST(ROUND(year, 0) AS int) AS Expr1

is an alternative solution

I think that it was a worthwhile attempt to set out procedures for a task like this.  But, honestly, I found it a bit difficult to follow.  Every case is...

Sorry, I didn't leave enough display space open on my result viewer.

Thanks for the test script.  I don't want to remove the number after the full stop.  I just want to remove the full stop.  (I am pleased that you did...