Forum Replies Created

Viewing 15 posts - 451 through 465 (of 2,452 total)

  • RE: does DATEFROMPARTS() work in 2016?

    polkadot (8/13/2016)


    am working in dev environment sql server 2012. Need to create a date from 'snapshot month' (6) and 'snapshot year' (2016). Found DATEFROMPARTS() function works but wondering if...

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

  • RE: Credits and Debits

    drew.allen (8/12/2016)


    This is actually an improved version of the test harness. I am putting a slight edge on credits, so that they should appear 60% of the time. ...

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

  • RE: Credits and Debits

    drew.allen (8/11/2016)


    I did a quick comparison of J. Livingston's solution and my solution with 10,000 records. J. Livingston's solution did not account for multiple customers, whereas mine did. ...

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

  • RE: Credits and Debits

    is this close?

    --code based on ChrisM fine work at http://www.sqlservercentral.com/Forums/Topic1731617-391-1.aspx

    CREATE TABLE #t1

    (TransactionID INT,

    Customer INT,

    TransactionType VARCHAR(10),

    [Date] ...

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

  • RE: Apply Pivot in SQL Server

    User7766 (8/10/2016)


    Hi All,

    I've a table which gives the output when queried normally. I want to transform rows to columns and columns to rows to show it in a report.

    PromotionIn ...

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

  • RE: Are the posted questions getting worse?

    Sean Lange (8/8/2016)


    J Livingston SQL (8/8/2016)


    I see Brent Ozar is using torrent for the Stack Exchange Data Dump...I would dearly like to get the data for a future project, but...

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

  • RE: SQL Joins

    how are you joining your tables ?

    please read this and post back...thanks

    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: check for date / time overlap between records of two different tables

    please provide sample data and expected results......see here for how to do that 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: Are the posted questions getting worse?

    I see Brent Ozar is using torrent for the Stack Exchange Data Dump...I would dearly like to get the data for a future project, but am quite concerned about the...

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

  • RE: Sum 4 weeks sale amount into month

    can you please repost the original question....i was looking at this, and I cant find it either !

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

  • RE: help needed with sql update

    Phil Parkin (8/4/2016)


    dk98681 (8/4/2016)


    the link is showing a blank page.

    Try this:

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

    thanks Phil.

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

  • RE: help needed with sql update

    hi...would help us all to help you if you read this please

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

    and post back with the article's suggested method.

    thanks

    edit updated URL correctly

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

  • RE: Count the occurrence of word in a Resume Table

    ALan....consider the following please

    DECLARE @tblResumeTag TABLE ( int identity primary key, TextVersion varchar(8000));

    INSERT @tblResumeTag(TextVersion) VALUES

    ('I accelerated the development of the system by making rationale decisions based on my collaboration with...

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

  • RE: Add New Column with RowID

    ...its nearly bed o'clock here in the UK and I've got a 400 mile round drive tomorrow.

    hopefully someone else will help you out in the meantime.

    I will keep a...

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

  • RE: Add New Column with RowID

    Nusc (8/3/2016)


    Ok reset this thread.

    Here is the data:

    ftp://eclipse.ncdc.noaa.gov/pub/ibtracs/v03r08/wmo/csv/year/

    I want to do the following as illustrated on the microsoft website:

    add a line layer to map

    https://msdn.microsoft.com/en-us/library/ee240828.aspx#LineLayer

    They give an example with 3 points.

    I...

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

Viewing 15 posts - 451 through 465 (of 2,452 total)