Search results for query: *

Got a strange one here. the person next to me is having problems with dates on his PC. It is manifesting itself in a few ways, I will list them here. The same problems do not appear for me when i run the same code. Just to confirm, his regional settings are set as English UK. 1) In excel...

I would love to work out how to do this unaided, but I need to get this sorted quick, so would appreciate some help here: I have been told I need a function to do this, so if someone could help me out. I have a DB table with the following 3 fields: ItemID, ItemName, ItemValue The form is a...

Using ASP & SQL: I have a table with: IDColumn, CostType , CostValue I have a populated drop down list that contains just the costtype. When someone selects one of the items it needs to put the costs into the text field. Im expecting its using the Onchange on the drop down list. What I...

i have been told that its very easy to put Iframes on an asp page, but... Everything on the website comes from a user selected ID which is request("campaignid"). so when the main page loads up, all the variables pulled from the database are displayed on the main page. I then want to have an...

I think I am going mad here, so if someone can help me out: Im new to .ASP and I am adding an IF statement to the submit button to Insert a new record if it is clicked. I have tried this both submitting to the same page and to another page, and I have tried Get & Post so I have the button...

Is it possible to put a case statement in a the group by part of a query? Below is an example of a query using the normal Datepart function for the week number, and then the ISO week function to get the correct week number. However in using the ISO function, you have to use a Case Statment...

I am looking to remove email address from text strings and replace it with the text (email removed). The email address' will not be in every string and the the domains will vary. e.g. fields named 'Comments' and an example of a field is: "what a sunny day said email@email.com yesterday" i...

I am looking for the best way to do the following: Each case in my database has a timestamp. Each date is part of an accounting month. This month does not correspond to the normal months. Therefore during the select statement I am looking to bring out the relevant book month for that date...

I use SQL 2000 version pack 3. When exporting to a text file from a varchar field (set to 2000 characters) it is being truncated to 255 characters. I have found the article http://support.microsoft.com/default.aspx?scid=kb;en-us;247527 which refers to this know problem. However they say it...

I have a batch process which posts a file onto an FTP site. I am new to this so bear with me. It works perfectly when I run the BAT file itself, however when I try and run it though an Execute process task it fails giving the message: CreateProcessTask'DTSTask_TSCreateProcessTask_1':Process...

I am looking to do the following using SQL 2000. I have a Brands field and a Reason field. Each row has one brand and one reason. I want to find the Top 3 for each brand. I have tried a count, with a top before it, and group by, but it only delivered the top 3 across all brands. Any clues...

Is it possible to have conditions within the select part of the query? I.e. the data I want in column is a yes or no for each row of returned data. This would depend on a formula and condition. Is it possible and how? (SQL 2000) I do not mean an If..else with different queries. N

Is there a quick way to have a DTS export running every day, but not wipe over the file it creates? I.e. to add a date parameter to the file name. Your help is appreciated, Im new to this. N

I am looking to remove carriage returns from a text field for 1800 records. I can find all rows that have carriage returns by the following query. like '%' + Char(13) + '%' But I need to know if there is a way to remove all the carriage returns and replace them permamently with a double...