Forum Replies Created

Viewing 15 posts - 421 through 435 (of 8,731 total)

  • RE: how can i get the top 3, after i count the column ?

    BONITO - Monday, July 16, 2018 6:34 AM

    how can i get the top 3, after i count the column ?

    here 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

    July 16, 2018 at 6:48 am

    #1997646

  • RE: Are the posted questions getting worse?

    Grant Fritchey - Thursday, July 12, 2018 8:42 AM

    Well, every team I was rooting for is out of the cup. We're down...

    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

    July 13, 2018 at 1:02 pm

    #1997543

  • RE: multiple column pivot in mssql

    Here's a sample on how to do it, but it needs to be done using cross tabs instead of PIVOT to avoid performance issues.

    SELECT eas.emp_name,
     ...

    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

    July 13, 2018 at 10:36 am

    #1997498

  • RE: Help improving performance of a query

    Lisa Cherney - Thursday, July 12, 2018 2:29 PM

    Luis Cazares - Thursday, July 12, 2018 1:57 PM

    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

    July 12, 2018 at 3:10 pm

    #1997407

  • RE: Help improving performance of a query

    Why are you grouping by VendorPrefix?

    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

    July 12, 2018 at 1:57 pm

    #1997396

  • RE: query help needed

    sgmunson - Wednesday, July 11, 2018 2:57 PM

    Luis Cazares - Wednesday, July 11, 2018 1:52 PM

    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

    July 11, 2018 at 4:23 pm

    #1997238

  • RE: query help needed

    It should be noted, that there's no way to guarantee the order of the rows and therefor the correct assignment of the pairs. At least with the data shown on...

    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

    July 11, 2018 at 1:52 pm

    #1997212

  • RE: Pivoting a 2 columns table to a 6 columns table with 1/3 the rows

    sgmunson - Wednesday, July 11, 2018 9:45 AM

    Given that the source data contains an ordering mechanism, using ROW_NUMBER() isn't actually needed here:

    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

    July 11, 2018 at 9:57 am

    #1997153

  • RE: Prevent update trigger

    Nqobilemoyo - Monday, July 9, 2018 10:12 AM

    I have a database and i would like to create a trigger which will not...

    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

    July 9, 2018 at 10:49 am

    #1996825

  • RE: Need to bring pivot results into another table with JOIN

    The easiest way is to create a new CTE.

    WITH S AS (
      SELECT DISTINCT
        m.item_id AS 'Old'
       , m2.item_id AS 'Sub'

    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

    July 5, 2018 at 12:13 pm

    #1996449

  • RE: how to troubleshoot this issue??? function failing with error

    vsamantha35 - Thursday, July 5, 2018 9:59 AM

    Its the same parameters. still ssms was not showing up this errors.

    It's not about 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

    July 5, 2018 at 10:04 am

    #1996433

  • RE: how to troubleshoot this issue??? function failing with error

    vsamantha35 - Thursday, July 5, 2018 8:29 AM

    Louis, one thing I didnt understand , you mentioned
    "The simplest thing that comes...

    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

    July 5, 2018 at 8:50 am

    #1996409

  • RE: how to troubleshoot this issue??? function failing with error

    vsamantha35 - Thursday, July 5, 2018 8:25 AM

    Thanks a lot Luis. I ll make that change and try and keep you posted....

    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

    July 5, 2018 at 8:35 am

    #1996405

  • RE: how to troubleshoot this issue??? function failing with error

    vsamantha35 - Thursday, July 5, 2018 6:06 AM

    Hi All,

    Need some tips to troubleshoot below issue. we are seeing  below error...

    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

    July 5, 2018 at 7:09 am

    #1996380

  • RE: need help in clarifying doubt locks on table

    This helped me a lot to better understand locking in SQL Server. Maybe it can solve some of your questions.
    Locking in Microsoft SQL Server (Table of Content)...

    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

    July 3, 2018 at 1:33 pm

    #1996219

Viewing 15 posts - 421 through 435 (of 8,731 total)