I have been learning a lot about FOR XML, Pivot, and Unpivot in the past few days.  I believe I have what I need using those tools.
I was able...

Oh, by the way, I have another table that contains the number of Indexes in each site, or rather lists the names for each index along with the index number...

Is it a memory hog?
Would just a decimal(10,5) be better?

SELECT
  t.Job_Prod
  ,t.Job_No
  ,TrDate = DATEADD(DAY, sc.ItemNumber -1, t.Act_Start)
  ,[Hours] = MAX(CASE WHEN trk.tType = 'A' THEN CONVERT(FLOAT,sc.Item)...

Jeff,
I was just wondering if you used that same test data and found the same results with 0's where there ought not be, when not using the STUFF function.

Jeff,
First let me say thank you for taking the time to reply to my post.  Thank you to all of you who have taken time to assist a nearly...

Jason,
OMG! 300K+ records output in 6 seconds versus what I was doing which took between 1 and 2 minutes.
I've checked a few records so far and they match...

Given this sql code:

USE TEMPDB
GO

IF OBJECT_ID('dbo.TABLEA','U') IS NOT NULL DROP TABLE dbo.TABLEA;

CREATE TABLE TABLEA (
    [Job_Prod]        varchar(100),
    [Job_Id]        varchar(16),
    Actual_Start    datetime,
    actual_Track    varchar(1000),
    pieces_track    varchar(1000)
)