Search results for query: *

Hi Everyone, I am using datename(quarter,getdate()) in order to find the current fiscal quarter. Is there an easy way to get the first and last dates in the current quarter? For example, if today is 8/6/09, then the first date in the quarter would be 7/1/09 and the last date would be...

Hi there, I am processing a table which has been populated over the years with invalid dates in the date fields - don't ask me how. Things like 9/31/2006 and stuff like that. Does anybody know of a select statement that could return a list of the rows with bad dates? Something like: select...

Hi everyone, Do you know if it is possible to call a Javascript function from a browser URL? There is a page which I'd like to call and automatically press a submit button after entering a value. In other words, instead of going to http://www.test.com/test.asp, entering "hi" and pressing...

Hi everyone, I need a formula that will return the date of the first day of the month three months ago. So, if this is January, I would need October 1, 2007 to be returned. I'm trying to do this, but it gives me an error: select Month(CurrentDate) case 3 : Date(Year(CurrentDate)-1,12,1)...

Hi Everyone, For ASP-based websites I usually create a login screen and then save the username in a cookie. However, my current project requires Active Directory authentication when the user first goes to the website. So they enter username and password. Taking them to a login page after...

Hi everyone, I have a form which submits several fields to another page. This 2nd page then inputs the values into a SQL table. The problem I've run into is that if I use some characters, like a single quote in one of the fields, the SQL will break. I understand why that happens, but how...

My Excel program started acting funny on Friday. When I go to copy a cell or cells, it slows down really slow, and takes 10 to 15 seconds to complete the process. Then if I paste, it takes another 10 to 15 seconds to do that. I can edit cells, delete and add rows and columns, and do...

Hi Everyone, Does anybody know what we can do on a 2003 Terminal Server which keeps changing the time every time somebody logs in? Apparently it has something to do with the Daylight Savings issue. Maybe some of the people logging in have 2000 machines... Either way, what happens is that...

Help! I seem to be in over my head... I'm just a beginner with Ajax, and I cannot figure out how to call a function on the loading page from an IFRAME within that page. For example, from a button. Look at the attachment to see what I mean. There are two buttons, one of them works, the other...

Hi, I set up a running total to summarize a field. It should be evaluated on change of the group. But not always, only if a certain criteria is met. It seems that I can EITHER use a formula as to when I want to evaluate, OR evaluate when the group changes. Is there any way to use a...

Hi, I have a large Excel spreadsheet with 50,000+ rows. At the bottom of each column, I would like to put the number of cells in that column that were not blank. Can't seem to figure out what kind of function to use... Any ideas? Thanks! Joseph

Hi everyone, I work with others on a terminal server and I'm tired of people installing little utilities and crap that slows the terminal server down. Also, the hard drive space gets low when people download stuff to their desktops. Does anybody know if you can somehow put the following...

Hi, How can I delete a certain number of rows from a table with no key field? Something like: DELETE TOP 292166 FROM TABLENAME This is a table I just imported into and I need to delete the first few hundred thousand rows and leave the rest. Any ideas? Thanks! Joseph

Hi Everyone, I have created some reports in Crystal XI. One of these reports has some data parameters which I want the user to input, like this: Start Date: 2007-03-20 End Date: 2007-03-26 By default, I want it always to run for the past week, while allowing the user to change it if they...

Hi everyone, I have the following columns and cells. A B C D E F G H I J ------------------------------------- 3 2 3 4 1 3 1 4 2 3 Then, I have a "master" cell which contains a value from A to J. Based on the contents of that cell, I would sum all...

Hi Everyone, I'm trying to use the following syntax to display a div tag on my ASP page. My goal is to be able to load it when the page loads and then load it afterwards when I press a button. <ww:div id="mylist" href="list.asp" loadingText="Loading list..."...

Hi Everyone, This is a question that has come up for me over the years. I wonder if there is anybody out there who has come up with a way to do this? Sometimes I don't know exactly what columns are in a table, and in order to find them I have to scroll through the whole table. select *...

Hi Everyone, I want to be able to run a SQL statement such as: samp c_orders and it will return the top 10 rows of the "c_orders" table. So I tried putting together what I thought would be a very simple stored procedure, but I cannot get it to work. I've tried everything I can think of...

Hi Everyone, I imported a SQL2000 DTS job into SQL2005 (it is located in "Management -> Legacy -> Data Transformation Services". I can run it manually, but I want to schedule it, so I migrated it to SQL 2005 (through the right-click menu option) and now I can't find it! Where is it located...

Hi Everyone, I know this has to be easy - but I can't figure it out. I want the last day of the current month. Basically, the counterpart to: Minimum(MonthToDate), which returns the first day of the month. If I use Maximum(MonthToDate) it returns the current date. Help!!! Thanks, Joseph