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...

It's a half eaten pretzel balanced on top of 2 rolls of toilet paper.  Not the worst ERD I've seen!

This link takes you to a page that lists the top 1000 most popular baby names.

Here are 5 groups of 50 names (of variable lengths) declared as NVARCHAR(MAX)

This reply was modified 5 years, 5 months ago by Steve Collins.