Forum Replies Created

Viewing 15 posts - 91 through 105 (of 430 total)

August 27, 2014 at 1:43 pm

#1741473

  • RE: Migrating sql instances from old 2012 cluster to new 2012 cluster

    Or rename the old cluster/nodes to "name_old" or something, rename the new cluster/nodes, and make sure it works before taking the old stuff all offline.

    August 27, 2014 at 1:24 pm

    #1741466

  • RE: Filtering query using WHERE + CASE

    Luis Cazares (8/22/2014)

    That's like saying you shouldn't write "colour" and should write "color" just because someone said so.

    Got any left handed spoons?

    August 27, 2014 at 12:36 pm

    #1741449

  • RE: Does anyone have a good 'validate email' function?

    GilaMonster (8/27/2014)

    Depends how accurate you want it.

    Want a complete, perfect validation? Use DB_Mail to send an email and have the app ask for the sent code, or validate a clicked...

    August 27, 2014 at 11:48 am

    #1741435

  • RE: Convert Excel formula to SQL

    Jeff Moden (8/19/2014)

    davidmckee (8/19/2014)

    I connect to the server/table using phpMyAdmin[font="Arial Black"] I believe it is a MySQL database[/font]

    Wellllll.... crud. I came up with something fun but now I don't...

    August 27, 2014 at 11:03 am

    #1741417

  • RE: deleting duplicate records from a table

    I ran into this method in an Itzik Ben-Gan article, which looks more complicated, but of course somehow manages to run a bit faster where I've tested it against a...

    August 27, 2014 at 9:19 am

    #1741373

  • RE: Determine which pattern comes first in a string<!-- 864 --><!-- 864 -->

    Eirikur Eiriksson (8/25/2014)

    sqldriver (8/25/2014)

    That's pretty cool. I like the position column. I don't think you need the extra step with the prefixes, though. Their position (at least in my actual...

    August 25, 2014 at 12:43 pm

    #1740809

  • RE: Determine which pattern comes first in a string<!-- 864 --><!-- 864 -->

    Eirikur Eiriksson (8/25/2014)

    Just having a quick fun with this problem, this code probably has more of an entertainment value than being an actual solution (couldn't help it):-D

    😎

    USE tempdb;

    GO

    WITH cteText(string) AS...

    August 25, 2014 at 12:21 pm

    #1740793

  • RE: TSQL to create Excel 2013 file

    Just a thought, if you can't get the permissions for the SQL Service account sorted out. You can always raise makewebtask from the dead, if you still have a 2008...

    August 25, 2014 at 9:00 am

    #1740742

  • RE: Determine which pattern comes first in a string<!-- 864 --><!-- 864 -->

    dwain.c (8/24/2014)

    I confess to a bit of lack of understanding here (meaning in what you expect your output to be), but since you mentioned PatternSplitLoop (presumably the one from my...

    August 25, 2014 at 8:11 am

    #1740721

    • Viewing 15 posts - 91 through 105 (of 430 total)