Try:

with CTE as

(

select *, ROW_NUMBER() OVER(PARTITION BY AraziID

...

Try:

WHERE Title = 'you''re most welcome'

Hope this helps.

Try:

select a.*, max(e.EghdamatSabt) as EghdamatSabt

from Arazi as a

join AraziEghdamat as e on e.AraziID = a.AraziID

group by a.*

Hope this helps.

Try:

ROUND(12.347777, 2)

Hope this helps.

Try:

with CTE as

(

select distinct Stud_ID, Activity from @TestingCase_Act

)

SELECT[TC Fee 1] = SUM(CASE WHEN c.Activity='TC_Fee_1' THEN 1 ELSE 0 END)

,[TC...

Hi,

Try:

SELECT SUBSTRING(( SELECT ', ' + CAST(ID as varchar) + ' ' + Name

...

Hi,

Can you post a sample data table and the expected result?

Try:

SELECT TOP 1000

[ModelId] ,

[GroupId] ,

SUBSTRING(( SELECT...

Hi,

Try:

with

CTE_h as

(

select cp.id_client, cp.number

from CLIENTS_PHONES...

Hi,

Try:

with CTE as

(

select a.CycleID, min(a.TASK_ID) as Task_ID

from MyTable as a

join MyTable as b on (b.CycleID = a.CycleID) and...

Try something like that:

select

[Id],

[Order],

[IsActive],

(case IsActive when 0 then Cnt else null end)...

Try something like that:

with

CTE_Amt as

(

select

...

Try something like that:

SELECT ISNULL(SUBSTRING(( SELECT '; ' + u.Email

...

Hi,

I agree with the ColdCoffee.

Also I could not understand very well.

Maybe you can use this:

MAX( case ... ) as MaxAmount

Hope this helps.

You're right Eugene.

I believe it is necessary to improve the Where clause to get the expected result.