Search results for query: *

Hello. I am using vb 2005 express w/ sql server 2005. I have a form with a combobox that lists several entry codes as well as the description of the entry code. Example: E1 - Original Entry E2 - Re-Entry into School etc... All I would like to store in the DB is the first 2 characters (E1...

Hello. I have a simple/stupid question (i think). I am setting up a table in SQL Server 2005 tracking employee demographic info. I have come to the gender field. I will be inserting two fields for this, a gender_male field and gender_female field. I need both of these fields to store the value...

Hello.I am working on a report to track absences from one db into my payroll db. The abscnece db creates a csv file that contains three columns: employee ssn, reason code, days absent. The first db does not contain any leave balances. The second db (an informix db via an odbc connection)...

Hello. I am working with CR9 and am using a informix db via an odbc connection and linking that to a csv file. I am only using one table from my database and it has two columns. One column is type, and the other is balance. I am dealing with leave balances and types. We have 3 types of...

Hello. I am working on a Visual Basic 2005 Express app with a SQL Server 2005 DB. I have several basic tables in my DB, all containing student data for my school district. I have one table with all of the basic student info, including leave codes, which is a 2 character code that is pretty...

Hello, I am new to SQL Server and I have a question. I am trying to develop a VB 2005 application that has a combobox with all of the possible termination codes. I would like the combo box to display: "code" - "description" (the code, then a hyphen, then the description of the code) I have one...

I am working with CR 9 and a postgresql db, and an odbc connection. I have created a report to track employee absences. This is a simple report consisting of the following fields: employee ssn,employee name, absent date, days absent, substitute the report is grouped by employee ssn with a sum...

Hello, I am working with an Informix DB and CR9 with an ODBC. I have one field (prep_obj) that is a string field with 8 characters. Imbedded in those 8 characters are 4 characters that I would like to pull out. ex. G2234628 is the raw field, and I need to pull out the 2234 (characters 2-5)...

Hello, I am trying to update a pay field on multiple employees based on their job class. The job classes are spread out all over the place so I have a need to use both the 'in' command and 'between' or 'to' command. This is what I have: update pay set pay_amount = 732 where job in ('0101' to...

Hello. I have a one table that contains pay type records for all of my employees. I would like to add one pay type to every employee but am not sure how. I tried this: INSERT INTO premppay (prep_emp, prep_pay) VALUES (6569, 759) but that only inserts the record into one employee (ee# 6569)...

I am using CR9 with an Informix DB used for payroll. I have one report that contains several key pieces of info. Location Hours worked Hourly Rate* Job Code** Pay Type code * The hourly rate is different depending on the location. ** The Job code is different depending on the location. The...

Hello, I am using CR9 and an Informix DB. I have a field that is all uppercase and I would like to change it to lower case. There is one problem with this, the field has multiple words in it and I want to keep the first letter of each word capitalized. EX: ANYWHERE HIGH SCHOOL to be change...

I would like to run a select statement and save the results of the statement as a csv. I know it is possible, but not sure how to do it. I am using this statement: select * from personalinfo I would like to save the results in a folder I have set up. Any help would be appreciated.

I would like to create a view of an entire table as is but with one exception. I would like to change the format of the SSN field. I would like to add the dashes into the SSN field, and select every other field in the table and create that as my view.

I would like to create a view that is essentially the entire table, but with one exception. The original table has the SSN w/out dashes, and I would like to create the view to have all data fields including the ssn with the dashes. Any help would be appreciated.

Hello. I am working with an informix db and am trying to add two new deduction to every employee that is in a specific group. I have one table, deduction, that I need to add a deduction code (2020) to every employee in group 'B'. The group is stored only in the employeemaster table. The common...

Hello. I am working with an informix database and need to update using an innerjoin. I have one table: deduction that I need to update one field, the active field. I need to update every record for one group of employees only, but the group code is in another table, the employeemaster table. I...

Hello, I am new to sql and am trying to do an update statement using an innerjoin. I am in my payroll database and need to update a field in the deduction table, but need to only update one group of people, and the group id is only in the employee master table. The common "thread" is the...

I am working with CR 9 and an Informix DB. It is my payroll database, and I am working on a report using the previous year's salary amounts. This information is store only in an audit table, and is stored as a string, even though the salary is numerical, it is storing it as numerical text. I...

I am new to the postgresql "game". I am trying to clean up some data in my database, mainly addresses. What I would like to do is change every instance of 'First' to '1st' in the address field. Ex: '325 West First St' to '325 West 1st St' Is it possible to update just a portion of a...