Since I already attached the production database aren't the UIDs already changed?

I'm uncertain about the order of things to do.

First thanks for the response! Very much appreciated.

I only have the mdf and ldf files for the master db.

how should/can I restore them?

GSquared,

Thank you for the link. That helps alot.

The /*...*/ was put in by me because I copied that code out of a SQL trace file and did not have any...

I have determined that the values at the end of the script are the actual parameter values:

'USD','100106C','100106C',

'USD','2012-12-01 00:00:00','2012-12-31 00:00:00',

'USD','100106C','100106C',

'USD','2012-12-01 00:00:00','2012-12-31 00:00:00','2012-12-01 00:00:00' ,'USD'

,'USD','2012-12-01 00:00:00','2012-12-31 00:00:00'

,'USD','100106C','100106C'

,'USD'

the sp name makes me think this is a generic routine for calling programs.

prep and execute something. In this case a gross profit report by customer order.

I would like to...

Thanks everyone.

I really appreciate the help.

Hope you can forgive my ignorance.

-Todd

GilaMonster (8/16/2011)

Msg 2508, Level 16, State 3, Line 1

The In-row data RSVD page count for object "WM_PlannedSupplySummary", index...

Interesting....

If I get this message.

Msg 2508, Level 16, State 3, Line 1

The In-row data RSVD page count for object "WM_PlannedSupplySummary", index ID 0, partition ID 118081026523136, alloc unit ID 118081026523136...

Lutz,

My whole problem description was wrong from the beginning.

The commodity code needed to be trimmed.

Users apparently entered spaces at the end of the code when entering transactions.

It was the commodity...

Well that did not do the trick.

I can't do a sum on the i.QTY

Sorry,

The SUM(i.QTY) is not the problem.

It is the i.QTY used in the 90 Day value calculation

SUM(p.UNIT_MATERIAL_COST + p.UNIT_LABOR_COST + p.UNIT_BURDEN_COST + p.UNIT_SERVICE_COST) * i.QTY AS [90 Day Value]

What would be...

That worked for me too! Thank You

issue resolved

thank you

Frankly I would ask the person using the PRODUCT() function to explain what is happening in the expression used. It is unclear what the result/s should be. What is the...

Well here is a real world scenario

from

receiver_line rl

left outer join receiver r

on (r.id=rl.receiver_id)

left outer join receiver_line_del rld

on (rl.receiver_id = rld.receiver_id and rld.receiver_line_no=rl.line_no)

left outer join purc_order_line pol...