Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 8,731 total)

  • RE: Dropping PKs

    Darko Martinovic - Tuesday, July 11, 2017 2:21 AM

    In the real world, we do not usually know the name of a constraint....

    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, 2017 at 6:01 am

    #1950346

  • RE: BULK Insert + create temperory table at the time of insert

    komal145 - Monday, July 10, 2017 1:36 PM

    How to Create temp table at  the time of insert?

    DECLARE @sql AS NVARCHAR(1000)
    SET @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

    July 10, 2017 at 1:46 pm

    #1950249

  • RE: Change SSN in textbox

    Alan.B - Friday, July 7, 2017 2:17 PM

    Unless I misread the requirement - the OP is only looking to replace 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 8, 2017 at 10:09 am

    #1950070

  • RE: Change SSN in textbox

    Is there any problem if we follow the logic from the original function? Or should we only remove numbers from personal identification numbers?

    ALTER Function [dbo].[RemoveNumericCharacters](
     ...

    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 7, 2017 at 1:55 pm

    #1950033

  • RE: Please help on reformatting this table into another format using TSQL

    sgmunson - Thursday, July 6, 2017 2:25 PM

    Luis Cazares - Thursday, July 6, 2017 6:16 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

    July 7, 2017 at 1:13 pm

    #1950025

  • RE: Are the posted questions getting worse?

    DesNorton - Friday, July 7, 2017 6:43 AM

    Eirikur Eiriksson - Friday, July 7, 2017 4:41 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

    July 7, 2017 at 7:19 am

    #1949922

  • RE: Order by Clause in Union

    gvoshol 73146 - Friday, July 7, 2017 5:25 AM

    Perhaps he's obfuscating the true name of 12 different tables.

    That's why I'm asking...

    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 7, 2017 at 5:32 am

    #1949875

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Friday, July 7, 2017 4:48 AM

    My problem with FizzBuzz is I hardly ever have reason to use the symbols (like 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 7, 2017 at 5:30 am

    #1949874

  • RE: Slow Query

    Why are you using DISTINCT and UNION ALL? That might be the the reason you need the GROUP BY.

    SELECT s.SupplierID,
      c.Carrier as Supplier

    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 6, 2017 at 11:47 am

    #1949791

  • RE: What is the "industry standard" for "filtering" a query set?

    I agree with Lynn.
    Going a little bit further. Unless the conditions are set on a column from a table in an outer join, the conditions are on the WHERE...

    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 6, 2017 at 11:37 am

    #1949786

  • RE: Problem with using a field parameter, in a user defined function

    SqlServerCampbell - Thursday, July 6, 2017 10:28 AM

    ScottPletcher - Thursday, July 6, 2017 9:55 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

    July 6, 2017 at 11:01 am

    #1949774

  • RE: Please help on reformatting this table into another format using TSQL

    autoexcrement - Thursday, July 6, 2017 7:58 AM

    Humbled.

    We all had to learn at some point. I learned this technique from the following...

    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 6, 2017 at 10:44 am

    #1949768

  • RE: Are the posted questions getting worse?

    Eric M Russell - Thursday, July 6, 2017 7:30 AM

    FizzBuzz is an interesting programming problem, and just for kicks I 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 6, 2017 at 7:45 am

    #1949713

  • RE: Dynamic SQL

    Stewart "Arturius" Campbell - Thursday, July 6, 2017 7:20 AM

    Luis Cazares - Thursday, July 6, 2017 6:39...

    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 6, 2017 at 7:27 am

    #1949704

  • RE: Multiple Values for Single Parameter in User Defined Function

    jcelko212 32090 - Wednesday, July 5, 2017 1:12 PM

    Luis Cazares - Friday, May 26, 2017 9:41 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

    July 6, 2017 at 7:20 am

    #1949702

Viewing 15 posts - 1,126 through 1,140 (of 8,731 total)