Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 8,731 total)

  • RE: Finding / getting in touch with recruiters?

    jasona.work (6/11/2015)

    Jeff Moden (6/9/2015)

    On that note, give me some idea of where you'd actually like to work, area wise.

    Jeff, realistically, I'd probably (for the right price) go as far as...

    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

    June 12, 2015 at 9:32 am

    #1805095

  • RE: How to find the date created and date modified values of all files in a location.

    I'm not sure if you have explored this option or if it would be any better of what you've already got.

    IF OBJECT_ID('tempdb..#Files') IS NOT NULL DROP TABLE #Files;

    CREATE TABLE #Files(...

    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

    June 12, 2015 at 9:15 am

    #1805085

  • RE: Select Maximum, using filelds from 2 tables

    drew.allen (6/11/2015)

    Luis Cazares (6/11/2015)

    koles2004 (6/11/2015)

    I wanna specify: the second your variant is faster than first ?

    I can't assure that it's faster or better. The only way to ensure that is...

    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

    June 11, 2015 at 2:40 pm

    #1804837

  • RE: Select Maximum, using filelds from 2 tables

    koles2004 (6/11/2015)

    Both variants are right for my task )

    I like more my variant and your first variant.

    Your second variant i dont like )

    Any reason to 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

    June 11, 2015 at 1:56 pm

    #1804830

  • RE: Select Maximum, using filelds from 2 tables

    koles2004 (6/11/2015)

    I wanna specify: the second your variant is faster than first ?

    I can't assure that it's faster or better. The only way to ensure that is by testing over...

    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

    June 11, 2015 at 1:48 pm

    #1804827

  • RE: Previous Years Report

    Change the tables so they can be temp tables https://technet.microsoft.com/en-us/library/ms177399(v=sql.105).aspx

    Or table variables.

    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

    June 11, 2015 at 1:31 pm

    #1804820

  • RE: Previous Years Report

    I'm giving an example on how you should post your data. As you see, the code can be copied and ran without any major effort.

    I'm including a possible solution with...

    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

    June 11, 2015 at 1:03 pm

    #1804811

  • RE: Select Maximum, using filelds from 2 tables

    I would encourage you to change the way you write JOINs. That syntax is the old way and can become confusing with more complex queries and develop into unwanted cartesian...

    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

    June 11, 2015 at 12:39 pm

    #1804806

  • RE: Replacing Cursor Help in SQL 2008

    Some basic things here, probably we're missing something.

    Your declaration of the cursor uses 1 variable and you only use the column on that variable within the cursor.

    Basically, your code should...

    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

    June 11, 2015 at 11:01 am

    #1804783

  • RE: Apply And operator on same column

    Do you mind if I join the party?

    SELECT n.NewsId

    FROM #NewsEntities n

    WHERE EntityId = 1

    EXCEPT

    SELECT n.NewsId

    FROM #NewsEntities n

    WHERE EntityId = 2

    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

    June 11, 2015 at 9:01 am

    #1804727

  • RE: which is better for performance: LEFT join or NOT EXISTS

    Gail Shaw has a series of articles on her blog where she tests this options. This specific test is done here: http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    However, I would insist on following Phil's advice on...

    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

    June 11, 2015 at 8:51 am

    #1804722

  • RE: Error handling

    doug.davidson (6/11/2015)

    Iwas Bornready (6/11/2015)

    I knew it would error with some kind of overflow error but I don't have all the error codes memorized.

    +1

    Figured it out by elimination:

    1000 - wrong

    220 -...

    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

    June 11, 2015 at 8:46 am

    #1804718

  • RE: why isnull(amount, 0) doesn't return 0 when amount is null?

    Change the SELECT * to specify all the columns needed and generated after the pivot. Change the ISNULL to those columns.

    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

    June 9, 2015 at 9:53 am

    #1804016

  • RE: Can anyone help group this query result? Thanks.

    Or you could read the following article and learn how to do it yourself, either with pivot or cross tabs.

    http://www.sqlservercentral.com/articles/T-SQL/63681/

    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

    June 4, 2015 at 2:08 pm

    #1803168

  • RE: Are the posted questions getting worse?

    Ed Wagner (6/4/2015)

    rodjkidd (6/4/2015)

    Lynn Pettis (6/4/2015)

    Alvin Ramard (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? ...

    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

    June 4, 2015 at 12:33 pm

    #1803117

Viewing 15 posts - 4,831 through 4,845 (of 8,731 total)