Thanks,

ssm

The data type of column is varchar(512),

Sample values are

1/7

1/8

1/6

1/9

I need to divide by these ratios.

Thanks,

ssm

yes,these are table names.Basically these queries are run across many such seedTable,testtable pairs.

I get configvalues from these tables based on certain configname values and update into a temporary table which...

dateClosed Column can be Null, is that OK?

hi ,

no, there is no index on the dateClosed & deleted,deleted is bit.

primary key is cycleName in tbl_cycle

on tbl_execution_time hourly primary key is

[cycleName],

  [framework],

  [toolName],

  [taskName],

  [targetName],

  [execDate],

  [execHour]

Thanks a lot,

sudha

Hi,

  |--Compute Scalar(DEFINE[Expr1004]=Convert(Convert([ET].[StressTime])/3600)))

       |--Sort(ORDER BY[ET].[cycleName] ASC, [ET].[framework] ASC, [ET].[toolName] ASC, [ET].[targetName] ASC, [ET].[taskName] ASC, [Expr1003] ASC, [ET].[execDate] ASC,...

hi,

I am not able to save or copy execution plan.how should I do it?

thanks,

Sudha

REATE VIEW dbo.view_machine_hours

AS

SELECT     TOP 100 PERCENT cycleName, framework, toolName, taskName, DATEPART(ww, execDate) AS WW, execDate, execHour,

                      SUM(CAST(StressTime AS decimal) / 3600) AS MachineHours, targetName

FROM         dbo.tbl_execution_time_hourly

WHERE     (cycleName IN

                          (SELECT     [tbl_Cycle].[cycleName]

                           ...

CREATE PROCEDURE dbo.prc_indicator_get_machinehours

@cycleName varchar(50),

@Framework varchar(50),

@toolName varchar(50),

@sortOrder varchar(200)

AS

SET ANSI_NULLS OFF

SET NOCOUNT ON

declare @sql varchar(5000)

declare @sort varchar(300)

set @sort = ""+ @sortOrder +""

set @sql=''

set @sql='SELECT [view_machine_hours].[cycleName], [view_machine_hours].[framework],...

I made a monthly calender...c if it helps.u can probably build further on this.omit the parts which r necessary in ur case..

CREATE PROCEDURE MonthlyCalendar

@year int,

@month int,

@program_id int

as

begin

declare @fdm int

declare...

I managed to find some solution..

If it helps anyone..

To increase the width of the column  use

<PointWidth>100</PointWidth>

(Point width can have value from 1 to 100, default being 55)

To remove label from...

Thanx..

(if it helps anyone..)

I added the subreport in my table header and made the table header repeat in each page...