Sorry, my suggestion is completely wrong.

Hi,

Try:

select

s.FLAG1 as INBOUND,

s.AMOUNT as BASE_AMOUNT,

Coalesce( (select i.AMOUNT from @Sample as i

...

Hi,

Try:

with CTE as

(

select

idLigne,

id,

statut,

...

Try:

with CTE as

(

select PortfolioId, AcquisitionDate from MyTable

union all

select PortfolioId, DATEADD(month, 1, AcquisitionDate) as AcquisitionDate

...

Hi,

I do not know if I understand correctly but try this:

SELECT

MIN(Count) as MinCount,

MAX(Count) as MaxCount,

(MIN(Count)...

Try:

with

CTE_SSN as

(

select Division, DateofBirth, SSN

...

Try:

with CTE as

(

select ClientID, max(ID) as ID from ClientDetails group by ClientID

)

select d.ID, d.ClientID, d.InterviewDate

from CTE as c

join ClientDetails as d on d.ID = c.ID

Hope this...

Try something like this:

update [tblTable1]

set [active status] = 0

where GETDATE() > [todate]

Hope this helps.

Hi,

Try:

set @test-2 = 'kathy''s side'

Hope this helps.

Hi,

I do not know if I understand correctly but try this:

Set @C = @a * 1000 + @b-2;

Hope this helps.