Search results for query: *

I need to declare a new variable called @DATES to have a date field called INV_DATE from the table to be moved to the new variable field for comparison. I need to do this because while having the INV_DATE in the CASE statement in the SELECT statement, I will need to include the INV_DATE field in...

I am using Macromedia Dreamweaver MX 2004. I am able to connect to the web server which is MS Server 2003 using the SQL server conection. Somehow I was able to figure that out and now I am not sure how I did it. But I am getting the 'Http error code 500 internal server error' on a different...

Few of my databases has records of <Null> data in the fieldnames. I tried several ways of writing a code to delete those records but it will say '0 records affected'. Here is an example of my code to delete the records with the <NULL> data: USE PurchTransf DELETE FROM Whse2Data WHERE UnitsMTD...

I know how to use the inner join command on linking tables within a database but how will be able to link data between two different databases? The code I have shown below is receiving an error which is "Server: Msg 208, Level 16, State 1, Line 2 Invalid object name...

I am new to VB and I am enjoying learning this new programming. Anyway I am getting a runtime error '52' message on my screen which it says "Runtime error '52' Bad file name or number". I am not sure what it the problem is. I copied and paste my program which is shown below. Sub Openfile()...

There are spam emails sitting in my out imcdata\out folder with the mail from: postmaster@******.com. After reading a book on Microsoft Exchange server 5.5, there is a message filtering in the connection tab of the IMS which I added the email address of postmaster@**********.com. This will...