I'll have to have you ask it again too.. because if you can't modify the sp then you're screwed. The only other way around would be to have you...

I see your point. I'm working with a nightmare database here. I'd have to complete my point with another step : correcting all there mistake in there face. ...

How much time does it take now?

CREATE Procedure dbo.AddEZLogin

@login varchar(128),

@pwd varchar(128),

@defdb varchar(128)

As

IF EXISTS( Select name From master.dbo.sysxlogins Where name =...

If they only tried it once they'd probabely get it

Try not using the index hint first to see if the performance is better...

What do you mean exactly?

Arrays and Lists in SQL Server

I would suggest you answer to Noeld's and Michael's question since they know more than me on this topic.

You could try count(*) instead of count(pos) if that column doesn't allow nulls.. This will allow the server to simply do an index seek on the po_date.

Also I would use...

Select * from @tbl T INNER JOIN Products p ON T.ItemName = Products.ProductName

because @tbl must be a declared table variable.

set statistics time on --timers

set statistics io on --disk reads write

print GetDate()

is the column declared binary of varbinary?