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!

Recent content by mark1110

  1. mark1110

    Group By Question

    Will this Group By statement work with ANSI SQL: SELECT max(last_updated_dt) as max_dt, field1, field2, field3, field4, field5, field6, field7, field8, field9, field10, field11, field12, field13, field14, field15 INTO #temp_table FROM myTable GROUP BY field1, field2, field3 HAVING...
  2. mark1110

    FTP Adding Extra CR/LF After Every Record

    Hi, A user is FTPing a text file from a windows network file server to my HP UNIX server. When I receive the file it contains a CR/LF after every record. The file on his end doesn't have these CR/LF. Does anyone know why I would get these and what can I do to correct this? Thanks, Mark
  3. mark1110

    Need help with Group By in Query

    I have two tables I need to run a query on. The first is has a company code and code order, the second has the customer information. I need to run a query that just lists the minimum code order for a customer based on the company code. There can be several rows based on the customer id. I just...
  4. mark1110

    MAX function question

    Would it be better to say the following: SELECT field1, field2, field3, field4, effect_dt, field5, field6, term_dt, bus_type, co_id, field8, field9, field10 FROM myTable GROUP BY field1, field2, field3, field4, effect_dt, field5, field6, term_dt, bus_type, co_id, field8, field9, field10 HAVING...
  5. mark1110

    MAX function question

    Hi, I am writing a query that uses the max function. I have: SELECT * FROM myTable WHERE term_dt = '01/01/1900' AND bus_type <> "G" GROUP BY id_num HAVING effect_dt = max(effect_dt) AND co_id <> "001" ORDER BY id_num This seems to work, but I am not comfortable with it. Is there a...
  6. mark1110

    Update Question

    Hi I am updating a table and I am not sure update it based on a condition. I am using Sybase 11.92 I want to update from table1 to table2. Table1 has a field called term, it is either a Y or N. Table1 also has a term_date field. Table2 has two date fields, term1 and term2. I want to update...
  7. mark1110

    Update Question

    I am using Sybase
  8. mark1110

    Update Question

    I am updating a table and I am not sure update it based on a condition. I want to update from table1 to table2. Table1 has a field called term, it is either a Y or N. Table1 also has a term_date field. Table2 has two date fields, term1 and term2. I want to update term1 or term 2 on table2 with...
  9. mark1110

    Error Updating To SP1

    Hi, I am using windows 7 64 bit version and when I tried to update to SP1, everything downloaded fine, I disabled my spyware and virus protection, ran the file. It didn't give me any errors when it was doing the installation. The system rebooted and when it was applying the updates I got this...
  10. mark1110

    Getting Multiple Rows Into One

    I have a table that the following: Name Address City State Zip Phone_Type Phone Sample data would be: John Smith 1234 Fifth Street Chicago IL 60012 Home (312)5551212 John Smith 1234 Fifth Street Chicago IL 60012 Business (312)444-1212 John Smith 1234 Fifth Street Chicago IL 60012 FAX...
  11. mark1110

    Sybase 11 to Sybase 15 slowness

    Hi, I have an old VB6 application I am maintaining. We are migrating from Sybase 11 to Sybase 15. I am retrieving information from a stored procedure and populating several fields. The problem I am having is that when I run the stored procedure in Sybase 11, it runs and populates the fields in...
  12. mark1110

    Moving To Office 2007 Broke VBA Macro

    What I ended up doing is writing the following code to get the network path to the open document: Dim oDoc As Document For Each oDoc In Documents If InStr(1, UCase(oDoc.Name), "MYDOCUMENT") > 0 Then sPath = oDoc.Path + "\" Exit For End If Next Since MyDocument.doc is the...
  13. mark1110

    Moving To Office 2007 Broke VBA Macro

    Word Basic macro
  14. mark1110

    Moving To Office 2007 Broke VBA Macro

    The template is located in the \\Ac0gant053\Contract\Production\Winword\ directory, so I am trying to get the network path of the template. What I am getting is something in my documents and settings directory which looks like a temporary copy of the template word put there.
  15. mark1110

    Moving To Office 2007 Broke VBA Macro

    Hi, I have users who are currently using Office 2003. I have a line of VBA code that gets the current network path of a file: BASICDIR$ = WordBasic.[FileNameInfo$](WordBasic.[MacroFileName$](), 5) In Office 2003 this give me something like: \\Ac0gant053\Contract\Production\Winword\ However...
See more

Part and Inventory Search

Back
Top