Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 8,731 total)

  • RE: Wildcard Searches

    Christy M (11/18/2016)

    Great article. And I love the Sesame Street reference 😀

    I'm glad that you liked it. Thank you for the feedback.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 21, 2016 at 7:54 am

    #1913719

  • RE: Stored Procedure that uses a parameter in a WHERE x IN(@param1)

    Eric M Russell (11/18/2016)

    Budd (11/18/2016)

    PLEASE tell me what needs to be done to make something like this work?

    DECLARE @PARAM1 VARCHAR(2000) = 'Tom','JOE','BUDD','TIM' --< Obviously this wont work

    Select...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 18, 2016 at 1:17 pm

    #1913516

  • RE: Are the posted questions getting worse?

    Dear Santa,

    I know you won't be able to bring me a new laptop this year, but could you just bring more RAM (and a new HDD) for my current one...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 18, 2016 at 10:52 am

    #1913491

  • RE: Are the posted questions getting worse?

    andrew gothard (11/18/2016)

    Brandie Tarvin (11/17/2016)

    Grant Fritchey (11/16/2016)

    Announcements include:

    SP1 for 2016 (which also has CREATE OR ALTER).

    A single development surface. This means all functionality in Enterprise is also in Standard and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 18, 2016 at 7:48 am

    #1913431

  • RE: Stored Procedure that uses a parameter in a WHERE x IN(@param1)

    You need to split the string to be able to use the individual values.

    DECLARE @PARAM1 VARCHAR(2000) = 'Tom,JOE,BUDD,TIM'

    SELECT firstname

    FROM Employees

    WHERE firstname in (SELECT Item FROM dbo.DelimitedSplit8K( @PARAM1, ',')s);

    The...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 18, 2016 at 7:17 am

    #1913421

  • RE: GET Counts for insert,update,delete

    The code is full of errors. Also, it won't count DDL operations, just rows with an operation_date greater than now.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 12:31 pm

    #1913208

  • RE: Find the brackets

    MMartin1 (11/17/2016)

    Jeff Moden (11/16/2016)

    IMHO, cleaner code if you take the shortcut.

    SELECT mychar FROM mydata WHERE mychar LIKE '[[]%'

    That's how I went about doing it and then had to take a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 12:06 pm

    #1913198

  • RE: Today's Random Word!

    Ed Wagner (11/17/2016)

    whereisSQL? (11/17/2016)

    Hugo Kornelis (11/17/2016)

    Luis Cazares (11/17/2016)

    crookj (11/17/2016)

    TomThomson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    crookj (11/17/2016)

    Grumpy DBA (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Ed Wagner (11/17/2016)

    Acronym

    Synonym

    Cinnamon

    Stick

    Ball

    bat

    Batgirl

    Robin

    Round

    Square

    Deal

    Breaker

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 11:15 am

    #1913176

  • RE: Are the posted questions getting worse?

    GilaMonster (11/17/2016)

    jasona.work (11/17/2016)

    So really, if you could figure out a way to live without Agent, you could drop down to Express and *really* save some money...

    And with only 4 cores,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 10:15 am

    #1913157

  • RE: Today's Random Word!

    crookj (11/17/2016)

    TomThomson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    crookj (11/17/2016)

    Grumpy DBA (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Ed Wagner (11/17/2016)

    Acronym

    Synonym

    Cinnamon

    Stick

    Ball

    bat

    Batgirl

    Robin

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 9:38 am

    #1913137

  • RE: An aggregate may not appear in the WHERE clause

    Have you tried with HAVING? https://msdn.microsoft.com/en-us/library/ms180199.aspx

    What are you trying to do? Shouldn't the subqueries be correlated somehow?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 9:28 am

    #1913125

  • RE: Convert Cross Join to Inner Join

    The sample data is no help. We don't have expected results and I'm not sure you know what to expect from that data.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 9:02 am

    #1913117

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (11/17/2016)

    Eirikur Eiriksson (11/17/2016)

    Brandie Tarvin (11/17/2016)

    Beatrix Kiddo (11/17/2016)

    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 7:51 am

    #1913089

  • RE: Find the brackets

    funbi (11/17/2016)

    Luis Cazares (11/17/2016)

    funbi (11/17/2016)

    Laurie Dunn (11/17/2016)

    This would also work and keep the code simple...

    SELECT *

    FROM dbo.MyData

    WHERE Left(mychar,1)='[';

    Yeah I got

    select * from MyData where CHARINDEX('[',mychar,0) = 1

    which works fine,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 7:46 am

    #1913082

  • RE: Convert Cross Join to Inner Join

    You're missing WHERE clauses. You might also be taking a bad approach. You need to create a cross tabs query which would be more effective.

    Here's an article that describe them

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    And...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    November 17, 2016 at 7:40 am

    #1913073

Viewing 15 posts - 1,846 through 1,860 (of 8,731 total)