You are the man, thank you very much! I'll try this in the morning and let you know.

Thanks,

Jordon

awesome, I will try that! So, would I put that in a ssis package and schedule it, or is there a way that I can put it in sql...

Can't really do a restore, the tables are completely different. Whenever a employe is created in the HR system, there are many things like employID, name, address, spouce, sex,...

The issue is, both of these products are canned applications and I can't change what's being posted to the database, just trying to expand their flexability in the backend.

Just looking at this, I can create a SSIS package the pulls from the one table and then post to the other table, but how do I create it where...

It could happen every 24 hours for all that matters. I'll look into the SSIS package. I've used one of those before to import data and I'm sure...

All I'm doing is when a new employee is created in our HR system, I want that new employee to go to another system, without having to do a manual...

mtassin (8/7/2009)

Hmmm with names like those... let me guess.. Great Plains?

I find it sad that Microsoft makes very poor design mistakes like this stuff.. I'm getting used to...

Actually, the primary key is the EMPLOYID, but its not unique. I know, I was like "What????" Anyway, what you did worked perfectly!!!

Thanks,

Jordon

Ok, so I think this project is getting harder than it needs to be; however, I had another hick-up in the plan. I had this working perfectly, using this...

Thank y'all very much for your help! I do believe that I've got it figured out! Y'all are awesome!!!

I'm really new at T-SQL. I do have a background in PHP, so I know programming and I know SQL, just T-SQL is new for me, so I'm not...

USE [db_table]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[UPR00900](

[EMPLOYID] [char](15) NOT NULL,

[GROSWAGS_1] [numeric](19, 5) NOT NULL,

[GROSWAGS_2] [numeric](19, 5) NOT NULL,

[GROSWAGS_3] [numeric](19, 5) NOT NULL,

[GROSWAGS_4] [numeric](19, 5) NOT NULL,

[GROSWAGS_5] [numeric](19,...

I appreciate the suggestions, just not possible. This is a Microsoft product that we can't edit how the tables are setup, because of how the program was writen. ...

Also, I'm not limiting my records, so if I run the loop, I want it to return for all records in the table. Meaning, if I run the report...