Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nakkii

    Really, Really Strange replication problem/issue - HELP

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

    Really, Really Strange replication problem/issue - HELP

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

    Data import from .txt - Design Question

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

    Data import from .txt - Design Question

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

    Data import from .txt - Design Question

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

    Datetime format using SQL Stored Prodeure

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

    Datetime format using SQL Stored Prodeure

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

    SQL Query joining two tables.

    :~/ 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...
  9. nakkii

    Selecting non-existent rows

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

    SQL Query joining two tables.

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

    SQL Query joining two tables.

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

    IPX Broadcast problem

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

    How To add Appointments on Exchange Server?

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

    Problem merge XML documents with whitespace

    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)...
    • nakkii
    • Thread
    • Replies: 0
    • Forum: XML
  15. nakkii

    Problem Merging XML Documents with Whitespace

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

    How to merge two XML files??

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

    IPX Broadcast problem

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

    General DTS Design Question

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

    Get registry info like current user and ip address

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

    Problems with a DTS ActiveX Script

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

Part and Inventory Search

Back
Top