Sean :Thanks for suggestion...:-)..

Jason : Thanks You to review and give suggestion......(If you can find any other please let me update)...:-)

Yes You are right because primary key created on TableName and Columnname Column......

and I am inserting same tablename and columnanme into table .But I have to ,this the business...

Thanks to reply me back.......

Below is my primary key script

/****** Object: Index [PK_T_TBLMAINT_COL_COMMENTS] Script Date: 06/07/2013 12:48:38 ******/

IF EXISTS (SELECT * FROM sys.indexes WHERE object_id...

Hi Linda and thanks to give me suggestion.

es You are correct we are using that way but I found another solution as well with custom code.

I am posted here might...

Thanks to everyone for giving me better suggestion and yes I am using SSRS.

I will try all your possible suggestion and If it is not working out or have problem...

Below is which I actually getting result set (it is just few rows here...)

YearMonthFirstofMonthApptTimeStampFromIDApptTimeStampToIDTotalDuration(No column name)FacilityIDDoctorID

201212012-01-0112231222351562

201212012-01-011225383015123

201212012-01-01124836511510

201212012-01-01128151891513

201212012-01-0112149261481545

2011122011-12-012326962370145

2011122011-12-012325511333168

2011122011-12-012314234169174

2011122011-12-012314410199197

2011122011-12-01238911132

2011122011-12-012315492202180

2011122011-12-01231875827215

2011122011-12-0123410148137

2011122011-12-012310983156198

Above if my facility table and sample data .And add to one more thing.....I got result set with my Stored Procedure combination of TimestampID like

1 to 2

2 to...

/****** Object: Table [Common].[t_Facility] Script Date: 02/04/2013 12:41:15 ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Common].[t_Facility]') AND type in (N'U'))

DROP TABLE [Common].[t_Facility]

GO

/****** Object:...

I come out with something using cursor but still I am not satisfied with result.Below is my code..

/****** Object: StoredProcedure [Common].[p_ApptDuration_Monthly_Populate] Script Date: 01/31/2013 15:07:35 ******/

SET...

Desired Output:-

Suppose ApptID:-1442640

ApptTimeStampFromID ApptTimeStampToID TotalDuration(sum (Mins of Timestamp))

1 (Schedule) ...

we calculate time of duration depends upon Appointment TimeStamp type.

business logic behind is client wants to see how much it will taking time between appointment type for patient Appointment.

(Schedule...

Sample data for t_Appointment

INSERT INTO [t_Appointment]([ApptID]

,[ApptCode]

,[ApptDate]

...

CREATE TABLE [Common].[t_Appointment](

[ApptID] [int] IDENTITY(1,1) NOT NULL,

[ApptCode] [varchar](50) NULL,

[ApptDate] [date] NULL,

[ApptTime] [time](7) NULL,

[ApptType] [varchar](10) NULL

CONSTRAINT [PK_ApptID] PRIMARY KEY CLUSTERED

(

[ApptID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

/* Sample Test Table */

CREATE TABLE [Common].[t_Visit_Monthly](

[ItemID] [int] IDENTITY(1,1) NOT NULL,

[Year] [bigint] NULL,

[Month] [int] NULL,

[FirstOfMonth] [date] NULL,

[VisitTypeID] [int] NULL,

[DoctorID] [int] NULL,

[FacilityID] [int] NULL,

[TotalVisits] [bigint] NULL

)

/*Insert Sample Data*/

INSERT INTO [Common].[t_Visit_Monthly]

...

I really appreciate to taking time to look this.

Please can anyone help me out?