As you can see, this gets you very close. With some case logic you can delete the decimal points from 10. and 20. And I assume you want numbers less...

I did the function below some time ago and it should be valid for what you need.

It is based on a table which actually contains many hierarchical structures. Thus

the function...

Went to BOL and ran what you see below. Thus:

1. Load your CSV file into Excel

2. Insert a blank row in the beginning (apparently needed - don't ask me why)

3....

What's fOK and cnnlocal? Which of them are the ADO connection object?

I guess you meant sp_readerrorlog not xp_readerrorlog. However, the ID column always seems to be zero.

I think you need to remove the rstADO.Requery line. I have never used it in this context and reading up on it quickly seems to pretty much convince me that...

I have seen your and other people's comments regarding breaking up big operations. On the one hand I'm anxious to try this one day, on the other hand I hope...

IVR or not IVR, set based or not set based, it's still hard see the real problem. Thus in your description you mention a single table. Who/what adds rows to it....

Lets say status=0 means its available and status=1 means its no longer available. Then the query 'select min(recid) where status=0' should do the trick.

You would then do an update of...

Assuming that f1 and f2 are varchar, the most direct equivalent in SQL Server would be:

select * from table1 where f1+f2 in (select f1+f2 from table 2)

My guess is that he is doing cross database queries and he wants his stored procedure to automatically detect this and dynamically determine the collating sequence to make the sql work.

So if I have two variables to manage then I would have

EXEC sp_executesql @sql, N'@res1 varchar(255) OUTPUT,@res2 varchar(255) OUTPUT', @result1 OUTPUT, @result2 OUTPUT 

and this would cause @res1 to return in...

How about:

SELECT SUM(x),cust

from

(

SELECT x,case when name LIKE 'Z%' then 'NA' else name end as cust

FROM foo

) t

GROUP BY cust

Most smart DBAs will not allow you to do this. That's because the master stored procs can get updated when installing a service pack.

If you can get them to use...

One of these days I'll get around to Anlysis Services and DMX. I'm not sure how much they will help with this sort of problem. You need to find a...