Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 8,731 total)

  • RE: TSQL query

    I hope that you're not using strings or integers to store dates.

    To achieve this, I'd recommend an inline table-valued function based on a tally (or numbers) table[/url]. With that, the...

    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

    November 29, 2016 at 1:09 pm

    #1915033

  • RE: Today's Random Word!

    DamianC (11/29/2016)

    Ed Wagner (11/29/2016)

    djj (11/29/2016)

    Manic Star (11/29/2016)

    Ed Wagner (11/28/2016)

    Manic Star (11/28/2016)

    DamianC (11/28/2016)

    Ed Wagner (11/28/2016)

    Manic Star (11/28/2016)

    Ed Wagner (11/28/2016)

    djj (11/28/2016)

    Ed Wagner (11/26/2016)

    DamianC (11/26/2016)

    Ed Wagner (11/26/2016)

    TomThomson (11/24/2016)

    Brandie Tarvin (11/23/2016)

    Manic Star (11/23/2016)

    Luis Cazares...

    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

    November 29, 2016 at 10:46 am

    #1915006

  • RE: Query required for my scnario

    vs.satheesh (11/29/2016)

    Hi , I am using sqlserver 2005, UIn my scenario I need apply gracing marks for following scenario.

    drop table #temptable

    create table #temptable (USN varchar(15),Scode varchar(10),Theory_Mark int,Practical_mark...

    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

    November 29, 2016 at 7:06 am

    #1914939

  • RE: No data in one column of a view (NULL value instead

    You could certainly format the code yourself or use a tool like poorsql.com

    On the other hand, we need DDL and sample data in a consumable format. Read the links in...

    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

    November 23, 2016 at 10:31 am

    #1914284

  • RE: Recursive CTE

    info 58414 (11/23/2016)

    Hi,

    i have a Select with this Result;

    ID RowCount

    FKR000000000001 34

    FKR000000000002 21

    FKR000000000003 28

    Can i write a recursive Cte, which generates as many records as the RowCount indicates.

    For...

    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

    November 23, 2016 at 9:43 am

    #1914271

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/23/2016)

    robert.sterbal 56890 (11/23/2016)

    What is on your menu for Thanksgiving?

    Can you share any recipes?

    Our family will be having Thanksgiving at my wife's parents with turkey, gravy,...

    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

    November 23, 2016 at 9:07 am

    #1914259

  • RE: Are the posted questions getting worse?

    robert.sterbal 56890 (11/23/2016)

    What is on your menu for Thanksgiving?

    Hopefully, some football :hehe:

    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

    November 23, 2016 at 8:29 am

    #1914243

  • RE: Today's Random Word!

    Brandie Tarvin (11/23/2016)

    Pie!

    Apple

    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

    November 23, 2016 at 7:24 am

    #1914227

  • RE: Too many stored procedures

    What if someone creates a stored procedure that elevates their privileges? Are you protected from 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

    November 23, 2016 at 6:57 am

    #1914218

  • RE: Today's Random Word!

    Ray K (11/22/2016)

    Ed Wagner (11/22/2016)

    TomThomson (11/22/2016)

    Revenant (11/22/2016)

    Luis Cazares (11/22/2016)

    djj (11/22/2016)

    Ed Wagner (11/22/2016)

    patrick.w.wheeler (11/22/2016)

    Ed Wagner (11/22/2016)

    Manic Star (11/22/2016)

    djj (11/22/2016)

    Sleep

    Dream

    REM

    Stand

    Stephen King

    Fiction

    Science

    Art

    Craft

    Starcraft

    Aircraft

    Warcraft

    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

    November 22, 2016 at 12:40 pm

    #1914108

  • RE: Help

    You just need to invert the logic.

    DECLARE

    @StartDate DATE

    ,@EndDate DATE;

    set @StartDate = DATEADD( day,-30, getdate());

    set @EndDate = GETDATE();

    SELECT *

    FROM(

    SELECT...

    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

    November 22, 2016 at 12:11 pm

    #1914099

  • RE: Today's Random Word!

    djj (11/22/2016)

    Ed Wagner (11/22/2016)

    patrick.w.wheeler (11/22/2016)

    Ed Wagner (11/22/2016)

    Manic Star (11/22/2016)

    djj (11/22/2016)

    Sleep

    Dream

    REM

    Stand

    Stephen King

    Fiction

    Science

    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

    November 22, 2016 at 10:11 am

    #1914061

  • RE: Multiple calls to MAX(datecolumn) in select

    andis59 (11/22/2016)

    Thank you Luis.

    I realize that I have a long way to go in the world of SQL.

    // Anders

    The good part is that you're moving forward. 😉

    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

    November 22, 2016 at 9:08 am

    #1914037

  • RE: Multiple calls to MAX(datecolumn) in select

    andis59 (11/21/2016)

    Is there any difference in performance?

    BTW, does the size of the database table has any impact on the Tuning Advisor and the time it takes to finish?

    There's no significant...

    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

    November 22, 2016 at 7:51 am

    #1914011

  • RE: Unable to run Dir using xp_cmdshell

    I'll guess that you have a proxy account set to use xp_cmdshell. I'm also guessing that you're not using a sysadmin account to run xp_cmdshell. Then, I'll guess that the...

    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

    November 22, 2016 at 7:18 am

    #1914000

Viewing 15 posts - 1,816 through 1,830 (of 8,731 total)