I am using 2008 R2 and I am not able to run above query. I am sorry.

above result I am expected.

Thank you.

+-------------------------------------------------------------+

¦ t_mcno ¦ t_citg ¦ t_trdt ¦ t_shft ¦ t_wght ¦

¦--------+--------+-------------------------+--------+--------¦

¦ F03 ...

As I mention,

Mcno ItemNo Date shft gram

F03 1010042016-01-12424.76

F03 1010042016-01-1230.00

F03 1010042016-01-1220.00

F03 1010042016-01-12124.70

F03 1010042016-01-11424.76

F03 1010042016-01-1130.00

F03 1010042016-01-11224.40

F03 1010042016-01-11224.40

F02 1010042016-01-11424.40

F02 1010042016-01-11324.40

F02 1010042016-01-11200.00

F02 1010042016-01-11100.00

I am looking for below result. I am looking gram...

USE [rptdev]

GO

/****** Object: Table [dbo].[TBRTEK002] Script Date: 2/8/2016 1:56:36 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TBRTEK002](

[t_mcno] [char](6) NULL,

[t_citg] [char](6) NULL,

[t_trdt] [datetime] NULL,

[t_shft] [char](3)...

USE [rptdev]

GO

/****** Object: Table [dbo].[TBRTEK002] Script Date: 2/8/2016 1:56:36 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TBRTEK002](

[t_mcno] [char](6) NULL,

[t_citg] [char](6) NULL,

[t_trdt] [datetime] NULL,

[t_shft] [char](3)...

USE [rptdev]

GO

/****** Object: Table [dbo].[TBRTEK002] Script Date: 2/8/2016 1:56:36 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[TBRTEK002](

[t_mcno] [char](6) NULL,

[t_citg] [char](6) NULL,

[t_trdt] [datetime] NULL,

[t_shft] [char](3)...

Thanks for your reply.

Well ,Backup and restored that was my first though .But we would like to use on daily basis.

I don't know, where is the citrix server....

OK.

Thank you.

Thank you.

@ SSC-Enthusiastic :

Thanks for your help. I think, that will work. let me try.

Thanks

Bhavesh

Please, Any help on this ?

Only One Server

Thank you so much

Thanks for your reply.

But

SELECT

ID,

MAX(CASE WHEN ItemNumber = 1 THEN Item ELSE '' END) AS [1],

MAX(CASE WHEN ItemNumber = 2 THEN Item ELSE '' END) AS [2],

MAX(CASE WHEN...