Viewing 15 posts - 901 through 915 (of 1,413 total)
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 5, 2020 at 11:09 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 5, 2020 at 8:42 pm
;with chem_count as (
select chemicalId
from #chemical
group by chemicalId
having count(distinct chemicalStatus)>1)
update sv
set...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 3, 2020 at 10:07 am
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 2, 2020 at 4:41 pm
gentong.bocor wrote:yes, this query can't be run on 2008..
You mean the queries posted here, or it's not possible at all? There's got to be a way
I mean, the...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 2, 2020 at 2:06 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 2, 2020 at 1:44 pm
yes, this query can't be run on 2008..
You mean the queries posted here, or it's not possible at all? There's got to be a way
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 2, 2020 at 1:19 am
deleted
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
September 1, 2020 at 11:25 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 25, 2020 at 2:51 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 18, 2020 at 12:38 pm
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...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 18, 2020 at 11:54 am
It's a half eaten pretzel balanced on top of 2 rolls of toilet paper. Not the worst ERD I've seen!
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 18, 2020 at 11:27 am
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)
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 16, 2020 at 1:36 pm
Ok here's contender #1. This one doesn't split the six and five letter input strings into separate words. It splits it straight into letters and finds the commas and bases...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 15, 2020 at 5:37 pm
Thank you All!
Steve, apologies - I had no intention to offend you. I have looked into fnTally / the link you have kindly provided.
Much obliged.
Thank you for the kind...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
August 15, 2020 at 1:57 pm
Viewing 15 posts - 901 through 915 (of 1,413 total)