Hi,

Try:

select 
    RowNum,
    Inputstring,
    case when patindex('%[AR]%', Inputstring) = 0
        then...

Try:

select colA1, colA2, colA3, colA4, colA5, colB2

from tableA A

left join tableB B on A.ColA1 = ColB1

where

colA4 = 'case' and

(ColB1 is...

Hi,

Try a test using Pivot. Ex:

select

PersonID,

[Woke Up] as WakeUpTime,

[Had Breakfast] as BreakFastTime,

[Got Dressed] as...

Hi,

Try something like this:

SELECT

a.ParentObject,

STUFF( (SELECT DISTINCT

...

Try:

with CTE_Min as

(

select MIN([Timestamp]) as [Timestamp] from Spec1

)

select

s.*,

DATEADD(MILLISECOND,

...

Try something like this:

with CTE_RN as

(

select

[Week],

[Month],

...

Try:

FOR XML PATH(''), TYPE).value('.', 'varchar(max)')

,1, 1, '')

instead

...

Hi,

Try:

SELECT

count(hc),

CS,

S_W,

COUNT(case when Reg_Temp = 'Reg' then 1 end) as [RegOnly]

FROM...

Try s.AIMS_Preop_Concept_ID instead preop.AIMS_Preop_Concept_ID.

Try:

SELECT

preop.Case_ID,

STUFF( (SELECT ',[' + s.Name + ']'

FROM dbo.TBL_Preop as s

...

I do not know if I understand correctly but try:

SELECT

MHD_MONTH_SHEET.Calender_Date AS Expr2,

Pay_Emp_Master.Emp_Code AS Expr3,

Pay_Emp_Master.Dept_Code...

Try:

where

MSDate < DATEADD(MONTH,

6,...

Hi,

Try:

with

CTE_Months as

(

select DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) as MonthYear

...

Hi,

Try using Cross Apply:

SELECT

-- ...

a.LastVisitDate,

a.LastVisitDesc

FROM -- ...

CROSS APPLY

(

Select Top(1) a.dbPatApptTime as LastVisitDate, a.dbSchTypeDesc as LastVisitDesc

from appointments as a

where a.dbPFStatus = 1 and a.clientref = p.clientref

order by a.dbPatApptTime desc

) as a

WHERE...

Try something like this:

with CTE_RN as

(

select

FromDate,

ToDate,

...