Forum Replies Created

Viewing 15 posts - 2,551 through 2,565 (of 15,381 total)

  • RE: Proc that create views with table name and a table field parameter (scalar variable issue)

    blossom_suki (8/4/2015)

    I would like to create a procedure which create views by taking parameters the table name and a field value (@Dist).

    However I still receive the must declare the scalar...

    August 4, 2015 at 8:24 am

    #1817130

  • RE: A script to find a value in all databases

    WhiteLotus (8/4/2015)

    HI all,

    Anyone has a script to find a value in all databases ? for example I want to find a value contain word “ SQL” in all databases so...

    August 4, 2015 at 7:32 am

    #1817109

  • RE: READPAST vs. NOLOCK

    Hany Helmy (8/4/2015)

    Good question, thanx, using NOLOCK a lot.

    You really shouldn't be in the habit of littering your database with that hint unless you TRULY understand what it does. It...

    August 4, 2015 at 7:15 am

    #1817096

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (8/3/2015)

    Did you just discover a modern dr. jekyll and mr. hyde?

    😎

    LOL no. I have noticed it before, we have even discussed it in the past (probably here in...

    August 3, 2015 at 12:32 pm

    #1816938

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/3/2015)

    Read the following comment made today by Silver Spoon on a 4 year old thread:

    ok, thank you very much.

    I inherited these databases so I'm very green but thank...

    August 3, 2015 at 10:02 am

    #1816883

  • RE: Are the posted questions getting worse?

    WayneS (8/3/2015)

    Alvin Ramard (8/3/2015)

    Jeff Moden (8/2/2015)

    Alvin Ramard (8/1/2015)

    Jeff Moden (7/31/2015)

    Alvin Ramard (7/31/2015)

    I guess I've had enough of this forum for this week.

    http://www.sqlservercentral.com/Forums/Topic1707595-2799-1.aspx

    You did fine and you're absolutely spot on....

    August 3, 2015 at 9:44 am

    #1816867

  • RE: Delete duplicate rows from ANY table.

    ben.brugman (8/3/2015)

    Luis Cazares (8/3/2015)

    If a constraint prevents actions that are valid, it's a design fault. Can you give an example on a constraint that prevents actions which are functional?

    We have...

    August 3, 2015 at 9:11 am

    #1816853

  • RE: But we've always done it that way…

    Luis Cazares (8/3/2015)

    Sean Lange (8/3/2015)

    Michael L John (8/3/2015)

    I just left a position because I got tired of hearing "That's the way we always did it" AND 'We don't have time...

    August 3, 2015 at 8:34 am

    #1816836

  • RE: Hide a column from select

    adonetok (8/3/2015)

    The Count of ORDERID will be determined by run time.

    In fact, table ORDER should name it as ORDERHISTORY.

    Any adding, modifying orders will save to ORDERHISTORY using the same ORDERID.

    What...

    August 3, 2015 at 8:12 am

    #1816829

  • RE: But we've always done it that way…

    Michael L John (8/3/2015)

    I just left a position because I got tired of hearing "That's the way we always did it" AND 'We don't have time to do it right".

    Together,...

    August 3, 2015 at 8:09 am

    #1816826

  • RE: Logical File Names

    Ed Wagner (8/3/2015)

    Sean Lange (8/3/2015)

    Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we...

    August 3, 2015 at 8:05 am

    #1816821

  • RE: Hide a column from select

    adonetok (8/3/2015)

    I used code below, it works but I am not sure it is good.

    select distinct ORDERID from (select top 100 percent ORDERID,ORDERDate from ORDER where ORDERID = '123456' order...

    August 3, 2015 at 7:48 am

    #1816813

  • RE: Hide a column from select

    adonetok (8/3/2015)

    I rand code below but got an error said

    ORDER BY items must appear in the select list if SELECT DISTINCT is specified

    select distinct ORDERID from ORDER where ORDERID =...

    August 3, 2015 at 7:36 am

    #1816802

  • RE: Logical File Names

    Again lots of complaining. Come on people get over it. The question of the day is intended to provoke some learning. Guess what, as humans we learn more from our...

    August 3, 2015 at 7:34 am

    #1816801

  • RE: Delete duplicate rows from ANY table.

    Lynn Pettis (7/31/2015)

    Sean Lange (7/31/2015)

    Lynn Pettis (7/31/2015)

    Sean Lange (7/31/2015)

    ScottPletcher (7/31/2015)

    Technically "usp_" is illogical, since "sp_" stands for "special", but "usp_" wouldn't be meant as "user special".

    I would offer that a...

    July 31, 2015 at 2:48 pm

    #1816570

Viewing 15 posts - 2,551 through 2,565 (of 15,381 total)