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 derfloh 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: *

  • Users: jimoo
  • Order by date
  1. jimoo

    How execute JS

    Thanks for the response. I am hoping to find lightweight IDE. I have used .NET in the past but don't currently have it installed and would prefer not to unless I have to. I did a google search and found a few but don't know the difference between a good one and a bad one. Temporarily, I have...
  2. jimoo

    How execute JS

    I am have a basic understand of JS and I have worked with VB Script quite a bit so I am familiar with scripting languages. I have decided to explore my knowledge of JS further. Of course, there are lots of examples and articles. The basic question I have is what is the best way for me to...
  3. jimoo

    How to set variable to field in current row

    I found a crude way of assigning the variable to an attribute on the current records, but it's not very clean. It required me to select all the data into a new table (temp) and include a row number using the ROW_NUMBER function. Since my data table is < 500 records and it is already sorted it...
  4. jimoo

    How to set variable to field in current row

    I am trying to set a couple of variables to equal the field values of the current record so I can process that information. I put together sample code that creates a temp table and has 2 attributes (animal & breed) and I would like to set the variables myAnimal and myBreed accordingly based on...
  5. jimoo

    Need to Comma Separate Multiple Fields together

    This is close to what I want but I don't want the leading comma when field01 is empty. I can use another script to update the field from postion 2 on if it begins with a comma. It's just not as elegant. SELECT IIF(field01 = '','','F1-' + field01) + IIF(field02 = '','',',F2-' + field02) +...
  6. jimoo

    Need to Comma Separate Multiple Fields together

    Note: I missed 2 of the insert statements. Here is record 6 and 7. INSERT into aaTemp Values (' ','','','','','') INSERT into aaTemp Values (' ','B','','','','') Jim
  7. jimoo

    Need to Comma Separate Multiple Fields together

    ...INSERT into aaTemp Values ('J','I','C','E','F','') INSERT into aaTemp Values (' ','I','A','E','F','') View Data. select * from aaTemp [!]Attention![/!] EXPECTED RESULTS Output 1: F1-A,F3-Z,F6-X Output 2: F1-A,F2-B,F5-K,F6-Y Output 3: F2-B,F3-A,F4-D,F5-K,F6-Y Output 4...
  8. jimoo

    Unexpected Join Results

    Andrzejek, Unfortunate. That isn't it. This a legacy database imported from AS/400. There are no primary keys or foreign keys per se. The data is linked by fields containing business data. I masked the table an fields since it is company data but the data is linked by a caseid (case...
  9. jimoo

    Unexpected Join Results

    parent table (p) has 569,275 records and child table (c) has 633,283 select count(*) from parent -- 569,275 select count(*) from child -- 633,283 All parents have at least 1 child select p.* FROM [parent] p where p.pID in (select cid from child) -- 569,275 matches parent count Why...
  10. jimoo

    Seek Max record of a Group

    Thanks Andy, I'll give that a try. Here is what I ended up doing. It isn't elegant and took 2 queries and couple of temp tables but it worked: SELECT ParticipantID,MAX(NameEntryID) as PNameEntryID INTO #temp1 FROM NameEntry GROUP BY ParticipantID; select p.ParticipantID, p.NameEntryID...
  11. jimoo

    Seek Max record of a Group

    ...by the personid/nameid field or personid/modifiedon field, both should produce same result based on this data. I marked the expected value with * at the end of the group. Any suggestions for retrieving this data? NameID lastName middleName firstName PersonID...
  12. jimoo

    I am trying to get a list of all

    dhookom - This worked perfectly. Thank you. Jim
  13. jimoo

    I am trying to get a list of all

    I am trying to get a list of all tables and counts for a data conversion project so I can work to eliminate tables with 0 records and identify core child tables. Below is code that I put together that retrieves a unique table names from the database and has a field named cnt (count) for me to...
  14. jimoo

    Export Many SQL Tables to Excel

    I am pulling 20 tables in a spreadsheet. I can do one at a time for a total of 399 files. The number of files per sheet isn't the issue. The issue is the manual process and is there a way to automate this? Jim
  15. jimoo

    Export Many SQL Tables to Excel

    I am using SQL Server 2012 and Excel 2016. I need to export all tables in a database that end with the word "type" to excel. I queried the database and got a list, and I was able t do it using the export tools, but that wasn't efficient. I then did it from excel data tab and selected the tables...
  16. jimoo

    Odd Julian Date to Gregorian / Calendar Date

    gmmastros, excellent. This is exactly what I am looking for. I had found several variations but none of them worked, but your example did. I even tested for leap years and it worked perfectly. Jim
  17. jimoo

    Odd Julian Date to Gregorian / Calendar Date

    I have some data that came from AS/400 DB2 and it contains julian date data that is described as INT (7) and I need to convert it to a normal calendar date (gregorian). Here is a format of the data. This would represent 10/27/1960 1960301 - should be converted to 10/27/1960 1977308 -...
  18. jimoo

    Excel to DBF

    I have not used Foxpro for several years and a friend has asked me a question that I don't recall for sure. He is trying to use Foxpro exclusively to convert an excel file to DBF. In the past, they have used Access as an interim but are trying to get away from that for a few reasons. If my...
  19. jimoo

    Quality Certification

    I don't know if this is the right forum, but I don't see a section about Quality under the certifications forum so I will try here. Does any have any recommendation on which body to use if one is seeking a quality certification. For example, I found the following: 1. Certified Associate in...
  20. jimoo

    Exam simulator

    I am considering launching a site with an exam simulator. Does anyone know if there is one out there that can be used? The simulator would have to provide me a way to add / update questions and seen results. Jim
    • jimoo
    • Thread
    • Replies: 2
    • Forum: PHP

Part and Inventory Search

Back
Top