Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 8,731 total)

  • RE: Advice needed - troubleshooting Severity 20 errors

    Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.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

    August 9, 2016 at 7:25 am

    #1894517

  • RE: Today's Random Word!

    Grumpy DBA (8/9/2016)

    ThomasRushton (8/9/2016)

    Ed Wagner (8/9/2016)

    Entanglement

    hairball

    * Cough *

    Sneeze

    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

    August 9, 2016 at 7:23 am

    #1894516

  • RE: ssrs 2008 default parameter value

    pietlinden (8/8/2016)

    Use the [Google]Force, young Jedi!

    https://www.mssqltips.com/sqlservertip/3506/set-select-all-as-default-for-multivalue-report-parameters-in-sql-server-reporting-services/

    Use the tags, and you might be considered to enter the Jedi Council. 😀

    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

    August 8, 2016 at 2:36 pm

    #1894433

  • RE: ssrs 2008 default parameter value

    In the Parameter window, go to the "Default Values" tab and select "Get values from a query", then use the same dataset and value field as the ones defined in...

    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

    August 8, 2016 at 2:34 pm

    #1894432

  • RE: Today's Random Word!

    Ed Wagner (8/8/2016)

    Hugo Kornelis (8/8/2016)

    Ed Wagner (8/8/2016)

    whereisSQL? (8/8/2016)

    Ray K (8/8/2016)

    Ed Wagner (8/8/2016)

    Swing

    Jazz

    Trumpet

    Trombone

    Seventy-Six

    1776

    1984

    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

    August 8, 2016 at 2:20 pm

    #1894430

  • RE: joining multiple tables without a join

    skippyV (8/8/2016)

    The error message from the tooltip over either of the red-underlined column names is: "... is of a type that is invalid for use as a key column in...

    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

    August 8, 2016 at 10:40 am

    #1894398

  • RE: Today's Random Word!

    Revenant (8/8/2016)

    djj (8/8/2016)

    Sergiy (8/8/2016)

    Grumpy DBA (8/8/2016)

    Ed Wagner (8/8/2016)

    Hugo Kornelis (8/7/2016)

    SQLRNNR (8/7/2016)

    rage

    quit

    Resign

    Celebrate

    life

    Death

    Loss

    Win

    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

    August 8, 2016 at 9:09 am

    #1894371

  • RE: SQL Query help

    This seems like a weird design. Why would you have a transaction table for master product and master locations when you're supposed to be able to get them through your...

    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

    August 8, 2016 at 8:10 am

    #1894343

  • RE: simple date function concept

    And now you have 2 threads with the same question and very similar answers. You only divided the replies and confused people on what version you're using.

    http://www.sqlservercentral.com/Forums/Topic1807873-3412-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

    August 8, 2016 at 7:55 am

    #1894339

  • RE: simple date function concept

    Here's a possibility using an inline table function for this.

    CREATE TABLE TestSplitData

    (

    Start DATETIME

    ,EndDt DATETIME

    ,Amount INT

    )

    GO

    --Insert Data

    INSERT INTO TestSplitData(Start,EndDt,Amount)

    VALUES

    ('20140414','20141013',200),

    ('15-May-14','16-Jun-14',320)

    GO

    CREATE FUNCTION SplitDatesInMonths(

    @StartDt datetime = '20140414',

    ...

    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

    August 8, 2016 at 7:18 am

    #1894330

  • RE: Help with query.

    I'm sure that you have some ID for each person that would work as a primary key. That's the reason I added it to the example.

    You just need to unpivot...

    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

    August 8, 2016 at 6:40 am

    #1894315

  • RE: Import "structured" data

    JTSash (8/5/2016)

    Luis,

    Your code works. I shall have to see about extrapolating it to my actual data. I will agree that the original data structure is flawed but it's...

    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

    August 5, 2016 at 12:46 pm

    #1894144

  • RE: Differences between MS SQL Server and Gupta SQL Server

    Jeff Moden (8/5/2016)

    shanalalkasim (8/5/2016)

    Hi,

    I have 7+ yr experience in Gupta SQL. It's entirely different from SQL server. If you need any help please contact me. My mail id is shanalalkasim@gmail.com

    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

    August 5, 2016 at 12:03 pm

    #1894127

  • RE: Import "structured" data

    There's probably a better way to get this working without having to read the table 3 times.

    I'd be interested on the loop as it could be faster than some options...

    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

    August 5, 2016 at 11:58 am

    #1894124

  • RE: Are the posted questions getting worse?

    jasona.work (8/5/2016)

    SQLRNNR (8/5/2016)

    jasona.work (8/5/2016)

    So, something completely different!

    Movie review of the new Bourne movie (kept short)

    Pros: Decent enough typical action movie.

    Cons: Oh god the mangling and mis-use of techie!...

    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

    August 5, 2016 at 10:52 am

    #1894105

Viewing 15 posts - 2,341 through 2,355 (of 8,731 total)