Yup Got the Result ...

"Distinct" was not the Issue But I replaced Left Join To Join Keyword in my Query,....

Query Working Fine

thankz

But the Concatenated row Repeating two Times with same value

With Tag (WorkId,TagsetId,ProjectName,WorkType,Status,ObjectId,TagSetName ,TagValues)

AS

(

select top 5000 vw.work_id as WorkId ,g.tagset_id as TagsetId ,vw.name as ProjectName,

vw.work_type_code as WorkType,vw.status_current as Status,g.object_id...

This is one more Issue

User_Name UserId

XYZ ...

thanks

But there are many Join in my query, I want them to replace with Subqueries Bcoz it is taking much time to execute..

Hi anthony,

I have two date Define_Start_date and Define_End_Date

Say:

Define_Start_date = 28-04-2012

Define_End_date = 28- 05-2012

I need to get days between these two dates Excluding holidays(i.e Sturday & Sunday)

Using DateDiff(day,Define_Start_date ,Define_End_date )

The...

Select work_id,name,(select process_name From view_process Where Process_Id In ( Select Process_id from View_work))as Process,

Status_current,active_gate FRom View_Work

----------------

Subquery returned more than 1 value. This is not permitted when the subquery follows =,...

I need output Lyk this

Work Id Work Name Define_Start_Date DefineEndDate Measure StartDAte Measure End Date

1258282...

Hi Anthony This is my table

Work_Id Name Current_Status ...

This is View_Work /****** Script for SelectTopNRows command from SSMS ******/

SELECT TOP 1000 [work_id]

,[work_type_code]

,[name]

...

I am not permit to Give the Ip Address N SA password

Hi Green,

This is simple,,I dont want to complex... If u run tis query u vl get actual start date N end date

SELECT DISTINCT TOP 2000 vw.work_id as WorkId, vw.name as...

Where is the Link

?

Ok

the Query Used for this Is ;...All datas are from Single Views only..ViewWork

SELECT DISTINCT TOP 2000 vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

vw.actual_start_date,vw.actual_end_date,vp.process_name as ActiveProcess,vw.active_gate as ActiveGate

FROM view_work...

This is my Query

------------------------------------------------------

With Project_view(WorkId,Name,StatusCurrent,ActualStartDate,ActualEndDate,ActiveProcess,ActiveGate)

As

(

SELECT DISTINCT TOP 2000 vw.work_id as WorkId, vw.name as Name,vw.status_current as StatusCurrent,

vw.actual_start_date,vw.actual_end_date,vp.process_name as ActiveProcess,wv.active_gate as ActiveGate

FROM view_work vw LEFT OUTER JOIN View_Process vp...

1800m1g0000h69g9eujg000000Reduce non-value added calls stemming from complex marketing initiativesCanceled DMAICNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL

1800m1g0000h69ip1m600000001. DefineCompleted ...