declare @selField varchar(50)

declare @selTbl varchar(50)

declare @sql varchar(100)

set @selField = 'name'

set @selTbl = 'sysobjects'

SET @sql = 'SELECT ' + @selField + ' from ' + @selTbl

EXEC(@sql)

Disregard, it just occured to me that the view is being seen as a dependent object - so I will have to drop that view first and recreate it after. 

With...

I just found and SQL FAQ on the net that seems to confirm that there is no modified date.  The suggestion there was to drop the proc and recreate it...

Do the 100 missing records have anything uniquely in common with each other?

I have a question for you.  It looks like you are using a left join and the IS NULL to avoid duplicates.  However, you then have:

OR ([table1].EmpNo IS NOT NULL

...

"UT" probably stood for "Union Table" in the mind of the author.  However, here it is just a table alias so it makes not different.

The SQL:

 SELECT EmpID

  FROM table1

  WHERE EmpTermDate IS NULL...

Shailen, do an index search on "pivot tables" in SQL Server's Books On-Line (BOL).  You will find a very clear illustration on how to pivot using a SQL's "CASE" statement.  Take...

I second that.  I wasn't aware of the "parameter sniffing" concept.  It would be nice to see the problem and solution illustrated.

Definitely try Antares' suggestion to run the querries locally on both machines and compare performance.  I had a similar problem and it took me a while to figure it out. ...

YOU SAID:  I can say, however, that whenever the query looks in VALUE1 for data, it will *always* be looking for Integer-type data, so is there any way to just...

Howard, if you are getting more records from the IN comparison than the EXISTS, you may have nulls in your column.  This seems wierd since you are comparing key columns...

None of my experience with hyperthreading has been on a SQL server.  I have, however, tested it on various application servers.  What I found is that hyperthreading had little to...

Well, since SQL Server runs in either Windows Authentication Mode or Mixed Mode (SQL and NT), I guess your best bet is to:

-Remove all NT based server logins

-Remove 'Builtin\Administrators' Group

I haven't...

Then I guess you are only interested in records where value1 is numeric data?  If that is the case, maybe something like this will work:

SELECT vt.* FROM

(SELECT * FROM...

But it is! I never understood varchar to mean "no integers allowed". Does it? In any case, that column needs to have both Integers and Non-Integers.

2619 and '2619' may both...