+ Reply to Thread
Results 1 to 5 of 5
  1. Senior Member
    Join Date
    May 2016
    Posts
    1,641
    #1

    Default Updating Title - SQL Discussions and links

    In the spirit of SQL I thought it would be a cool idea to create a thread that shows any new type of SQL you might want to share with the community. Anything you think would be helpful. I love writing SQL and love seeing what others have to write. How you get around tough situations etc.

    Updated

    Also post articles you may find interesting in the database space that ties to MS.
    Last edited by DatabaseHead; 06-16-2016 at 05:35 PM.
    Reply With Quote Quote  

  2. SS -->
  3. Reticulating splines... iBrokeIT's Avatar
    Join Date
    Jul 2013
    Location
    Twin Cities, MN
    Posts
    1,044

    Certifications
    GCIH, GSEC, VCAP5-DCA, VCP5-DCV, MCITP:EA, MCSA 2003/08
    #2
    ' or 1=1'--

    Reply With Quote Quote  

  4. Senior Member cyberguypr's Avatar
    Join Date
    May 2007
    Location
    Chicago, IL
    Posts
    5,779

    Certifications
    GCFE, GCED, GCIH, CISSP, CCSP, and others that should never be mentioned
    #3
    What in the world! I came here to post the same thing. LOL!!!!
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2016
    Posts
    1,641
    #4
    Well I guess I should follow up with something I like to use from time to time.

    I'm not really in "IT" I work with data exclusively. One thing I like to use when managing a catalog is between dates

    WHERE
    GETDATE() BETWEEN DATEADD(MONTH, -1, A.PRC_EFF) AND ISNULL(DATEADD(MONTH, -1, A.PRC_END), '9999-01-01')

    In this where I am looking back one month from when this script is executed. I have a JOB schedule to pull our catalog and dump into another table for ease of use, performance as well. The ISNULL is nice because it gives you the end date, since most end dates are null, this cast a value in there 9999-01-01 (Basically to the end of time).

    The reason I am using the job is to pivot out our price points since our table in interleaved
    Last edited by DatabaseHead; 06-16-2016 at 03:34 PM.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    May 2016
    Posts
    1,641
    #5
    Found this post in regards to master data management. Found this very insightful.

    https://msdn.microsoft.com/en-us/library/bb190163.aspx
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks