Recent content by nakkii

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