Forum Replies Created

Viewing 15 posts - 6,361 through 6,375 (of 8,731 total)

  • RE: Help with the count function

    You've received what you wanted, but here's some additional help. 😉

    In the future, review the DDL and sample data that you post. You posted the same table twice and missed...

    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

    June 3, 2014 at 8:28 am

    #1718556

  • RE: View Server State permission

    Thank you for your responses. 🙂

    I understand the part of devs telling them how to do their work. On another server, where we have the permission, I've found a lot...

    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

    June 2, 2014 at 3:45 pm

    #1718383

  • RE: Are the posted questions getting worse?

    Could I get your opinions on this issue?

    http://www.sqlservercentral.com/Forums/Topic1576705-391-1.aspx

    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

    June 2, 2014 at 2:21 pm

    #1718364

  • RE: Query question, does this result in a "Cartesian join?"

    If there's no WHERE clause, then those are CROSS JOINS producing cartesian products. Without join conditions, that will only return a lot of bad information.

    Kill the one that wrote that...

    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

    June 2, 2014 at 2:08 pm

    #1718359

  • RE: Distinct & groupby

    You should really stop believing in myths. Group by and Distinct are designed for different cases. When you're grouping use group by and when you want to eliminate duplicates use...

    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

    June 2, 2014 at 10:24 am

    #1718273

  • RE: Insert statement and column names

    Can you explain further? maybe with examples.

    An insert will insert rows, not columns. You might have a valid request but I'm confused.

    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

    June 2, 2014 at 9:47 am

    #1718262

  • RE: Convert multiple rows to one row separated by delimiter

    Read the following article to find out how to do it.

    http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    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

    June 2, 2014 at 9:18 am

    #1718250

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/2/2014)

    Sean Lange (6/2/2014)

    Did the "Recent Posts" link get moved? I don't see it any more all of a sudden.

    Looks like it got removed. That was a useful tool.

    I...

    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

    June 2, 2014 at 9:15 am

    #1718247

  • RE: get difference between data in two tables

    The best option would be to change the column to nvarchar(max).

    The other option is to cast/convert your column during the query to nvarchar(max).

    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

    May 30, 2014 at 4:04 pm

    #1717971

  • RE: RAISERROR Nulls?

    Instead of throw, you could use a simple condition.;-)

    DECLARE @ErrorMessage NVARCHAR(4000) ,

    @ErrorMessageShort NVARCHAR(4000) ,

    @ErrorNumber...

    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

    May 30, 2014 at 2:40 pm

    #1717960

  • RE: uses of string splitters

    Ed Wagner (5/30/2014)

    I also have the Proper Case thread saved in my briefcase because it's good. Luis, great approach. BTW, I still have your Start With...Connect By solution...

    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

    May 30, 2014 at 2:13 pm

    #1717952

  • RE: Error Converting Datetime to String

    lorrin.ferdinand (5/30/2014)

    Hi,

    There are other ways to skin the cat, depending on whether performance is an issue. Using some kind of a an actual table, CTE, or derived table...

    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

    May 30, 2014 at 12:40 pm

    #1717923

  • RE: uses of string splitters

    Sean Lange (5/30/2014)

    KoldCoffee (5/30/2014)

    Yes, I know about what you're talking about. I was lucky to once have a great manager tell me what an awesome job I did after...

    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

    May 30, 2014 at 12:31 pm

    #1717918

  • RE: TableVariable Update

    And be aware that if you have batch separators (GO) the variables will go out of scope.

    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

    May 30, 2014 at 11:19 am

    #1717898

  • RE: uses of string splitters

    Let's say that there's an app where you can select multiple items to generate a report. The web developer chooses to send a string as 'Item1,Item3,Item7' (which could be integers,...

    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

    May 30, 2014 at 10:42 am

    #1717884

Viewing 15 posts - 6,361 through 6,375 (of 8,731 total)