Database

procedure_Insert.Parameters.Add(
                new System.Data.SqlClient.SqlParameter("@picture",
                System.Data.SqlDbType.VarBinary, -1,
                System.Data.ParameterDirection.Input,
                false, 0, 0, "picture", System.Data.DataRowVersion.Current, null)
                );

select flavour,
    sum(case when period = 1 then crates else 0 end) as Period1_Total,
    sum(case when period = 2 then crates else 0 end) as Period2_Total
  from ReportSummary
  group by flavour
  order by flavour

Amit.Jagtap.nsk wrote:

this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections

update MMT set
    Value1 = T1.Value1,
    Value2 = T1.Value2,
    LastUpdateDate = GetDate()
  from MyMainTable MMT
  inner join #MyBulkInsertTable T1
  on T1.Id = MyMainTable.Id
  where T1.Value1 <> MMT.Value1 or T1.Value2 <> MMT.Value2

insert into MyMainTable
  select T1.Id, T1.Value1, T1.Value2, GetDate() as InsertDate,
      GetDate() as LastUpdateDate
  from #MyBulkInsertTable T1
  left outer join MyMainTable MMT
    on MMT.Id = T1.Id
  where MMT.Id is null