Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 10,144 total)

  • RE: Checking if a string value includes a value from a field

    DSC123 (7/27/2016)

    Morning all,

    Please could someone advise me on the correct syntax for highlighting if an email address includes a year of birth?

    So far I have created the following, the last...

    July 27, 2016 at 4:46 am

    #1892222

  • RE: Complex join and sorting the parent and child data

    Eirikur Eiriksson (7/26/2016)

    Piling on, the demonstrated expected output does not fit the description, can you please clarify?

    😎

    The rows for citycode 'MRO' are upside down 🙂

    July 26, 2016 at 9:20 am

    #1892080

  • RE: Complex join and sorting the parent and child data

    J Livingston SQL (7/26/2016)

    cant fathom your sort order...please explain

    cant see how "Order data based on latest year first and then City code and then Subcitycode " delivers what you have...

    July 26, 2016 at 9:19 am

    #1892079

  • RE: Fibonacci Series in TSQL

    Thibaut Blanchin (7/26/2016)

    100 is the max number that can be passed to the function due to recursivity depth limit.

    From BOL:

    "MAXRECURSION number

    Specifies the maximum number of recursions allowed for this...

    July 26, 2016 at 7:48 am

    #1892046

  • RE: Fibonacci Series in TSQL

    patrickmcginnis59 10839 (7/26/2016)

    where's the set oriented version? 😉

    Over to you, Patrick 🙂

    July 26, 2016 at 6:50 am

    #1892027

  • RE: Fibonacci Series in TSQL

    Iwas Bornready (7/26/2016)

    Michael Meierruth (12/18/2014)

    OK, so it's a cute CTE exercise.

    But has anyone ever used the Fibonacci series values for anything in the real world?

    I would be curious to know.

    It...

    July 26, 2016 at 6:49 am

    #1892026

  • RE: Are the posted questions getting worse?

    BrainDonor (7/26/2016)

    Somewhere deep within the bowels of Microsoft there's a team of developers who believe that there's nothing at all wrong with the way SSIS ascertains the metadata for the...

    July 26, 2016 at 4:55 am

    #1892007

  • RE: Fibonacci Series in TSQL

    This was covered in 2009 by Peter Larsson.

    July 26, 2016 at 4:35 am

    #1892004

  • RE: Are the posted questions getting worse?

    Alan.B (7/25/2016)

    Maybe it's Monday a Monday morning thing but even the small things are annoying me today. Just ran accross this:

    [Gender] varchar(100) NULL,

    It's fine! I've seen NVARCHAR for gender today....

    July 25, 2016 at 9:22 am

    #1891841

  • RE: Pivot without an aggregate?

    Think of it like this: you have to take data from all 7 rows for John, but somehow only return 1 row with data from all of them. That's an...

    July 22, 2016 at 10:01 am

    #1891626

  • RE: Identical Query, Different Execution Stats

    matt.gyton (7/21/2016)

    So it turns out my earlier optimism was slightly misplaced....the code change did not provide the fix 🙁

    However, I noticed that it temporarily improved performance until the SP ran...

    July 21, 2016 at 4:50 am

    #1891270

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (7/21/2016)

    GilaMonster (7/21/2016)

    ThomasRushton (7/21/2016)

    BrainDonor (7/21/2016)

    Does anybody know who the "Hotshot SQL Guru" is?

    https://tmblr.co/Z14uHt29WaOS7

    https://tmblr.co/Z14uHt29Ww0kS

    https://tmblr.co/Z14uHt29ZP3zF

    Somebody wasn't impressed.

    Celko?

    The first wouldn't apply to Celko. Traceflags aren't ansi standard.

    Some people, unfortunately, have an elevated...

    July 21, 2016 at 3:17 am

    #1891244

  • RE: Identical Query, Different Execution Stats

    matt.gyton (7/20/2016)

    Think I may have a solution!

    I experimented with the plans by comparing the two XML versions on a diff checker and they came up almost identical with the...

    July 21, 2016 at 3:03 am

    #1891241

  • RE: Today's Random Word!

    Revenant (7/14/2016)

    djj (7/14/2016)

    Ed Wagner (7/14/2016)

    Luis Cazares (7/14/2016)

    crookj (7/14/2016)

    Ed Wagner (7/14/2016)

    Grumpy DBA (7/14/2016)

    Ed Wagner (7/14/2016)

    ThomasRushton (7/14/2016)

    Ray K (7/13/2016)

    Lucy

    Lastic

    Elastic

    Plastic

    Melt

    patty

    burger

    Beef

    Pork

    Porcupine

    Concubine

    July 14, 2016 at 8:39 am

    #1890131

  • RE: Are the posted questions getting worse?

    Luis Cazares (7/14/2016)

    jasona.work (7/14/2016)

    ChrisM@Work (7/14/2016)

    SQLRNNR (7/13/2016)

    ChrisM@Work (6/29/2016)

    tindog (6/29/2016)

    ChrisM@Work (6/29/2016)

    tindog (6/29/2016)

    ChrisM@Work (6/29/2016)

    tindog (6/29/2016)

    Now Wales are after independence from England to 'safeguard' their future...despite the fact that they also voted in favour...

    July 14, 2016 at 6:50 am

    #1890077

Viewing 15 posts - 1,366 through 1,380 (of 10,144 total)