Forum Replies Created

Viewing 15 posts - 6,076 through 6,090 (of 26,490 total)

  • RE: Split string to show only customer

    You are welcome. It is also why I asked for a more detailed explanation of how the string ends. The more we know the structure the easier to...

  • RE: Split string to show only customer

    Jeff Moden (8/13/2014)


    dwilliscp (8/13/2014)


    Do the strings always end with a dash, space, numeric value?

    If so, using the setup from Sean, look at the code for the second column.

    declare @Table table...

  • RE: Split string to show only customer

    dwilliscp (8/13/2014)


    Do the strings always end with a dash, space, numeric value?

    If so, using the setup from Sean, look at the code for the second column.

    declare @Table table (someString varchar(25))

    insert...

  • RE: Fantasy Football 2014

    Do we have 12 teams? Last time you reported one has been replaced and not sure of another.

  • RE: Fantasy Football 2014

    SQLDCH (8/12/2014)


    We're running with one league, Yahoo doesn't appear to be able to do "super" leagues and I don't have the time to manage something like that.

    I changed the draft...

  • RE: Are the posted questions getting worse?

    jasona.work (8/12/2014)


    So we had some torrential rain yesterday (up to 6" in some places in a couple hours, more than double the normal rainfall for August) Roads flooded, basements...

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (8/12/2014)


    Tweeting about my mistake. I was only trying to help. I didn't suggest doing anything dangerous.

    Well, I know at least one person who is totally lost on this...

  • RE: fetch next from cursor returns multiple rows. why?

    Eirikur Eiriksson (8/11/2014)


    Lynn Pettis (8/11/2014)


    Eirikur Eiriksson (8/11/2014)


    WolfgangE (8/10/2014)


    I ran it on SQL 2008 R2 and SQL 2012.

    Ran it on 2K8 and reproduced your described results, don't have 2K12 at hand...

  • RE: fetch next from cursor returns multiple rows. why?

    Eirikur Eiriksson (8/11/2014)


    WolfgangE (8/10/2014)


    I ran it on SQL 2008 R2 and SQL 2012.

    Ran it on 2K8 and reproduced your described results, don't have 2K12 at hand but there is some...

  • RE: Trigger not inserting any values

    julie.breetzke (8/11/2014)


    I have to use a trigger.

    What would you suggest I change in my coding

    Now for the next question, why do you have to use a trigger?

  • RE: Mirroring Breakage

    Your question is some what vague. I have not had a mirror just break, but I have broken mirroring and then set it back up again.

    Can you elaborate on...

  • RE: No Results from Query - SQL Server 2012

    et2brutuss (8/11/2014)


    I have written a relatively simple query but it generating zero results. I am not getting any error message, just no results. On the messages tab it...

  • RE: Are the posted questions getting worse?

    LutzM (8/11/2014)


    To expand on Lynns idea:

    It might be an additional "feature" to set a minimum number of forum posts before being allowed to flag a thread.

    While I do trust each...

  • RE: Plagiarism and Blog Spam

    chrisn-585491 (8/11/2014)


    So do I need to search Google with segments of multiple blog postings on his blog and try to find the copy right holders?

    Who owns copy right...

  • RE: How to replace null value in a query

    LutzM (8/11/2014)


    New_2SQL (8/10/2014)


    Hi Jeff Moden,

    This was a test run on about 88 rows as you can see in the source code posted above.

    During production rows will grow in millions.

    If production...

Viewing 15 posts - 6,076 through 6,090 (of 26,490 total)