Viewing 15 posts - 406 through 420 (of 4,080 total)
You need to do a new version of this article after 2016 has been out a while, Steve. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 5, 2016 at 4:00 pm
If you were looking for 'Rat' (the word) you could look for Ngrams like '% RAT %'. You'd still have to use REPLACE to handle punctuation marks....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2016 at 1:26 pm
abhas (8/4/2016)
It should have capability of showing count of Employee who logged for whole day (with slot of every hour), for whole week (with slots of days), for whole Month...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2016 at 12:27 pm
I've read the Nasty Fast N-Grams article and the approach is very similar to Jeff's DelimitedSplit8K() function. The primary difference being that the N-grams would be fixed length...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2016 at 12:13 pm
There is no way that you can simplify joining to multiple entity tables. A join will be required for each entity table. The...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2016 at 11:46 am
shambhavi13 (8/3/2016)
I don't understand the use of 'value' ... what does that stands for ?
with cte as (select...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 4, 2016 at 10:22 am
Flagging this as a duplicate post. Go HERE for discussion.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2016 at 4:19 pm
Try nesting CASE expressions.
Instead of
THEN MonthlyBalance END
use
THEN CASE WHEN Mth <= @EndDate THEN MonthlyBalance ELSE MonthlyBudget END END
Remember, as an expression, CASE can be nested...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2016 at 3:39 pm
That's how it's been asked on the test.
Then wouldn't it be more honest to just say you don't know?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2016 at 3:17 pm
vsamantha35 (8/3/2016)
Is there an way,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2016 at 2:49 pm
In SQL 2016 you can use the STRING_SPLIT() function to convert your long string value to a series of individual words and then use standard COUNT(*) GROUP BY to get...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 3, 2016 at 1:51 pm
tskelley (8/1/2016)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 2, 2016 at 12:58 pm
Two comments so that you can help us help you.
First, thank you for the CREATE table statement, but we have no way to populate it with the sample data you...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 2, 2016 at 12:43 pm
Eirikur Eiriksson (8/1/2016)
slr010877 (8/1/2016)
Thank you so much, worked perfectly!
You are very welcome
😎
For further information on the subject, I suggest having a look at Jeff Moden's excellent articles, Cross Tabs and...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 2, 2016 at 12:23 pm
Cast and Convert Functions are found here.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 2, 2016 at 12:10 pm
Viewing 15 posts - 406 through 420 (of 4,080 total)