BTW, the second column is the workstation datetime, the third column is the SQL server datetime.
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a...
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...
One more clarification: The legacy system contains close 1TB of data (not to mention all the custom user interfaces) of which only approx 1GB is being exported (hence the reason consolidation not an option) and all new systems are being done in SQL 2000 (soon to be 2005).
Persistence....Nothing...
Consolidation is not an option. Also the users are not updating both sets of data, they only update the legacy system, but the changes made in that data is triggering data changes in newer systems and is triggering automation of business processes.
I understand this is adding another step in...
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...
Nevermind <:-/
You must make sure your SQL SP Parameter names are exactly the same the in C# code when using SQLClient, DUH!
My problem was "ItemReminder" should have been "Task Reminder"
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is...
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...
:~/
Ouch, that threw a big monkey wrench in things... Trigger won't work for our environment (at least not easily) but running the job on the first of the month for the prior month Account Year End should work nicely.
Thanks again.
Persistence....Nothing in the world can take the place of...
left join table2
on table1.id = table2.itemno AND
table1.???? = table2.?????
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will...
Hmm, I like that. It needs to be a permanent solution able to provide reports in real time, so creating the job to run Jan 1 works. However you confused me on the trigger, what is the trigger for?
I created a table called tblAcctActiveYear and populated like so:
AcctNo ActiveYear
139...
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...
Thanks, for the two recent responses, but we upgraded/re-wrote the applications over a year ago to run on W2K, and the Novell servers have been retired.
Thanks.
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men...
Here's a little function I ran across, Hope it helps
Function OutlookAppointment(sAttendees As String, sSubject As String, dtStart As Date, lDuration As Long, lReminder As Long sLocation As String, bRecurrence As Boolean) As String
Dim oAppointment As Outlook.AppointmentItem
Dim...
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)...
In VB.Net you can do this:
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)
Dim xmlreader2 As New...
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...
Just some FYI for those who might want it.
Here is a brief list of Environment variables for NT, these are also stored in the registry:
COMPUTERNAME - Network name of computer
COMSPEC - Path to NT command Shell executable
HOMEDRIVE - Drive of home directory
HOMEPATH - Path to home directory...
[blush]
Never mind, I found the problem......
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.