title: SQL query for displaying product sales
body: <p>I have sales table which consists, ItemSize, GroupName, Quantity, ProductID, etc...</p>
  
  <p>Now I want to display sales according to following format</p>
  
  <pre><code>GroupName   ItemSize  Quantity   ItemSize  Quantity
  </code></pre>
  
  <p>means</p>
  
  <pre><code>BEER    350ml   500    650ml   1000 
  </code></pre>
  
  <p>How I can achieve this in SQL SERVER 2005 EXPRESS (T-SQL)? Thanks</p>
  
  <p>UPDATED:</p>
  
  <p>its my sales table structure</p>
  
  <pre><code>CREATE TABLE [dbo].[SalesLog](
  [SalesID] [int] IDENTITY(1,1) NOT NULL,
  [MemoNo] [int] NULL,
  [ProductCode] [int] NULL,
  [Quantity] [int] NULL,
  [Price] [int] NULL,
  [ProductGroup] [int] NULL,
      CONSTRAINT [PK_SalesLog] PRIMARY KEY CLUSTERED 
      (
          [SalesID] ASC
      ) WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>
  
  <p>its my Product table structure</p>
  
  <pre><code>CREATE TABLE [dbo].[Products](
  [ProductId] [int] IDENTITY(1,1) NOT NULL,
  [pName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  [pSize] [int] NULL,
  [pPrice] [int] NULL,
  [pPackQty] [int] NULL,
  [pGroup] [int] NULL,
  [pCode] [int] NULL,
  [pStock] [int] NULL,
  [pYrStock] [int] NULL,
  [pClearStock] [int] NULL,
      CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
     (
     [ProductId] ASC
     ) WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
  ) ON [PRIMARY]
  </code></pre>