Cut and paste the following script into Query Analyzer and execute it.  I believe it will give you the results you are looking for.  If it does, it should be...

For a dynamic number of weeks AND columns that show the date you might try (note that I changed your table variable into a temporary table):

SET NOCOUNT ON

See if this might meet your needs:

  DECLARE @Dates TABLE (SeqNo int NOT NULL IDENTITY(1, 1),

                        DataDate datetime NOT NULL,

                        PRIMARY KEY CLUSTERED (SeqNo)

                       )

  INSERT...

I have just closed a case with Microsoft on this issue.  What you are experiencing is caused by OSQL padding the results to the defined width of the column.  For...

Assuming that the entire shelf must be made up of consecutive seq numbers then the following query should give you what you want:

  SELECT store_number, aisle, side, [section], shelf,

         MIN(seq)...