I'll take a stab at this. I figure that the way the table is designed you don't have, and likely couldn't have the indexes needed to speed this up...

Here's a way that I've done this. Never used it in production but I've played with it and it works. You would have to look up the max...

Thank you, John. I have some research to do.

I've done a little research and it looks like with DTS I would be reinventing the same process I have now where the DTS package would be created, delivered, and...

Can DTS be scheduled? Is BOL a good place to look further?

Thanks

ST

Thanks, Damon. Actually I don't have the proc problem, I know just how I want to do that. The file problem: The server admin doesn't want to...

Have you looked at UPDATETEXT in Books Online?

Thanks for replying. Currently the app processes the xls data, creates insert statements, and performs the updates via SQL connection object in java. This is not optimal since...

If you have a table called CompanyNames you can query like this:

-- Remember to use procs to eliminate SQL injection

SELECT cid from CompanyNames where cname =

One project that...

I have no idea. I just did a similar test on my machine and got expected results. FYI the execution plan isn't always the best guide. You...

SELECT TOP 1 * FROM myTable order by myKey DESC

ST

This was a "round the water cooler" discussion. I appreciate your posts and agree.

Thanks

Maybe I'm missing something but if you want all records from column 2 then it doesn't need to be in the where clause.

SELECT col1, col2, col3 from myTable WHERE col1...

Bump

Jeff, amazing as always.