Search results for query: *

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

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

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

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

Hi there, I'm hoping someone can help me with a Date problem in SQL. From one database I am being passed two fields, a Year and a WeekNbr (1-52). From these two fields I have to construct a date for the begining of the week, ie Monday. For example if I'm passed the year 2005 and week 1, I...

Hi there, I'm in need of some help regarding updating an sql table from a staging table. I have a master table with approximately 25 populated fields, now this table is being sent updates which are placed into a staging table. The problem I have is that to save resources only ammended details...