Forum Replies Created

Viewing 15 posts - 391 through 405 (of 8,731 total)

  • RE: Convert Vertical table data to Horizontal table data with multiple columns

    taschmitz - Wednesday, July 25, 2018 11:19 AM

    I have attribute data, that is coming to me in, what I am calling a...

    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 25, 2018 at 12:22 pm

    #1998976

  • RE: Syntax to see when was my database was accessed last time

    bubby - Wednesday, July 25, 2018 11:36 AM

    Query to see when was my database was accessed last time

    Thanks in Advance,

    Regards,

    Bubby

    Have you tried...

    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 25, 2018 at 12:21 pm

    #1998974

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Wednesday, July 25, 2018 9:25 AM

    Luis Cazares - Wednesday, July 25, 2018 9:12 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 25, 2018 at 9:28 am

    #1998955

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Wednesday, July 25, 2018 7:40 AM

    drew.allen - Monday, July 23, 2018 2:51 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 25, 2018 at 9:12 am

    #1998953

  • RE: PARSE

    This is nice. I haven't really understood why was PARSE introduced and this gave me a better understanding. Some might argue that it wasn't needed while others will be...

    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 24, 2018 at 10:24 am

    #1998838

  • RE: Help on Self Join

    Noting that this is a Northwind database, I'm assuming that it's an example to learn about recursive CTEs. As mentioned, they can be expensive and easily outperformed by other methods....

    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 24, 2018 at 9:53 am

    #1998827

  • RE: Assistance with DATETIME calculation when comparing to VARCHAR column (Test code included)

    cor_dog2 - Tuesday, July 24, 2018 9:35 AM

    Hello, so I'm trying to get the difference in MINUTES between two columns.
    One column 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 24, 2018 at 9:44 am

    #1998822

  • RE: Need help in real time query tuning scenario in Adventure works

    Phil Parkin - Tuesday, July 24, 2018 8:42 AM

    JoNTSQLSrv - Tuesday, July 24, 2018 8:28 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 24, 2018 at 8:55 am

    #1998803

  • RE: Fetching cols from multiple tables in a cursor query

    Arsh - Monday, July 23, 2018 7:04 AM

    alastair.beveridge - Monday, July 23, 2018 4:18 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 23, 2018 at 10:09 am

    #1998632

  • RE: Trying to drop an invalid column name without recreating the table.

    duncanburtenshaw - Monday, July 23, 2018 8:40 AM

    thank you very much all, the command below dropped the column successfully.. much obliged!

    alter...

    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 23, 2018 at 8:44 am

    #1998618

  • RE: Trying to drop an invalid column name without recreating the table.

    Phil Parkin - Monday, July 23, 2018 8:36 AM

    The double quotes method seems to work, while using single quotes does not, which...

    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 23, 2018 at 8:42 am

    #1998615

  • RE: Trying to drop an invalid column name without recreating the table.

    Just double the closing brackets
    [ALTER PROCEDURE [dbo]].[AreaToEdge]] @WKT VARCHAR(MAX), @SEARCH_DISTANCE INT, @MARGIN INT = 10
    /*********************************]

    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 23, 2018 at 8:36 am

    #1998611

  • RE: Are the posted questions getting worse?

    Sean Lange - Monday, July 23, 2018 7:48 AM

    jasona.work - Monday, July 23, 2018 7:28 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 23, 2018 at 8:01 am

    #1998599

  • RE: Replacing " with nothing

    machzy - Thursday, July 19, 2018 7:56 AM

    Trying to replace any instances of " with nothing.

    When I try this expression REPLACE(Fields!Name.Value,""","") 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 19, 2018 at 8:06 am

    #1998200

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, July 19, 2018 6:04 AM

    Argh...
    So today I was all set to happily telework when it all went sideways 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

    July 19, 2018 at 6:50 am

    #1998176

Viewing 15 posts - 391 through 405 (of 8,731 total)