that is awesome, I have to figure this "stuff" command out.  I like it.

ok I missed something. Until I can read and understand "stuff"
I have some account strings with NO group 4 and I just learned we have one group4 with 6...

that is good looking.  I have never used Stuff command.  Let me research, thanks

thanks for all the help.  and yes the code above worked perfectly.  I really struggle with date formatting so this was a big help.

partitionkey is a  field  in tdataseg
picture  below of table tdataseg

ok, got it, you are correct I was focusing on the INSERT side of the code, not the select side. I see my mistake now. Thanks I have about...

first, I will practice your two examples thanks. Second the code worked perfectly. I will research the WITH statement to understand your solution. Seems very similar...

ok I am still trying to get my result table to publish correctly. still not working. attached is a word document with the output updated to what I am...

After thinking about this, I have changed by mind. I think a better solution might be a daily rate where the CAD from 12/31/2015 - 1/30/2016 is then divided...

Yes that was from an earlier post, where the original file was going to be a daily currency rate. Now the file will be monthly for CAD and daily...

did you open the attached word document? It gives a detailed example of the output file. someone gave me instructions on how to post the output, using a...

Yes I have been told that a couple times now. most of what I am currently doing is updating prior code. So most of my questions revolve around...

Thank you so much. I am very new to this level of SQL usage. prior experience was all simple stuff. Never knew the Alter command. I used...

worked perfect. Now I just need to understand how it worked. thank you.

Yes as of now the from date and to date will be the same. one rate per day per currency.