Forum Replies Created

Viewing 15 posts - 721 through 735 (of 3,666 total)

  • RE: Return data between two dates in the past

    Lynn Pettis (6/7/2015)


    Alvin Ramard (6/6/2015)


    SandyTucker (6/6/2015)


    Hello - does anyone know why the statement "where WD.WRKD_WORK_DATE BETWEEN DATEADD(DD, -6, GETDATE()) AND GETDATE()) = 0' is successful, but "WD.WRKD_WORK_DATE BETWEEN (DATEADD(DD,...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Return data between two dates in the past

    SandyTucker (6/6/2015)


    Hello - does anyone know why the statement "where WD.WRKD_WORK_DATE BETWEEN DATEADD(DD, -6, GETDATE()) AND GETDATE()) = 0' is successful, but "WD.WRKD_WORK_DATE BETWEEN (DATEADD(DD, -16, GETDATE())) AND (DATEADD(DD,...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (6/4/2015)


    And, back on topic, can anyone help our poor, out-of-his-depth friend with locating a time machine?

    http://www.sqlservercentral.com/Forums/Topic1691611-391-1.aspx

    ... back on topic... ???? How dare you? 😀

    Can you get his address and...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Job Notifications Tutorial

    One of the search results is: https://msdn.microsoft.com/en-us/library/ms191130.aspx

    If this is not enough information, then ask specific question(s) about the part(s) you have trouble with.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Job Notifications Tutorial

    Take a look at this: http://www.lmgtfy.com/?q=sql+server+agent+job+notification+email+



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Update Statement and Case Statement

    ChrisM@home (6/4/2015)


    dwilliscp (6/4/2015)


    Is there a way to use a case statement after "SET"? I am currently getting the following..

    Msg 156, Level 15, State 1, Line 2

    Incorrect syntax near the keyword...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (6/4/2015)


    Jeff Moden (6/4/2015)


    Shifting gears a bit...

    Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Save data in word input file to SQL table

    I can almost guarantee that there will not be any easy way to import the data into SQL Server.

    The first thing I would do, is to save the file in...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/4/2015)


    Shifting gears a bit...

    Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I think such a thing would...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSIS dataflow - passing nulls (blanks) from query (source) to csv (destination)

    Brian Seib (6/4/2015)


    Good morning - I have a SSIS dataflow that I am simply pulling data from a query (ODBC Source), and outputting this to a .csv file on a...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: An expression of non-boolean type specified in a context where a condition is expected, near 'AND'.

    kuchanarajendraprasad (6/4/2015)


    WHERE

    CASE @UWDECISSION

    WHEN 'DECLINED' THEN (SELECT [TBL_IL_PTRNPF].BATCTRCDE FROM [TBL_IL_PTRNPF] WHERE BATCTRCDE = 'T644')

    WHEN 'POSTPONED' THEN (SELECT [TBL_IL_PTRNPF].BATCTRCDE FROM [TBL_IL_PTRNPF] WHERE BATCTRCDE = 'TA63')

    ELSE (SELECT [TBL_IL_PTRNPF].BATCTRCDE FROM [TBL_IL_PTRNPF] WHERE...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GilaMonster (6/4/2015)


    *sigh*

    I swear some people don't actually want help.

    Oh they want help, but the only help they want is the final solution. They don't want to have to do anything...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: SSMS truncating PowerShell output

    One option would be to send the results to file. I know I'd like a better option, but it's better than nothing.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (6/3/2015)


    Jeff Moden (6/1/2015)


    Maybe it's just me. I might be getting too old for this business. [/url]

    three words too many 😀

    3 words? So he...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Unable to insert data into float columns

    What error message are you getting?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 721 through 735 (of 3,666 total)