Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 8,731 total)

  • RE: Getting Started

    If there's a PASS user group near you, you could start there. It doesn't need to be from PASS, but it would be the obvious choice.

    For general public speaking,...

    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

    February 24, 2016 at 8:25 am

    #1860745

  • RE: Where statment and external txt file

    Using OPENROWSET is a bad idea when combined with an update (if at all possible). You should import the values from the text file into a table. To do 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

    February 24, 2016 at 8:15 am

    #1860734

  • RE: how to loop without endless joins

    Does this article work for you?

    http://www.sqlservercentral.com/articles/set-based+loop/127670/

    I could give you an answer, but I already wrote the whole explanation in there. 😀

    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

    February 24, 2016 at 7:46 am

    #1860725

  • RE: String value "looking" the same, but there is a difference (cannot use distinct)

    donstarter (2/24/2016)

    Hi all,

    I am having an issue with using distinct on one single column in a table and getting multiple result rows for a string "looking" the same. When I...

    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

    February 24, 2016 at 7:39 am

    #1860722

  • RE: How to pull certain data by month (Jan, Feb) from a Date table with the output having columns for each month.

    Check the following articles to learn how to use cross tabs, which will get you exactly what you need.

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

    This is SQL Server based code and it's not guaranteed to work...

    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

    February 24, 2016 at 7:27 am

    #1860716

  • RE: Getting the Date picker and Print buttons in Chrome

    Is using IE Tab an option?

    http://www.ietab.net/

    It allows to run Internet Explorer inside Chrome.

    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

    February 24, 2016 at 7:20 am

    #1860711

  • RE: CHECKING specific values

    Terry.Traweek (2/24/2016)

    "Active" <> "ACTIVE"

    "Inactive" <> "Inactive"

    Null is OK

    1 row will be inserted

    Us defaults, so collation is case insensitive.

    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

    February 24, 2016 at 6:28 am

    #1860689

  • RE: CHECKING specific values

    Sergiy,

    Could you share the details of the version you're using? On my laptop with 2012 SP1, I get 3 rows when running the entire script at once.

    Unless you used...

    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

    February 23, 2016 at 9:25 pm

    #1860618

  • RE: Date Format

    You didn't format the first row. Format will convert the values into strings.

    I don't remember if it's possible to assign a format to the parameter available values, to use a...

    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

    February 23, 2016 at 1:53 pm

    #1860562

  • RE: LAst date's for past 3 months

    sharonsql2013 (2/23/2016)

    Something like this SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) .

    But how to get for Dec and Nov?

    Use a numbers table or build one on the fly or adjust as necessary.

    SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-n,0))...

    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

    February 23, 2016 at 1:12 pm

    #1860551

  • RE: LAst date's for past 3 months

    Try to understand how this routines work and you'll get the correct formula for your problem.

    http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

    I'll explain the first one and you can get the rest.

    select dateadd(dd, datediff(dd, 0, @ThisDate),...

    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

    February 23, 2016 at 1:09 pm

    #1860548

  • RE: Are the posted questions getting worse?

    Alan.B (2/23/2016)

    I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then...

    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

    February 23, 2016 at 12:30 pm

    #1860535

  • RE: Career in SQL

    As long as you use the certification as a way to learn, it could help you. However, most people won't hire you just by having a certification, you need to...

    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

    February 23, 2016 at 10:48 am

    #1860503

  • RE: MCSA: Microsoft SQL Server 2008

    jbrown414 (2/23/2016)

    Thanks for your response Grant. At what point do you feel experience outweighs the need for a certification? I'm coming up on 7 years as being a...

    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

    February 23, 2016 at 10:35 am

    #1860497

  • RE: CHECKING specific values

    Sean Lange (2/23/2016)

    Ed Wagner (2/23/2016)

    Sean Lange (2/23/2016)

    I am shocked at how many people (9% at time of this post) said there would be 4 rows. :w00t:

    Excellent question Steve.

    That is interesting,...

    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

    February 23, 2016 at 7:58 am

    #1860411

Viewing 15 posts - 3,286 through 3,300 (of 8,731 total)