2 ChrisM@Work

or so

SELECT

[NewValue] = SUM(CASE WHEN OWN = 'PART' THEN BASEDPTH

...

select ta.*,b.id,b.CreatedDate

from @TableA ta cross apply

(select tb.id,tb.CreatedDate,ROW_NUMBER() over(partition by ta.id order by(abs(DATEDIFF(S,ta.CreatedDate,tb.CreatedDate)))) rn

from @TableB tb ) b

where rn=1

;with q1 as

(

select d,c

from (values('cse', 200),('it', 250),('eee', 312),('ece', 214),('mec', 337)) as t(d,c)

),

q2 as

( select ROW_NUMBER()over (order by (select null)) rn, d,c

from q1

),

q3 as

(

select 1 as rownum,d,c, c as sumq

from...

try this

with

q as (select CurrentDateFormat

,case when CurrentDateFormat=0

...

Probably there is data less than 7 characters

Give me an example of such data,...

with

q as (select CurrentDateFormat,right(CAST(CurrentDateFormat as varchar(8)),4) +

left(right(CAST(CurrentDateFormat as varchar(8)),6),2) +

...

Better late than never 🙂

select cc.ClaCaseID,cc.NameID , cc.IncidentDate

,case when exists (select PaymentStatus

...

select [ACCOUNT_NUMBER]

,[End_Date]

,[LDC_Account_Num]

from

(select [ACCOUNT_NUMBER]

...

ChrisM@home (12/30/2011)

it could still be interpretation. The same three missed payments are captured by two different event rows. The correct solution could be one or the other or both....

Sorry,Chris

It was my mistake

select cc.ClaCaseID,cc.NameID , cc.IncidentDate

,case when exists (select PaymentStatus

from

...

Why ???

ClaCaseIDNameIDIncidentDateMissed

37430 ...

select cc.ClaCaseID,cc.NameID , cc.IncidentDate

,case when exists (select *

from

...

DECLARE @time TIME = '20:10:10'

select total_seconds =DATEDIFF(second,0,cast(@time as datetime))

mikes84 (12/21/2011)

---

Thanks guys, very helpful! I have one more question. Is there any way make it so that if there's a remainder, it's at the beginning instead of at the...

select [COLUMN]

from dbo.

WHERE [COLUMN] not like '%[A-Z]%' COLLATE Latin1_General_BIN