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

Thank you so much. That worked out perfectly. I used the bit.

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

Yes. That did work perfectly. Thank you so much.

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

Thank you. That worked fine. I knew there was a way.

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

Ok. Would I create that as a view, or a function, etc. I'm not too sure. If it is a view, will I be able to save the records from within the app?

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

Thank you monsnake, that worked out perfectly. I'm sure all of the suggestions would have worked fine, but I chose yours first and that worked. Thank you so much.

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

thank you. the substr worked great. I knew there had to be a way, just couldn't figure out the nomenclature.

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

Thank you, that worked out great.

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

OK. I tried that and I got an error: Could not insert new row - duplicate value in a UNIQUE INDEX column. Not sure what that means.

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

Wow, that was easy. Thanks a million.