Forum Replies Created

Viewing 15 posts - 376 through 390 (of 2,452 total)

  • RE: ProgressDB data dump to SQL server DB

    have you seen this article

    https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmsql/migrating-an-openedge-database-to-ms-sql-server.html#

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

  • RE: Convert Columns to Rows

    j-1064772 (9/14/2016)


    J Livingston SQL (9/14/2016)


    j-1064772 (9/14/2016)


    Clear explanation, thank you all.

    Still not in the mindset of a million rows ... My DB's are considerably more modest.

    "Still not in the mindset of...

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

  • RE: Convert Columns to Rows

    j-1064772 (9/14/2016)


    Clear explanation, thank you all.

    Still not in the mindset of a million rows ... My DB's are considerably more modest.

    "Still not in the mindset of a million rows"......neither was...

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

  • RE: Quert Required

    The Dixie Flatline (9/14/2016)


    Great minds?

    "...fools seldom differ" :-D:-D:-D

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

  • RE: Quert Required

    http://www.sqlservercentral.com/Forums/FindPost1817587.aspx 😀

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

  • RE: Query Required

    maybe....?

    SELECT registerno,

    LevelOneMark,

    LeveltwoMark,

    LevelthreeMark,

    FinalMark

    FROM

    (

    ...

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

  • RE: Transform transactions into report without using cursors

    can you please confirm what version of SQL you are using.....looking at some of your previous posts I cannot be sure.

    thanks

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

  • RE: SQL Surface Area Configuration Manager Audit

    Welsh Corgi (9/13/2016)


    I'm doing something wrong for I do not have that option in the drop down list.

    what does this return

    SELECT @@VERSION

    ________________________________________________________________
    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?

    drew.allen (9/13/2016)


    I recently submitted my first article for SSC. I got some great feedback on my rough drafts. Thanks Chris, Graham, and Wayne. I'm not sure what...

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

  • RE: Filling Buckets

    ashishkumarrai (9/13/2016)


    It seems this is not what I am after. I want the filler data to feed to bucket in recursive way and store each recursion. the output should look...

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

  • RE: SQL Surface Area Configuration Manager Audit

    Welsh Corgi (9/13/2016)


    I just want to accomplish the following in SQL Server 2012.

    The instructions provided are for SQL Server 2008.

    "Provide a screenshot showing that Adhoc Remote Queries are disabled by...

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

  • RE: Run out dates

    by any chance do you have access to the raw(unpivoted data)...me thinks it would be easier to provide solution

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

  • RE: Filling Buckets

    CELKO (9/10/2016)


    CREATE TABLE Buckets

    (bucket_nbr INTEGER NOT NULL PRIMARY KEY,

    bucket_size INTEGER NOT NULL

    CHECK (bucket_size > 0,

    bucket_contentINTEGER NOT NULL

    CHECK (bucket_content BETWEEN 0 AND bucket_size)

    );

    INSERT INTO Buckets (bucket_size,...

    ________________________________________________________________
    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?

    Gazareth (9/10/2016)


    What have I started here?! Haha

    go on...show us yours:-D

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

  • RE: Filling Buckets

    ashishkumarrai (9/9/2016)


    Posted my problem with all the details and sample data over here. https://ask.sqlservercentral.com/questions/140089/sql-server-2008-cte-bucket-filling.html

    can you please provide your expected results from the sample data?

    edit >>>

    is this the result you are...

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

Viewing 15 posts - 376 through 390 (of 2,452 total)