Can you give us a starting point?

Can you show us some sample data and the required results after the insert statement has run?

Glad to hear that.

Ya that makes more sens.  Thanx for the hint .

I strongly suggest you use Sriram's version as it outperforms mine by a mile.  I would also strongly suggest that you change...

What results did those 2 queries sent out?

Not sure.  I'd check the database properties or the books online alter database.  But I don't have any 2005 installed here so I can't check for you.

Check if the server and database collation settings are case sensitive.  If they are you can change them back to case insensitive to completely solve the problem.

You forgot the 6th field in the sample data, but this will give you the right path to go down on :

USE SSC

GO

DECLARE @demo TABLE (id INT, f1 INT,...

Let's just say that this opens up a whole new whelm of possibilities :

SELECT * FROM dbo.SysColumns C1 WHERE Colid IN (SELECT MIN(C2.Colid) FROM dbo.SysColumns C2 where C1.id =...

That's the way correlated subqueries work.  This doesn't fail because this query has to be valid :

Select * from dbo.SysColumns C where exists (SELECT * from dbo.SysObjects O where...

I'm sure it could .

Simple problem Jeff.  Nobody is in your car and no one is using the remote starter so it will remain off untill any of those conditions change

Actually both are required in addition of the sample data and required output from that data.

1.0 : converts to a decimal

*100 : so it shows 65.98 instead of 0.6598

I can see the confusion .