Search results for query: *

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

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

I have data in several fields that need comma separated and combined in one field. I will called the output field MyResults MyReults will begin with F1 for field01, F2 for field02, and so on. The data in MyResults should not begin or end with a comma. Below is code to create the table and...

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

I am seeking a query that will return the last item (max) based on a set. The personID is the same for several records. I would like the last record for each. For the 1st person (1458748) the nameid I'd like to return is 1405 and the name lastname is Smith. In short, there are 6 sets in...

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

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

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

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

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

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

Looking for a script that can read an environmental variable and then display it. Also, looking for a script to write to one. Would like to be able to test interactively. Jim

I want to create a website that will link to an a web bases exam simulator with a set number of questions and length of time. For example, 100 questions in 2 hours. I'd like to be able to add tests and categorize the questions. Example: TEST 1 (Sports, Music, Math, Science) I'd like for...

We have a SQL Table with over 155 million rows covering about 10 years. We want to delete out all by the current 4 years worth of data but are concerned it will overfill the log. Is there a way to delete these records without logging them to the log file and/or do you have another suggested...

I have an application that uses a content switch that directs to 2 web servers. When using the content switch, the application hangs when opening a java popup using IE, but not other browsers. The application also works correctly if the url contains the names of one of the 2 web servers...

I want to show a time elapse on a form. The time will continue to show starting at 00:00 and then go up by 1 second intervals: 00:01 = 1 second, 01:01 = 1 minute 1 second, etc.. The timer control is the best option, but how to implement to show the time as I mentioned and stop with the elapse...

A legacy vb app that has been convert .net has landed on my lap to make a change to and install on a user's pc. It is a "fat" app. It runs fine on my pc but when I publish the project and the try to install in on the user's pc I encounter the following: Unable to install or run the...

I just upgraded to Visio 2013 and opened a document that contains a flowchart. Several of the boxes have comments added to them and when you hover over the box the comment is supposed to popup. This works fine in older version of Visio but it not working in my new version. I suspect it is a...

I am cleaning some legacy data and have noticed there are individual in the Database twice with the same 9 digits in their social security number (SSN) but 2 of the digits are reversed, probably because of a keypunch error. I am looking for a way to identify people with the same 9 digits, but 2...

Our database is SQL server. Our naming convention is CamelCase and do not use underscores. A contractor is creating a database (warehouse) and it will primarily use SASS to access the data. The contract used a naming convention as: FIRST_NAME, LAST_NAME, etc.. Tables are perfixed with DIM...