I just split these up into two SSIS's since I cant spend anymore time on it but I would still like to know if anyone has an answer. Is...

If anyone has any thoughts at all on this I would greatly appreciate it.

Can you explain the math at work in your examples. For example

-->record 2 ,

Collection = 800,

Other_Due = 300

Int_Due = 200

Princ_due = 100

So my Desired output should be,

Int_Adj = 0

Princ_Adj...

My recommendation would be to do this in the source. If you only need the first ten characters then put a substring into a select statement and use that...

Here is a link to a similiar post.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142181

Not really an opinion but I would highly recommend the product Neverfail for DR. It is in my mind a great product at a fraction of the cost of...

when you go through the removal process it should ask what features you wish to remove and I believe you can leave that.

Are you running this through somehting other than Microsoft SQL server? "{of" is not somehting SQL would understand to my knowledge. Also you have spaces in your table...

Just a thought but if you have to do more work to avoid creating an SSIS as a "on off" then it is still worth creating the SSIS even...

two links for you to look at

http://codebetter.com/raymondlewallen/2005/10/26/quick-t-sql-to-parse-a-delimited-string/

and

http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

try this

RANK ( ) OVER (PARTITION BY Datepart(week,schstrdt) ORDER BY Datepart(week,schstrdt))

Sorry I can't test this were I am currently but I beleive this would work.

Sorry not following can you give an example of that. I personally would remove the cursor function from your tool box of options and pretend you never learned about...

still missing the ON part of a few joins

Get in the habit of formatting your code as it can help spot the problems. you are missing 2 on cluases.

SELECT

a.GRGR_CK,

a.GRGR_ID,

a.GRGR_NAME,

s.SBSB_ID,

s.SBSB_LAST_NAME,

s.SBSB_FIRST_NAME,

e.CLCL_ID,

e.CLCL_CUR_STS,...

my recommendation would be to get a select working to correctly display the information as you will ant in to be displayed in your new table. Then just add...