Forum Replies Created

Viewing 15 posts - 4,546 through 4,560 (of 8,753 total)

  • RE: outputting a message based on query results

    christine 23290 (9/14/2015)

    I am trying to get this to work without having to write a cursor or something like that. I think it should be able to be done...

    September 14, 2015 at 1:06 pm

    #1826509

  • RE: SQL Server Start Problem.

    zzzzcarl (9/14/2015)

    Thanks to Eirikur and GilaMonster for your answers, which has helped me a lot.

    I thing the problem is solved. Now I have had 2 succesfully start of the...

    September 14, 2015 at 11:53 am

    #1826492

  • RE: One of the most complex Views i have ever seen (View nested into another view)

    ScottPletcher (9/14/2015)

    Check the compatibility level of the db. Compatibility needs to be at least 90 for ROW_NUMBER() to work.

    No, the compatibility level does not affect newer functionality.

    😎

    This will run...

    September 14, 2015 at 11:45 am

    #1826489

  • RE: Using a parameter as a server name in an execute SQL task

    Animal Magic (9/14/2015)

    Hi All,

    I was hoping someone could help me out with an issue which has been frustrating me this afternoon. All i am trying to do is pass...

    September 14, 2015 at 10:42 am

    #1826458

  • RE: Today's Random Word!

    DonlSimpson (9/14/2015)

    Ed Wagner (9/14/2015)

    BL0B_EATER (9/14/2015)

    Eirikur Eiriksson (9/14/2015)

    Ed Wagner (9/14/2015)

    Luis Cazares (9/14/2015)

    whereisSQL? (9/14/2015)

    anthony.green (9/14/2015)

    Ed Wagner (9/14/2015)

    Stuart Davies (9/14/2015)

    Ed Wagner (9/14/2015)

    anthony.green (9/14/2015)

    snickers

    Candy

    Girl

    Boy

    George

    Jungle

    Book

    Necessities

    Preriquisites

    prior

    Last

    First

    Leader

    September 14, 2015 at 10:10 am

    #1826441

  • RE: Today's Random Word!

    Ed Wagner (9/14/2015)

    Luis Cazares (9/14/2015)

    whereisSQL? (9/14/2015)

    anthony.green (9/14/2015)

    Ed Wagner (9/14/2015)

    Stuart Davies (9/14/2015)

    Ed Wagner (9/14/2015)

    anthony.green (9/14/2015)

    snickers

    Candy

    Girl

    Boy

    George

    Jungle

    Book

    Necessities

    Preriquisites

    September 14, 2015 at 8:41 am

    #1826386

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    Jeff Moden (9/14/2015)

    Eirikur Eiriksson (9/13/2015)

    Using heap to speed the inserts is like a very bad Credit Card deal, no transaction fees but X000% Annual interest rate:pinch:

    😎

    Jeff Moden (9/12/2015)

    It's a...

    September 14, 2015 at 12:54 am

    #1826285

  • RE: T-SQL Query to get the Month wise data

    Quick suggestion

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    /* Sample data from OP */

    DECLARE @EXISTING TABLE

    (

    [Month(YYYYMM)] INT NOT NULL

    ,Department...

    September 14, 2015 at 12:28 am

    #1826281

  • RE: SQLCMD Mode; Run all SQL files in a directory

    Thank you Jason for this write up, very good reference indeed!

    😎

    September 13, 2015 at 10:13 pm

    #1826273

  • RE: Alter login mean?

    vsamantha35 (9/13/2015)

    Hi All,

    What does the command do or what does it mean? When do we use it?

    Alter login [<loginname>] with name = [<loginname>];

    Thanks in advance.

    ALTER is a short-cut for...

    September 13, 2015 at 12:53 pm

    #1826262

  • RE: SQL Server Start Problem.

    Have you checked the [Install dir]\MSSQL\Log\ERRORLOG file?

    😎

    September 13, 2015 at 12:37 pm

    #1826256

  • RE: Today's Random Word!

    Ed Wagner (9/13/2015)

    whereisSQL? (9/12/2015)

    Ed Wagner (9/11/2015)

    BWFC (9/11/2015)

    Ed Wagner (9/11/2015)

    Eirikur Eiriksson (9/11/2015)

    anthony.green (9/11/2015)

    whereisSQL? (9/10/2015)

    Ed Wagner (9/10/2015)

    DonlSimpson (9/10/2015)

    Ed Wagner (9/10/2015)

    djj (9/10/2015)

    Ed Wagner (9/10/2015)

    whereisSQL? (9/10/2015)

    Luis Cazares (9/10/2015)

    Universe

    He-Man

    Conan

    Sword

    Katana

    Samurai

    Shogun

    Shaolin

    Monastery

    Hermetic

    Seal

    Karate Kid

    Wax

    Shine

    Shoe

    Walk

    September 13, 2015 at 12:13 pm

    #1826254

  • RE: Optimisation of unpivot/insert code

    Jeff Moden (9/13/2015)

    Because it's still an estimate of cost, I don't trust even the Actual Execution Plan when trying to determine which code will be faster or use fewer resources....

    September 13, 2015 at 10:53 am

    #1826250

  • RE: List from 1 to @AnotherNumber

    There is a subtle difference between these two queries, when measured back to back on 10^6 numbers then the former is around 25% faster than the latter although the difference...

    September 13, 2015 at 6:08 am

    #1826243

  • RE: Round

    For fun

    😎

    SELECT ROUND(0.999,-1);

    September 13, 2015 at 1:46 am

    #1826237

Viewing 15 posts - 4,546 through 4,560 (of 8,753 total)