To steveb - It does doesnt it?

To Matt Miller -I am aware of that, however, I am under the assumption that i can simply encase it in a stored...

Yes - Specific Instructions are given to govern the specifics on how the lists are processed, so that they may be in accordance with certain ordinances/laws (I know it sounds...

Perhaps you are not understanding the details of the selection process:

If you are selecting 30 people

out of 100 possible people (they meet the criteria)

and the 100 is within the...

Lets say You have 100 seperate lists of a range of 25-50 people each. For the purpose of inputting the data, you compile all people into one list, organized by...

Why? For the purpose of the application I am trying to build:

Those metrics for counting and selection of people are in compliance to regulations on how the process of selection...

The test worked

Next week Ill give this a try adapted into my actual implementation and see if it works - Thanks abunch

thats ok, thanks for your suggestion, I just clarified by initial post, and it was my mistake of posting in more than one forum, I didn't know that many people...

The ordering will be done on a temporary table that has been pulled from the master list, that is the temp table /array list structure I was referring to.

The selections made and inserted into the Persons and PersonsAddress tables will be sorted in sequential order, in other words (after insertion):

For person table:

PersonID Order...

help please.

I have the following situation:

I want to populate two related tables

Person (PersonID, PersonName, PersonLName)

PersonAddress(PersonAddressID, PersonID, PersonAddr, PersonCity, PersonState, PersonZip, County)

from a table which contains all the data needed

MasterList(PersonName,...

help please.

I have the following situation:

I want to populate two related tables

Person (PersonID, PersonName, PersonLName)

PersonAddress(PersonAddressID, PersonID, PersonAddr, PersonCity, PersonState, PersonZip, County)

from a table which contains all the data needed

MasterList(PersonName,...

PLEASE HELP:

Speaking of loosing a job, I'm a junior level programmer and if I don't get the following issue figured out quickly - I might be in danger of...

PLEASE HELP: I AM TRYING TO USE THE FOLLOWING SCRIPT TO :

1. FOR EACH TABLE IN A GIVEN DATABASE (I am using a cursor for this)

2. FIND IF A COLUMN...

thanks for responding,

No its "to each his own" for each file - some text files are tab delimited, some are csv, some are | delimited. the same is true for...

please help me out:

I am trying to write a simple SSIS package that will take in a directory name, and using a for each loop process through and import data...