Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 9,399 total)

  • RE: Remove time(date)

    jcachado (11/27/2015)


    Still searching...

    TO_CHAR(create_dtim, '%m-%d-%y')

    Returns the strange error:

    ERROR [HY000] [INTERSOLV][ODBC Informix driver][Informix]Unknown error message -19828.

    Regards,

    Cachado

    TO_CHAR is an Oracle SQL function. This is a SQL Server forum.

    If you're querying a...

  • RE: One to Many relationship in Join performance issue

    I like what you did on the document details table.

    Did you also create a nonclustered index on DocumentCodeList(invoiceid, srnumber)?

    Of course, the obligatory question is if you understand the dangers of...

  • RE: Best way to deploy 100+ sql files.

    A batch file is nothing more than a series of commands you can execute at a command prompt. Similarly, a stored procedure is a series of T-SQL statements that...

  • RE: DDL Trigger Execution

    Nice question. It really had me thinking. I don't know if I thought about it more than most, but as of now, 57% of the answers were correct....

  • RE: Happy Thanksgiving 2015

    I love date math. I hope everyone had a great Thanksgiving and ate too much. 😀

  • RE: Filestream filegroups

    djj (11/25/2015)


    Luis Cazares (11/25/2015)


    Rune Bivrin (11/25/2015)


    Where can I buy SQL Server 2015?:hehe:

    You don't need to buy it, is a free update that comes with Win10 Server Edition.

    :-D:hehe::-D:hehe:

    That's true, but you...

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/24/2015)


    Alvin Ramard (11/24/2015)


    Can anyone tell me why spammer, oops, I meant user, live068 has not been killed yet?

    Looks like it's spam ll you want day today.

    Oops, looks...

  • RE: Today's Random Word!

    Luis Cazares (11/24/2015)


    Alvin Ramard (11/24/2015)


    Spam

    Plenty

    Overflow

  • RE: Today's Random Word!

    djj (11/24/2015)


    TomThomson (11/24/2015)


    Ed Wagner (11/24/2015)


    Smaug

    worm

    Tongue

    Bearing

  • RE: Today's Random Word!

    DonlSimpson (11/24/2015)


    Ed Wagner (11/24/2015)


    Stuart Davies (11/24/2015)


    Ed Wagner (11/24/2015)


    crookj (11/23/2015)


    DonlSimpson (11/23/2015)


    Ed Wagner (11/23/2015)


    djj (11/23/2015)


    anthony.green (11/23/2015)


    Ed Wagner (11/23/2015)


    anthony.green (11/23/2015)


    djj (11/23/2015)


    anthony.green (11/23/2015)


    Ed Wagner (11/23/2015)


    anthony.green (11/23/2015)


    Ed Wagner (11/23/2015)


    Teach

    Gym

    Exercise

    lethargic

    Sleep

    Just Can't Get Enough

    Food

    Hunger

    Games

    Strategy

    Tactics

    Tractics (1975)

    Combat

    fatigue

    Fog

    Smog

    Smaug

  • RE: Are the posted questions getting worse?

    jasona.work (11/24/2015)


    GilaMonster (11/24/2015)


    jasona.work (11/24/2015)


    ThomasRushton (11/24/2015)


    Me, I'm heading down the path of nuking the server completely. But I'm in the wonderful world of being able to rebuild and redeploy a...

  • RE: The dotted table

    Luis Cazares (11/24/2015)


    It's not preference, it's simply good design.

    Agreed.

    Luis Cazares (11/24/2015)


    The syntax is completely correct.

    As Luis pointed out, that is the whole point of the question. We could argue...

  • RE: Today's Random Word!

    Stuart Davies (11/24/2015)


    Ed Wagner (11/24/2015)


    crookj (11/23/2015)


    DonlSimpson (11/23/2015)


    Ed Wagner (11/23/2015)


    djj (11/23/2015)


    anthony.green (11/23/2015)


    Ed Wagner (11/23/2015)


    anthony.green (11/23/2015)


    djj (11/23/2015)


    anthony.green (11/23/2015)


    Ed Wagner (11/23/2015)


    anthony.green (11/23/2015)


    Ed Wagner (11/23/2015)


    Teach

    Gym

    Exercise

    lethargic

    Sleep

    Just Can't Get Enough

    Food

    Hunger

    Games

    Strategy

    Tactics

    Tractics (1975)

    Combat

    fatigue

    Fog

  • RE: set nocount on

    No problem. Glad I could help. Thanks for the feedback.

  • RE: set nocount on

    Shahin (11/24/2015)


    you are right I dont want to see the line that says (37 rows affected) in the csv file.

    This the query that I run and it genrate the (37...

Viewing 15 posts - 4,606 through 4,620 (of 9,399 total)