Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 8,731 total)

  • RE: I need help with this query.

    This makes no sense for me, but using the sample data previously posted, I can get the expected results with 2 options (none of them use SUM function).

    SELECT a.UserID,

    ...

    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 1, 2015 at 2:47 pm

    #1802167

  • RE: How to select columns that have some values only?

    Why would you need something like that? The only option is to use dynamic SQL.

    It seems as well that you have a design problem. If you can change the design...

    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 1, 2015 at 11:24 am

    #1802094

  • RE: Query assistance....

    Do you need to get Server/component compound that change from bad to good and again to bad? Or would you include the ones that go from good to bad 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

    June 1, 2015 at 11:07 am

    #1802088

  • RE: Why is this CTE so better solution then Cross Apply ?

    To start, you're using 2 tables instead of 1.

    Even if you weren't, the subquery used in the CROSS APPLY will be executed once per row (as shown by 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

    June 1, 2015 at 11:01 am

    #1802085

  • RE: Graph - just show last 12 months

    Do you need information from April somewhere else in your report?

    If you don't you should probably change the query to obtain your resultset. We could help you with that if...

    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 1, 2015 at 10:21 am

    #1802066

  • RE: Load data for yesterday's date and specific date

    I'd do it as YB mentioned, but using SSIS. You have your parameter and a variable that should work as an expression where you use conditional (condition?true:false) to evaluate if...

    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 1, 2015 at 10:01 am

    #1802058

  • RE: DBO is Ambiguous

    I'm not sure what are you doing and why you're using so many self-joins.

    But, to answer your question, dbo.QABSNew is ambiguous because you are referencing it twice in your FROM...

    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 1, 2015 at 9:56 am

    #1802053

  • RE: If Celko was a rock star, which one would he be?

    thisisfutile (5/29/2015)

    jshahan (5/28/2015)

    Just picked up from The Thread that old Joe has been banned from SSC.

    You picked up from this thread that Joe is banned? Maybe I scanned it...

    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 29, 2015 at 12:41 pm

    #1801698

  • RE: Are the posted questions getting worse?

    I'm not sure if you've seen this, but it made me laugh and wanted to share it with you.

    http://geekandpoke.typepad.com/geekandpoke/2011/01/nosql.html

    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 29, 2015 at 10:20 am

    #1801650

  • RE: replace help

    Take a look at this thread.

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

    May 29, 2015 at 10:10 am

    #1801646

  • RE: Running totals with OVER clause

    Please share your test with us when you have it. 🙂

    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 28, 2015 at 3:59 pm

    #1801422

  • RE: Count how many records within 6 months from the current record date

    Are you aware of the difference between 6 months and 180 days? It's a small change, but it can make a difference if you have the requirement wrong.

    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 28, 2015 at 2:22 pm

    #1801404

  • RE: Altering Field Length in Table does not change Field Length in View

    AFAIR, it has always been like this and it will give troubles as well when you use SELECT * and you change the order or number of columns in 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

    May 28, 2015 at 2:06 pm

    #1801395

  • RE: Running totals with OVER clause

    It's funny how Aaron and Dwain have different conclusions. I trust that they both know what they're doing, so I would just repeat the tests myself.

    However, I might end up...

    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 28, 2015 at 1:48 pm

    #1801387

  • RE: Running totals with OVER clause

    You could check this article by Dwain Camps https://www.simple-talk.com/sql/t-sql-programming/calculating-values-within-a-rolling-window-in-transact-sql/

    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 28, 2015 at 1:14 pm

    #1801371

Viewing 15 posts - 4,861 through 4,875 (of 8,731 total)