Hello All,

Is it possible to do this kind of query :

Select name, (select count(*) from cars where UserID=UserID) as 'NumberOfCars'
from User

See the documentation -> Generated code - Field expressions and aggregates -> Scalar query expressions

Hi, I'm encountred problem to do this statement. Can you help me.

Select count(*) From t_calendrier
     Where cal_dt >= 
          case 
           when @StartDate <= ven_dt 
               then abo_dt
           else @StartDate
          end

And how make this statement too.

select date from
(
    select ven_dt date
    union
    select @EndDate date
)

Thanks in advance

1- Can we convert the above statement to the following:

Select count(*) From t_calendrier
Where (cal_dt >= abo_dt     AND ven_dt >= @StartDate)
      OR (cal_dt >= @StartDate AND ven_dt <= @StartDate)

2- Does this query run? I thought UNIONS are done between tables only.

Hello,

Thanks for you help : it does work :-)

Regarding my second issue I find a walkaround by refactoring the query (I am using a case now).

And yes, this query does work. We can union a table and other data if the resulting columns name (and format) are the same :-)

Cheers,