Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 8,731 total)

  • RE: Simplifying while loop query

    rs80 (10/14/2015)

    But doesn't CROSS APPLY have a different purpose than CROSS JOIN?

    Yes, it allows you to reference columns from the previous tables to use in correlated subqueries or functions.

    In this...

    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

    October 14, 2015 at 9:50 am

    #1833292

  • RE: Comma separated list of distinct values

    Why would you expect to have distinct values if you're not telling the engine to return distinct values?

    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

    October 14, 2015 at 9:46 am

    #1833289

  • RE: Better than The Big Bang Theory?

    Eric M Russell (10/14/2015)

    This guy must have gotten the most laughs of any tech conference presentation. 😛

    https://www.youtube.com/watch?v=yL_-1d9OSdk

    https://isotropic.org/papers/chicken.pdf

    OMG, I can't stop laughing. 😀

    I agree that Adam, along with others, have great...

    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

    October 14, 2015 at 8:03 am

    #1833248

  • RE: Career advice - Urgent

    It's very hard to give an advice. There's no right answer. I could tell you to for Company A as you'll get a great chance to develop yourself by knowing...

    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

    October 14, 2015 at 7:44 am

    #1833233

  • RE: Better than The Big Bang Theory?

    I guess it all depends on what you're looking for. 😀

    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

    October 13, 2015 at 8:25 pm

    #1833115

  • RE: I have to split a string with '&' separated values without the use of a function or stored proc and data is not handled well when converted to XML

    I have to split a string with '&' separated values without the use of a function or stored proc

    Why can't you use a function? There's a great splitter function 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

    October 13, 2015 at 8:52 am

    #1833010

  • RE: TempDB question

    DBA in Unit 7 (10/12/2015)

    Hello SQL Server Gurus,

    I am not sure if this is too silly to ask, but can someone explain why SQL Server only has one TempDB?

    Is...

    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

    October 12, 2015 at 1:01 pm

    #1832866

  • RE: Today's Random Word!

    crookj (10/12/2015)

    djj (10/12/2015)

    eccentricDBA (10/9/2015)

    Ed Wagner (10/9/2015)

    Luis Cazares (10/9/2015)

    Eirikur Eiriksson (10/9/2015)

    Ed Wagner (10/9/2015)

    DonlSimpson (10/9/2015)

    anthony.green (10/9/2015)

    Ed Wagner (10/9/2015)

    crookj (10/9/2015)

    Ed Wagner (10/9/2015)

    happygeek (10/9/2015)

    Deadlock victim!

    Cost

    Expense

    Revenue

    Tax

    Tariff

    Price Increase

    Pint

    Pitcher

    Round

    Parrotheads

    Paradise

    Snake Eyes (pair a dice)

    G.I.Joe

    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

    October 12, 2015 at 12:07 pm

    #1832853

  • RE: How to assign either a value or a wildcard to a report parameter

    When building your parameter list, you can add an "All" row with value '%'.

    Just remember the following:

    - If the column is nullable, you won't return rows where days...

    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

    October 12, 2015 at 12:03 pm

    #1832852

  • RE: sp_executesql with Parameters and CREATE INDEX

    I assume that you were asked to change the old sql to prevent sql injection.

    You could validate your variables to prevent it. For @UNIQUENESS you can do it manually. For...

    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

    October 12, 2015 at 9:23 am

    #1832823

  • RE: SSIS - Execute SQL Task Question

    There's the preview option, but I'd use SSMS or any other client depending on the RDBMS you're connecting 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

    October 12, 2015 at 9:13 am

    #1832818

  • RE: Are the posted questions getting worse?

    ChrisM@Work (10/12/2015)

    Luis Cazares - happy birthday geezer. No idea how but it came up in some feed or other on my phone. Hope you had a great day 🙂

    Thank you,...

    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

    October 12, 2015 at 7:56 am

    #1832813

  • RE: Import millions row data from MySQL to MS SQL

    Have you reviewed the data types?

    You could create a 'csv' file and import it through bulk insert or bcp.

    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

    October 12, 2015 at 7:32 am

    #1832806

  • RE: How to make Soundex functions include the first letter

    trapnell (10/9/2015)

    Fascinating! You do that just for fun?

    There are several things in your code I've never seen before. For example, I don't understand why

    SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

    works. ...

    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

    October 9, 2015 at 1:45 pm

    #1832664

  • RE: trouble with SP

    How do you know it didn't update?

    What happens if you run the update outside the stored procedure or removing the SET NOCOUNT ON?

    What do you get from this?

    SELECT *

    FROM [PearsonScores].[dbo].ViewScoresView...

    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

    October 9, 2015 at 1:15 pm

    #1832648

Viewing 15 posts - 4,036 through 4,050 (of 8,731 total)