All right that's nice progress.  Thanks for following up.  Well, an adID is the same thing as a RecordID.  If you recall the earlier query had RecordID in the select...

;with grp_cte as (
    select distinct r.PartIDC, r.PartIDX, r.step
    from #Replacement r
         join...

Submitted the SSC article last night

Progress.  We have 2 videos which are presentation ready.  The Demo video we recorded 5 times and the Quick Start video 3+ times.   It's taken multiple iterations.  Nobody listens to...

Keep in mind that'll update all the batch id's every time which might not be intended or a good idea on a large table.  Adding a WHERE batch_ID IS...

As general issues go does this require ##temp to have global scope?  Also, why make the variables varchar(max)?  I got it to work like this

drop table if...

There was a slight addition needed to David Burrow's code above.  Which is nicely done and way better than the (now Closed) Stack Overflow answer to the same question. ...

• This reply was modified 5 years ago by Steve Collins. Reason: typo

Yay!!  Just passed my goal of 1,500 points on Stack Overflow which means I can now create a tag for the JsonAutoService C# data access library.   I began on August...

It could be done with a correlated subquery too.  Stylewise I prefer >= and <= to BETWEEN AND.  Anything that's shorter, I like.  The more framework words you use the...

Something like this

select sa.userID, a.RecordID
from SmartAgents_toSend sas
     join Ads a on sas.adID=a.RecordID
     join SmartAgents sa on a.price between sa.priceFrom...

;with chem_count as (
    select chemicalId
    from #chemical
    group by chemicalId
    having count(distinct chemicalStatus)>1)
update sv
set...

For a majority of people, I agree.  They just want a solution and there’s no learning no matter how hard you try.  It’s also one of the reasons why...

I mean, the...

why the amount starting from september and so on not calculated ?

This query should represented all amount & period starting from september until december next year and grouping by...

You mean the queries posted here, or it's not possible at all?  There's got to be a way