Recent content by mark1110

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

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

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

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

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

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

I am using Sybase

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

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

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

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

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

Word Basic 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.

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