That sounds like the best solution. You could always use an ActiveX conversion to cast the data into a decimal format, but it would probably be slower.

Steve Jones

steve@dkranch.net

What a great T-SQL trick.

Thanks for sharing!!

Steve Jones

steve@dkranch.net

The default for SQL Server is only potr 1433 (TCP). Enterprise manager is another story, it uses 445 (I think).

If your ASP page needs access, then whoever controls the...

Strange. The isql/w call is the same as the ADO call?

Can you script an ASP page and enter the exact same call in both the page and isql/w and see...

Glad we could help. Rather than full-blown SQL Server, if this is a small app, use MSDE. Basically SQL Server light and do not provide any of the client tools....

Thanks for the info.

Steve Jones

steve@dkranch.net

Same here. No problems, but not used extensively. Mainly because of the $$ involved.

There are some reports of problems in these forums. Searched on "named instances"

Steve Jones

steve@dkranch.net

Not that I know of, Andy?

Steve Jones

steve@dkranch.net

Don't connect in global.asa. Put the connection string there and then reference that on each page as Jon suggested.

Steve Jones

steve@dkranch.net

Never tried this. I do all the DTS work. I'll take a look.

One thing off the top of my head is to save as a COM file and allow someone...

I like Jon's idea.

Steve Jones

steve@dkranch.net

Two ideas,

1. Use a temp table/table datatpye to loop through the time interval and count each time,

2. Build a temp tabel of ten minute intervals. Join this to your...

BTW, thanks for removing the sa login

Steve Jones

steve@dkranch.net

Can you connect from ISQL/W using this login and execute the stored procedure?

You might also run SQLTrace and see the exact call. Perhaps there is something you are not noticing...

Personally, I vote for people skills first. Can't really teach those, I can teach all teh SQL stuff. Of course, the skill level depends on how motivated I am to...