Forum Replies Created

Viewing 15 posts - 181 through 195 (of 2,452 total)

  • RE: Rolling 6 Months

    wenger.noah - Thursday, June 15, 2017 8:11 AM

    Great! It worked!  Thanks for a little help from my friends....new problem:

    Same table/different value...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Query displaying redundant data for a menu item, menu has choices, but displays menu item multiple times with different choices

    chef423 - Wednesday, June 14, 2017 12:40 PM

    Here are the 5 Tables with some sample data, taken directly from the database.

    This...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Need Suggestions on Best way to Query Data

    https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Maths Problem

    been done on many sites.....here's one with 844 comments  :w00t::w00t:

    https://flowingdata.com/2011/10/28/best-statistics-question-ever/

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Pivot Query Help

    inayatkhan - Monday, June 12, 2017 10:01 AM

    Issue is DE not always "A","B","C"

    ok....so please provide sample data that gives us ALL the...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Unable to get data from Joins

    it appears you are "joining" on the actual counts...which is not what you want.

    maybe something along these lines....

    SELECT COUNT(CustomerAccountNumber) AS total,
       SUM(CASE
         WHEN DATEDIFF(MM,...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Change in Salary

    ajspencer - Monday, June 5, 2017 2:19 PM

    I'm running SQL Server 2012 Verision 11

    ...great

    and in which SQL table are these salary details...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Change in Salary

    ajspencer - Monday, June 5, 2017 2:03 PM

    Hello all,

    Can some guide me please.  I need a script that will show me changes...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: float to date

    Eirikur Eiriksson - Tuesday, May 23, 2017 8:27 AM

    J Livingston SQL - Tuesday, May 23, 2017 5:30...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Dynamic Statement with Cursor loop, help

    peter larsen-490879 - Tuesday, May 23, 2017 1:20 AM

    needs to be like this:

    +-----------+--------+--------+--------+--------+
    | Company | Item 1 | Item 2...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: float to date

    DECLARE @d FLOAT= 201601;
    SELECT CONVERT( DATE, CONVERT(VARCHAR(8), CONVERT(INT, @d * 100 + 1)));

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: float to date

    deleted ....code window failing

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: t-sql 2012 parse out multiple values in one field that is varchar(1200)

    wendy elizabeth - Monday, May 22, 2017 3:58 PM

    Where can I access NGrams8K or DelimitedSplit8K in the sql server 2012 database?
    I want to...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Calculating Hours worked in particular shift

    SQL006 - Monday, May 22, 2017 6:04 AM

    I am looking to calculate the Night_Start_Time,Night_Shift_End,Night_Shift_Duration
    We have defined the Night_Shift_Start_Time = 22:00 hrs and...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: D@RE for SQL

    is this what you are speaking of?

    https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption-tde

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 181 through 195 (of 2,452 total)