Search results for query: *

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...

Hey y'all I need some proc sql code that will take two dates and tell me the months between. Piece of cake for me in Teradata SQL, but a challenge in SAS. :) I'm trying to calculate Statement Number. I have the date the account was opened (Open_Date) and the date of the Statement...

Well, I ended up recreating the table with an Identity column then selecting * into it. Not the workaround I was looking for, but effective in this situation.

Hello! I am making some updates to a table, but can't because of a unique constraint. I have some 'empty' columns that I can use to assign a unique number to, so that then I can make my other updates. Is there a quick and easy way to update this empty column assigning a unique (or...

OK...I came up with my own klugy fix. I created a separate sheet to summarize the Pivot Table data. I created a row of formulas using the GETPIVOTDATA function which pulled the TOTAL of each bucket. Then I did a (COUNTA(range))-1 function, where range = the user_id column starting with where...

That's what I did to begin with...the data in the first post is the Pivot Table you recommend, with the buckets added across the top. I'm no too worried about the date format...not planning on doing a whole lot with it. Mostly I want to be able to figure out what the average number of...