Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/4/2015)

    SQLRNNR (8/4/2015)

    Lynn Pettis (8/4/2015)

    SQLRNNR (8/4/2015)

    Steve Jones - SSC Editor (8/4/2015)

    Since we're all piling on the behavior of others, I was wondering.

    Is there value in getting the questions/knowledge that...

    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

    August 4, 2015 at 4:36 pm

    #1817349

  • RE: Conflicting results in SQLSERVER management studio: select * and Rt click table to edit rows

    Was it the same on the Object Explorer and the Query Editor?

    It's not possible to randomly return less rows using "select * from table" unless there's something else going 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

    August 4, 2015 at 1:32 pm

    #1817302

  • RE: Recursive update on 3000 rows

    Steve,

    That was bad generated sample data, not the real structure of the data.

    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

    August 4, 2015 at 1:29 pm

    #1817301

  • RE: Conflicting results in SQLSERVER management studio: select * and Rt click table to edit rows

    It's possible that you were connected to a different database or server.

    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

    August 4, 2015 at 1:17 pm

    #1817296

  • RE: cte Table updating RBAR-like

    Daryl AZ (8/4/2015)

    I didn't think through that updating temp table from a CTE to same temp table would be recursive.

    It's not recursive.

    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

    August 4, 2015 at 1:11 pm

    #1817294

  • RE: Are the posted questions getting worse?

    Alvin Ramard (8/4/2015)

    Steve Jones - SSC Editor (8/4/2015)

    Since we're all piling on the behavior of others, I was wondering.

    Is there value in getting the questions/knowledge that people lack in interviews...

    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

    August 4, 2015 at 1:02 pm

    #1817288

  • RE: cte Table updating RBAR-like

    Daryl AZ (8/4/2015)

    It feels like the CTE is acting more like RBAR then a result. My best thought is the updating #tReceive from a CTE against #tReceive is somehow...

    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

    August 4, 2015 at 12:48 pm

    #1817282

  • RE: can a foreign nationals find a job in BI position ?

    bghad1 (8/4/2015)

    Alvin Ramard (8/4/2015)

    FYI, there are many foreigners working in every imaginable IT position, including BI, in the US.

    are you sure that BI is not kinda restricted area of 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

    August 4, 2015 at 12:32 pm

    #1817272

  • RE: Recursive update on 3000 rows

    You almost got it, but we need the real structure instead of rows of delimited strings. I guess you forgot to click on the "Convert CSV to SQL Insert" button.

    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

    August 4, 2015 at 12:22 pm

    #1817269

  • RE: Set field value in select statement

    drew.allen (8/4/2015)

    Actually, those two queries are not equivalent. The first query allows dates that are before '20150101', whereas the second does not. While it's highly likely that the OP...

    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

    August 4, 2015 at 11:33 am

    #1817253

  • RE: Recursive update on 3000 rows

    Hi welcome to the forums.

    What you explain might be possible, but a simple pdf with truncated rows won't help. We need DDL, sample data as insert statements and the expected...

    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

    August 4, 2015 at 9:52 am

    #1817219

  • RE: READPAST vs. NOLOCK

    Stewart "Arturius" Campbell (8/4/2015)

    JP Dakota, PRC (8/4/2015)

    Did you execute queries 1 & 2 in seperate query windows to the initial? Yes

    If you did do that, did you execute them while...

    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

    August 4, 2015 at 9:14 am

    #1817200

  • RE: parsing a line post import

    Edward-445599 (8/4/2015)

    I have a table which has been import from a TXT file. Most lines can be ignored, but when I get a line like this

    ' ...

    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

    August 4, 2015 at 9:09 am

    #1817174

  • RE: Delele condition

    You've been here long enough to know that you should post DDL and sample data to get a coded solution.

    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

    August 4, 2015 at 9:02 am

    #1817171

  • RE: Delele condition

    pietlinden (8/4/2015)

    So how do you identify the records you want to save?

    TOP 50 (with a cross apply).

    then delete the rest... so either NOT IN ... or outer join...

    That's 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

    August 4, 2015 at 8:59 am

    #1817168

Viewing 15 posts - 4,516 through 4,530 (of 8,731 total)