Forum Replies Created

Viewing 15 posts - 721 through 735 (of 8,731 total)

  • RE: Stored Procedure Dynamic SQL using sp_executesql Not working

    Why would you create a table, insert rows and then select the new table?
    Why can't you simply do a straight select?

    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

    January 22, 2018 at 8:46 am

    #1976742

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Friday, January 19, 2018 10:52 AM

    ChrisM@Work - Friday, January 19, 2018 9:56 AM

    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

    January 19, 2018 at 11:52 am

    #1976554

  • RE: UPDATE() function in a trigger

    What about unpivoting the table? You might need to do some data type conversions, but here's a sample code.

    CREATE TABLE [dbo].[SalesOrders]
    (
    [SalesOrderID] [int] NOT NULL,

    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

    January 18, 2018 at 6:15 am

    #1976311

  • RE: what am i doing wrong -- char(240)

    goher2000 - Tuesday, January 16, 2018 1:40 PM

    what I am doing wrong, why the result is '=' ?

    declare @c table ( c1...

    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

    January 16, 2018 at 1:44 pm

    #1976055

  • RE: Using IN and Case When splitting Numeric values

    Why do people insist on using CASE on WHERE clauses. That's usually a bad idea as it would prevent any index from being used.
    Here's a possible alternative.
    [code...

    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

    January 16, 2018 at 1:35 pm

    #1976053

  • RE: Are the posted questions getting worse?

    Sean Lange - Monday, January 15, 2018 10:00 AM

    Gosh that sounds like our payroll system. It does not allow any special...

    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

    January 16, 2018 at 8:56 am

    #1975999

  • RE: Master database

    ScottPletcher - Thursday, January 11, 2018 12:46 PM

    But the OP doesn't have all that in place, and, as I said before,  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

    January 11, 2018 at 12:51 pm

    #1975603

  • RE: Master database

    ScottPletcher - Thursday, January 11, 2018 10:53 AM

    Luis Cazares - Thursday, January 11, 2018 10:42 AM

    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

    January 11, 2018 at 12:00 pm

    #1975591

  • RE: Master database

    I get why you would want to use master database and mark them as system objects. However, I believe this is a bad idea as that should be the exception...

    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

    January 11, 2018 at 10:42 am

    #1975563

  • RE: Are the posted questions getting worse?

    Thom A - Thursday, January 11, 2018 10:15 AM

    I have to ask; Is there a point when an MVP can come 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

    January 11, 2018 at 10:23 am

    #1975554

  • RE: Are the posted questions getting worse?

    Sean Lange - Thursday, January 11, 2018 8:16 AM

    Yeah once we went to the new forum points are even less valid...

    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

    January 11, 2018 at 9:06 am

    #1975530

  • RE: Difficulties with the WHERE clause

    mpdillon - Wednesday, January 10, 2018 1:17 PM

    I am interacting with an ERP database. The field, Ord_No in all the tables 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

    January 10, 2018 at 1:34 pm

    #1975381

  • RE: Are the posted questions getting worse?

    Thom A - Wednesday, January 10, 2018 8:44 AM

    Luis Cazares - Wednesday, January 10, 2018 8:33 AM

    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

    January 10, 2018 at 9:45 am

    #1975330

  • RE: Day-of-week to Week-Number mapping

    Sergiy - Monday, June 12, 2017 8:06 AM

    Jeff Atherton - Thursday, March 16, 2017 7:25 AM

    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

    January 10, 2018 at 9:41 am

    #1975328

  • RE: Are the posted questions getting worse?

    Jeff Moden - Wednesday, January 10, 2018 8:10 AM

    GilaMonster - Wednesday, January 10, 2018 7:49 AM

    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

    January 10, 2018 at 8:33 am

    #1975297

Viewing 15 posts - 721 through 735 (of 8,731 total)