Viewing 15 posts - 571 through 585 (of 4,080 total)
Ed Wagner (3/12/2014)
JAZZ Master (3/12/2014)
Ed Wagner (3/12/2014)
Kurt W. Zimmerman (3/12/2014)
Revenant (3/12/2014)
Ed Wagner (3/12/2014)
SQLRNNR (3/12/2014)
outputInput
Throughput
IOPS
FLOPS
Flop
Beach
Sonova
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 12, 2014 at 3:16 pm
Like Jeff said, you want a lot of time and disk space to go over 5 in length. However, this problem is what CROSS JOINS in SQL do...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2014 at 1:41 pm
Really happy for you, Jack. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2014 at 12:45 pm
IIIIIIIIIIIII LIKE IT !!:w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 7, 2014 at 3:54 pm
Semicolons.
Can't live with 'em....
... pass me the peanuts.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 6, 2014 at 8:15 pm
But when semicolons are required between statements as separators, it would just be so EASY to start each new statement with a semicolon. Besides, reading from left...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 6, 2014 at 8:12 pm
Lynn also refuses to put commas at the beginning of a list of values. 🙂
Given how SQL treats white space, a semicolon is more properly described as a separator,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 6, 2014 at 1:53 pm
Eskandari,
Sorry but I don't speak C#. What is the desired result?
Are you just trying to identify the strings between "!" and "~" ??
If...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 6, 2014 at 1:39 pm
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
Hey folks. so what's I miss?😀
A LOT
What happened to your website?
I was trying to get a script from there a week or so ago 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
March 5, 2014 at 3:30 pm
Welcome back, Barry. Good to see your smiling face again.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2014 at 10:01 am
I just read that fourth article on splitting strings based on patterns: Good stuff.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2014 at 9:31 pm
You're right about the issue with NULL strings, Dwain. The following change should take care of it.
with tally as (select top(ISNULL(len(@pstring),0)) N from dbo.tally order by N)
If @pstring is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2014 at 5:40 pm
Don't know what to tell you, Jeff. On my development box it's neck and neck for a short string but the margin of victory for the inline table...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2014 at 4:17 pm
I'm with Dwain on this one.
CREATE FUNCTION dbo.CleanString_bh
(@pString VARCHAR(8000),@pPattern VARCHAR(100))
RETURNS TABLE
AS
RETURN
(
with tally as (select top(len(@pstring)) N from dbo.tally order by...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2014 at 1:46 pm
Agreed. Formatting like that described in the original post is handled by the application program (Word, SSRS), not by SQL.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2014 at 1:14 pm
Viewing 15 posts - 571 through 585 (of 4,080 total)