Recent content by ScrewBalll

Hi There, I'm assigning categories to a new email before emailing it around the company. Rules can then act on these categories and process them accordingly. This works fine when the users are on the same exchange, but as soon as an email is sent to an outside user not on the domain the...

There was a missing refernece to the Outlook library. Changing this solved the problem, it was a bit unexpected though as the UCase() function has nothing to do with the Outlook library. Ah well. Cheers for your help.

Thanks for the quick response. It appears that the reference is correct. But I can't determine whether the VBA Libarary reference is perhaps an international version rather then English. I read somewhere that some of the string literal functions such as UCase may not work on international...

Hi There, I've been working on an Excel app which works fine when the user has the English verison of Office installed, but problems arise when a foreign version is used. The main problem seems to lie in some of the functions contained within the VBA object library - in particular the UCase()...

Hi Guys, I'm in need of some help with regards to filtering the options in a drop down based on the value of a radio button (i think I want to hide and show them as appropriate). I'm using asp to return a recordset of makes and models of cars, initially all the models populate the drop down...

Thanks, I ended up changing the delimiter to a '\t', it's a shame there wasn'tan easier way around it.

Hi there, I'm in need of some help. Does anyone know of a way to implement escape characters in a BCP load?? I have a comma delimited file which I can usually put into my DB fine, but when a ',' pops up in an field it causes the whole thing to fall over (truncation error on load). I've managed...

Ah brilliant, thanks

Hi there, Just a quick question: Is there any way that you can execute a DTS package from a stored procedure? I'm pretty sure you can't but I just want to check to make sure. Thanks

Hi There, I'm in need of some help regarding creatiung a map in Biztalk. I want to map one flat file to another, unfortunately there isn't any heirarchy created in the source schema so I need to try and implememt some relationships. Probably best to show an example. I have a source file...

Hi there, There will be approx 1 million values in either table. So you see with the cursor iterating through them it takes a long time. Also this example is much simpler than the actual problem as this is an example for 1 product. There will be lots and lots of product prices coming through...

Cheers for your advice, I just used the 'FETCH cursor1 into @Type1, @Date1 --InitialValues for loop' statement to produce the initial values (As I need a starting date to calculate my first period from), thinking about it i could use it differently, but I dont think It wuld speed things up...

Hi All, I've got a problem in that I want to carry out a procedure without using a cursor. The problem I have is that I'm importing a price and a validity period into a table. If the validity period falls within another period then I want other records created to explain the behaviour...

Hi there, I'm in dire need of some help regarding an import that I am carrying out. The general idea is that I'm importing a price and a validity period into a table (pricing condition). If the validity period falls within another period then I want several records inputted to explain the...

Thanks for your help, I ended up using: DATE = select (dateadd(wk,WEEK ,0) + dateadd(yy,(YEAR-1900),0)) - 5 - datepart(dw,(dateadd(year,(YEAR-1900),0))) The minus 5 was just to set the day to Monday. I know its not pretty but it seems to get the job done. Cheers for your help