Search results for query: *

Ok, we have a really strange issue here. We have a database on a SQL 2000 box that has a table called InOutStatus this table is transactional replicated to another SQL 2000 box. In this table there is a field called "EditDateTime" that has a default value of GETDATE() so it records the system...

Background: We have a very old legacy database that uses flat files, this database is our primary customer repository. We export text files every half hour (at the top and bottom of the hour) from this database and then SQL runs a DTS package every half hour (at the 1/4 and 3/4 hour) that...

I have a parameterized SQL Stored Procedure that performs an insert in SQL, when I try to the date I am getting and error: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. If I comment out the lines for the...

I am stumped on trying to write a query that will accomplish my desired output. What I have is two tables, the first contains an account number (and other specific details), the second contains a record of statements recieved. There should always be one statement recieved each year. I am...

Here is my code: ____________________________________________________ Imports System.Xml Module XMLMerge Sub MergeXML(ByVal XMLPath As String, ByVal XMLFile1 As String, ByVal XMLFile2 As String, ByVal XMLFile3 As String) Dim xmlreader1 As New XmlTextReader(XMLPath & XMLFile1)...

Here is my code: ____________________________________________________ Imports System.Xml Module XMLMerge Sub MergeXML(ByVal XMLPath As String, ByVal XMLFile1 As String, ByVal XMLFile2 As String, ByVal XMLFile3 As String) Dim xmlreader1 As New XmlTextReader(XMLPath & XMLFile1)...

We are a small company that has grown rapidly and is now faced with growing pains. We have a network that is primarily a W2K ADS environment running TCP/IP. The client machines have IPX/SPX because we have a two legacy applications that need to run on Novell. Analysis of our traffic is showing...

We are moveing an older database to SQL2000; the old data is coming in the form of text files, which we import every two hours. My question is: Is it better to create one DTS package with several data pumps (one for each text file), OR create a seperate DTS package for each text file? -R...

I am importing address data from an older database into SQL 2000. The address is in the form of "Denver, CO 80014", I am trying to separate the address into three columns. My first step is to split the string at the "," and take the first part and make it the City. Then take...

I am getting very frustrated with this. I have a bound control to an ADO Datacontrol, when the user clicks the forward or back button to change to the next/previous record. I want to check the value of the bound control and perform a function based on that value. The movecomplete event fires...

I have two tables Loaninfo and Loaninfo_temp, I want to update rows in the Loaninfo table with the values in Loaninfo_temp. Here is my update statement: Update LoanInfo Set Loaninfo.Broker1 = Loaninfo_temp.Broker1, Loaninfo.Broker2 = Loaninfo_temp.Broker2, Loaninfo.Broker2City =...

Can I perform a select statement that will return the value in one of two columns based on the value in one of the columns? Here's my situation: I have an Employee table with the columns FirstName, LastName and OtherName. The OtherName column is for nicknames or what the person goes by -...

I have a DTS package that updates the rows in a table every hour, the import is coming from a comma delimited text file. What I need to do is if there is a new field added to the text file, I want DTS to automatically add the column to the SQL (2000) table and then update all the rows...

I have a stored procedure on a SQL 2000 server that inserts a new record and some of the fields are allowed to be NULL. In VB6 using ADO I am appending/creating a parameter to be passed to the SQL Server, but if the user doesn't put a value in, it needs to be set to "NULL" explicitly...