Actually this was just a small example. I have several transactions, that is why I need to use the self join.

Guess I didn't indicate the result I needed. Need the 0 in AuthAmount when Source = S to be updated to 100. It does not update.

Why did I...

Ahhhh ... thanks!

I figured it out. I haven't used this app in years but it is being used still today. I haven't updated anything either. I installed the latest...

I'm sure the queries are running slow. Seems like they all are. I read if I change the driver, it would run faster.

I'm not much of a VB...

Works perfect, thanks ... very fast also

On the restricted servers I can execute a query, create temp tables, etc. Maybe I can create a sp on them but I'm not supposed to (pretty sure those...

All I have is read rights on a few servers (can't save a sp either to those databases). I'll just extract the data I need and move it. ...

Ahh ok, I though a function could be part of the stored procedure, that the reason for it was to make it easier to reuse that part of the code....

Jeff, yes. In probably 1/2 the databases I have full permissions, the rest I work with temp files.

I have to run this on a few different databases, some of which I only have read permissions. I'm assuming there is a way to work the function into...

Jeff that works flawless, can't wait to run it against the comment database. Thank you!

It is a neat tool. Would be interesting to run it against Sql Server...

I give, how does DelimitedSplit8K split the field MyData into single words?

CREATE TABLE #TempSplit

(MyData varchar(200))

INSERT INTO #TempSplit

(MyData)

SELECT 'My SQL skills are broken' UNION ALL

SELECT 'SQL Server Central rocks' UNION ALL

SELECT...

Jeff, which areticle has resources? Thanks.

Why not delete the table and recreate it.