Hi all,

My sql table waas as follows

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Sales_Primary](

[TranDate] [datetime] NULL,

[SKU] [varchar](20) NULL,

[PriCustomerID] [varchar](10) NULL,

[DistributorID] [varchar](10) NULL,

[BusinessUnitID] [varchar](10) NULL,

[TranCode] [varchar](10) NULL,

[TranValue] [numeric](18, 2) NULL,

[TranNo]...

Hi,

I have a data like as follows

Trandate ProductID CustomerID TranValue

21-Nov-13 0233 GB10856 24

and i need...