No, the easiest way is to create a split function that can return the list of codes. Then it can be reused everywhere else in the application... Also...

I'm not sure it's the best place to speak about hacking...

1 min to update 1m rows doesn't seem like a long time to me but I've never really worked with tables that big. Maybe you could merge some of...

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.