Hi,

Try:

with CTE_B as

(

select IDA from B

group by IDA

having count(Status) = count(case when Status = 'Closed' then Status end)

)

select...

Can you post a sample of data of this table and its expected result?

Hi,

Try:

With CTE AS

(

Select

userid,

web_survey_date,

...

Hi,

Try:

SELECT

t1.OtherVisaID,

t1.Name,

t1.Company,

STUFF( (SELECT ';' + t3.Description

...

Hi,

Try:

with CTE_R as

(

select

t.*,

ROW_NUMBER() OVER(PARTITION BY UserID ORDER BY LOGTIME) as...

Hi,

Try:

with CTE as

(

select

bookid,

ROW_NUMBER() OVER(PARTITION BY Location ORDER BY bookid...

Hi,

Try:

select

empid,

deptid,

salary,

AVG(salary) OVER() as median

from MyTable

and

select

empid,

...

Here is my suggestion with the adaptation (Distinct):

with

CTE_T as

(

select COUNT(*) as TotIsStaffTask

...

There may be more than one row in Table2 with the same DID and AID?

If may be necessary to adapt the script I suggested.

If not, I think the script I...

Hi,

Try:

with

CTE_T as

(

select COUNT(*) as TotIsStaffTask

from...

Try something like this:

select

pa.pNo,

coalesce(tf.cDate, lr.lDate) as lDate,

coalesce(tf.cIn, lr.LStart) as lStart,

coalesce(tf.cOut, lr.lStop) as lStop

from...

Hi,

Try:

select

a.SNo,

a.Date,

a.Cat as Cat_A,

a.Value as Value_A,

b.Cat as Cat_B,

...

Try something like this:

select Groups from companyGroups CG

where @Egroups = 'False' or

exists(select 1 from Egroups EG where CG.id = EG.id)

Hope it's useful.

Try:

select [Day], AVG([Value] as Avg_Value

from [MyTable]

group by [Day]

Hope this helps.

Hi,

Try:

declare @fromdate date = '2012-10-7', @todate date = '2012-10-20';

with CTE as

(

select

@fromdate as Sunday,

...