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

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

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?

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

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

I have data in a Pivot Table displayed as below: User ID $1-100 $100-500 $500+ 12345 3 1 0 12346 1 2 1 12347 4 0 0 12348 1 1 1 12349 2 1 1 TOTAL 11 5 3 The numbers in each dollar bucket represent the number of transactions by that user. So user_id 12345 had 3 different...