Forum Replies Created

Viewing 15 posts - 3,736 through 3,750 (of 15,381 total)

  • RE: JOIN

    sharonsql2013 (9/25/2014)

    Can I use a temp table instead of @DelimitedSplit8K?

    That is sort of like asking if you can use a pumpkin instead of a tuna fish. They are nothing even...

    September 25, 2014 at 1:05 pm

    #1748290

  • RE: Like and Pivot is slowing down the stored procedure results.

    It is hard to know for sure with just a query but WOW there is a lot of low hanging fruit in here.

    Let's start by formatting this into some...

    September 25, 2014 at 12:59 pm

    #1748287

  • RE: Website defect: Wrong post quoted when a post has been made since last page update.

    Steve Jones - SSC Editor (9/25/2014)

    ...I suspect someone just doesn't want to break anything else.

    That is probably the biggest deal. Often times what seems like a simple fix causes enough...

    September 25, 2014 at 12:48 pm

    #1748285

  • RE: Website defect: Wrong post quoted when a post has been made since last page update.

    TomThomson (9/25/2014)

    Gary Varga (9/11/2014)

    Steve Jones - SSC Editor (9/11/2014)

    I suspect it's an issue in the query that grabs the post and renders the form rather than the JS.

    I'd put my...

    September 25, 2014 at 12:31 pm

    #1748281

  • RE: JOIN

    sharonsql2013 (9/25/2014)

    Wondering why are we using dbo.DelimitedSplit8K?

    Because you have a delimited list of IPs in @T. If you want to join on the first two octets of each IP in...

    September 25, 2014 at 12:28 pm

    #1748279

  • RE: JOIN

    As Eirikur stated his solution will work for some cases but certainly not all.

    Add one more row to @T ,('10.158.4.5'). That will be missed in his solution.

    You first have to...

    September 25, 2014 at 12:18 pm

    #1748275

  • RE: Interview questions

    karunakar2351 (9/25/2014)

    Hello Friends...

    My recent interview questions..

    1.If we have a text file,excel file,.csv file in one folder..How do you load these 3 files data into a single destinition table..

    2.I we have...

    September 25, 2014 at 11:48 am

    #1748270

  • RE: Today's Random Word!

    Ed Wagner (9/25/2014)

    crookj (9/25/2014)

    Sean Lange (9/25/2014)

    Stuart Davies (9/25/2014)

    sing4you (9/25/2014)

    Sean Lange (9/25/2014)

    Ed Wagner (9/25/2014)

    djj (9/25/2014)

    TomThomson (9/25/2014)

    Ed Wagner (9/25/2014)

    ChrisM@Work (9/25/2014)

    BWFC (9/25/2014)

    Ed Wagner (9/25/2014)Terminator

    Colon

    Begininator

    Platypus

    Weevil

    Bull

    Crap

    Load

    wide

    mouth

    jar

    Head

    Butthead

    Bevis

    September 25, 2014 at 10:09 am

    #1748250

  • RE: Hiding my work with encryption

    drew.georgopulos (9/25/2014)

    Lets say I have a database with tables, views, stored procedures...the Product, that has proprietary information that I want to migrate to a client's machine to interact with the...

    September 25, 2014 at 8:21 am

    #1748187

  • RE: Today's Random Word!

    Stuart Davies (9/25/2014)

    sing4you (9/25/2014)

    Sean Lange (9/25/2014)

    Ed Wagner (9/25/2014)

    djj (9/25/2014)

    TomThomson (9/25/2014)

    Ed Wagner (9/25/2014)

    ChrisM@Work (9/25/2014)

    BWFC (9/25/2014)

    Ed Wagner (9/25/2014)Terminator

    Colon

    Begininator

    Platypus

    Weevil

    Bull

    Crap

    Load

    wide

    mouth

    jar

    September 25, 2014 at 8:12 am

    #1748179

  • RE: Today's Random Word!

    Ed Wagner (9/25/2014)

    djj (9/25/2014)

    TomThomson (9/25/2014)

    Ed Wagner (9/25/2014)

    ChrisM@Work (9/25/2014)

    BWFC (9/25/2014)

    Ed Wagner (9/25/2014)Terminator

    Colon

    Begininator

    Platypus

    Weevil

    Bull

    Crap

    Load

    September 25, 2014 at 7:19 am

    #1748145

  • RE: Ordering the String Value possibly by using PARSENAME function

    So you are wanting to order by the first portion of your string before the first period? Just put this in your order by.

    Order by LEFT(IPAddress,CHARINDEX('.', IPAddress + '.') -...

    September 25, 2014 at 7:17 am

    #1748141

  • RE: Today's Random Word!

    TomThomson (9/24/2014)

    Ed Wagner (9/24/2014)

    Sean Lange (9/24/2014)

    SQLRNNR (9/24/2014)

    Ed Wagner (9/24/2014)

    SQLRNNR (9/24/2014)

    whereisSQL? (9/24/2014)

    SQLRNNR (9/24/2014)

    BWFC (9/24/2014)

    Ouroboros

    burro de oro

    burrito

    burr filled dough

    Pasta (did someone say dough :-D)

    hasta

    rasta

    Raster

    Faster

    Plaster

    September 24, 2014 at 2:31 pm

    #1747978

  • RE: Today's Random Word!

    SQLRNNR (9/24/2014)

    Ed Wagner (9/24/2014)

    SQLRNNR (9/24/2014)

    whereisSQL? (9/24/2014)

    SQLRNNR (9/24/2014)

    BWFC (9/24/2014)

    Ouroboros

    burro de oro

    burrito

    burr filled dough

    Pasta (did someone say dough :-D)

    hasta

    rasta

    September 24, 2014 at 12:46 pm

    #1747949

  • RE: Testing in Production

    Luis Cazares (9/24/2014)

    Sean Lange (9/24/2014)

    djackson 22568 (9/24/2014)

    andrew gothard (9/24/2014)

    Luis Cazares (9/23/2014)

    ...

    Every time a new iOS is released, it seems to consume a lot of battery.

    ...

    Bwahaa, that's apparently fixed now with...

    September 24, 2014 at 10:05 am

    #1747891

Viewing 15 posts - 3,736 through 3,750 (of 15,381 total)