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, 6 months 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

deleted

Steve Collins- I didn't see a "function-ized" version of your code in the thread. If I missed it, point it out and I'll include it in another round of...

Suppose there were tables which pre-split the words so there's an established correct baseline for comparisons.  Also there could be a script with nested loops that executes different procedures dynamically...

The 1,000 names in the test variables vary in length from 2 to 11 characters.  Here's some code to generate 8 random tests and store them in a UDT.   I...