Thanks a lot Mr. Moden;

I was strongly cautioned by Evil Kraig F's and Omar Ismail's responses, so we've split the difference...development stops at visual studio. once the report is qa'd/uat'd...

thank you both very much for your help and advice, i appreciate it

drew

yes, i think that's because in the 'repivot the way we want it' you only went to Q6 instead of Q8.

if you take a second look at the posted data,...

i have a dopey question about the transformation.

in the original version there were 13 columns and 16 rows...208 data points, but the transformed result has 11 columns and 20 rows,...

Exactly.

Sorry for being inarticulate, and extremely grateful for your effort.

drew

Thank you so much for your reply.

I want to lay the succeeding quarters next to one and two...i want it to change from this

Charqtrpaidbilledineligiblecobcoinsurancediscountdeductibleeligible_chargesoutofpocketclaim_countrownumaffil

2009011003871.042983490.4356735.9993944.7645703.621456333.5932924.552487106.0367973.315690Q 1Par

2009021631516.065166318.12993929.28278631.4642428.182215296.0814562.643851329.281901.528580Q 2Par

2009031600802.044689056.471030679.68276915.7939780.461926753.037177.823341680.54-71740.238392Q 3Par

2009042601162.586422177.56915319.55273709.8672087.092603894.249246.615161061.0695570.429632Q 4Par

201001578005.611642349.86548470.19117469.19-23730.63581632.34421.971000141.11-24816.692152Q 5Par

20100237576.43211868.1158238.095980.92-8606.4845541.95-462.9556255.57-7735.72354Q 6Par

2010034419.76149506.2966227.8310155.2-1166.7486105.25-107.9574290-19392.3179Q...

thanks a lot,

i used my influence to get the installer to add me to sysadmins, so at least i can get in the house!

best

drew

will do

thanks very much

thanks very much.

i didnt know enough about the data to decide what the candidate keys were and which should be primary, indeed, if it were obvious, it would not have...

Slight improvement : -

;WITH t1 AS (SELECT 1 N UNION ALL SELECT 1 N),

t2 AS (SELECT 1 N FROM t1 x, t1 y),

tally AS (SELECT ROW_NUMBER() OVER (ORDER BY (SELECT...

thank you very much,...

i have had a charmed life because everything has been in one file all being backed up and restored by CommVault. Very few systems are on full backup with log...

thanks to y'all, i was able to answer my own question...took two days, but i work cheap.

i found the answer by construction;

I graphed the original data in Excel

I added an...

so i think that means file groups, because i dont think i get to control how the data is distributed to just another NDF, but the partition scheme maps partitions...

something LIKE this, but not this, because power(log(row_number... seems to make the increment lope along, but not with the characteristics of the first table;

declare @tally table (N int)

insert @tally

select...