Recent content by Distraction

I know that you can save an Excel file as a Web Page and check on the 'Interactive' box to allow users to access it. But I have a few problems. First, it seems that it requires IE, and won't work with Firefox. Second, the file I have is 5Mb...when I save it as a web page it blows up to about...

I'm guessing that only works if you're using Word as your email editor, right? If so, since I don't use it as my editor I don't think the style would carry over.

Combo - Can you elaborate a little?

That worked. So, if anyone else is interested, you could just build a list in notepad and then copy it into the Custom exclude list. The list could contain _a all the way through _z and a_ all the way through z_ and numbers, too. If it sees it once in a word, it ignores the word completely...

Nice thought. Unfortunately, it treats them as literals. So it will ignore *_* but not cust_id. But that's got me thinking. Maybe _i would cause cust_id to be ignored. Let me try some things.

I work in a data environment and am constantly sending emails with tablenames and columnnames in it, or snippets of query code. Is there a way to make the Spell Check ignore any words with an underscore in it, like 'cust_id'? It would be WAAAY too tedious to add every word to the ignore list...

We have like 75 nodes and many hundred amps. And still don't have the version with the 'Top' command.

Strangely enough, this is the only person out of thousands to report this problem. I thought it might be some kind of caching problem, like he entered a wrong password and it stored it, so I had him delete cookies, history, etc and try again. I even went so far as to create a new protected...

I have a website with some secure content on it. Users with passwords click on a link, and the 'Connect to blahblahblah' dialogue box appears, asking for User ID and Password. If a valid Userid/Pwd combo is entered, it goes to the site correctly. If one hits Cancel, or enteres an invalid...

OK...figured out the version. We're still using v2r5.xxx

Thanks, teradev! I think the other options all still do a full table scan. Now a real bonehead question...how do I check my version? :)

Doesn't qualify rank() over still do a full-table scan? I'd have to sort my result. The order by means I have to sort several hundred million records. I don't think that's going to speed things up.

How can I emulate the 'rownum < n' functionality from Oracle? I have several million records in a table. I just want about 5-10 rows. 'Sample' still does a full table scan. Mod-ing the numeric key still does a full table scan. Any thoughts?

either way

select (cast((statement_date - opn_dt month(4)) as float) + (case when extract (day from statement_date) = extract (day from opn_dt) then 0 else 1 end)) as Statement_Number The statement_date - opn_dt month(4) returns the number of months between. However it needs '1' added to it unless the...