Forum Replies Created

Viewing 15 posts - 31 through 45 (of 2,903 total)

  • RE: Synch 2 tables; performance

    Using SQL2012, you have the TABLEDIFF option. I'd look into that. Each table would need a PK though. You tell it which is the source database/table and the...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/3/2016)


    What ever happened to basic problem solving skills?

    Basic Problem Solving Skills checklist:

    1. post issue on SQL Server Central without examples or all the details

    2. if you don't get...

  • RE: Temporary tables

    While probable not quite accurate...the way to think about is this way...when using a single # think of it as being owned by the schema that made it:

    Conn1.temp01

    Conn2.temp01

    When using a...

  • RE: Calculating diffrence in minutes using datetiff function

    JALLYKAMOZE (8/30/2016)


    Hello,

    I have a problem where i want to get the diffrence in minutes between two times, my datatype is TIME, i have also used the function below

    ABS(DATEDIFF (MINUTE,...

  • RE: Stored Procedure with error handling

    A couple of suggested Error messages:

    --If the parameter is NULL return:

    Parameter is not supplied. This stored procedure requires one parameter.

    --If no data is found return:

    Data not found based on supplied...

  • RE: Better Coding

    Matt Miller (#4) (8/25/2016)


    Eric M Russell (8/25/2016)


    Matt Miller (#4) (8/25/2016)


    SQLBill (8/25/2016)


    Eric M Russell (8/25/2016)


    I'm not surprised that a small group of students could take a public dataset and spin up...

  • RE: Better Coding

    Eric M Russell (8/25/2016)


    I'm not surprised that a small group of students could take a public dataset and spin up a better application than the original government IT contractors. When...

  • RE: Today's Random Word!

    Manic Star (8/19/2016)


    Kaye Cahs (8/19/2016)


    Hugo Kornelis (8/19/2016)


    Ed Wagner (8/19/2016)


    Luis Cazares (8/19/2016)


    Ed Wagner (8/19/2016)


    Chainsaw

    Massacre

    Texas

    Dallas

    Cowboy

    Cheerleader

    Debby

  • RE: Today's Random Word!

    Debby

  • RE: How do I flatten this data out to one row?

    But isn't your results from two different weeks (week 26 and week 27)? Why would you be combining them into one week? Shouldn't it be the first two...

  • RE: Execute Proc at Startup Question

    Another option is to create a job. One of the schedule options for jobs is "Start Automatically when SQL Agent starts".

    -SQLBill

  • RE: Byte Me: Behind Times

    Heck with floppies...my first computer used a cassette tape.

    -SQLBill

  • RE: Copy huge table from one server to another

    Here's an example of using BCP:

    use info

    go

    declare @sql varchar(2000), @command varchar(2000)

    set @sql = '

    SELECT ID,Type,Value, GETDATE() FROm info.dbo.temp'

    set @command = 'bcp "'+@sql + '" queryout \\servername\drive:\info_temp.data -T -c -b10000'

    print @command

    --exec...

  • RE: Policy

    Not that I'm aware of, however, you could add a trigger that would stop them from doing the insert or whatever (INSTEAD OF trigger) and instead of doing the work,...

  • RE: I am really getting depressed

    I am experienced tableau developer with SSIS and SQL

    Maybe that job title/experience is too narrow and not needed at most companies. One issue I've heard as a problem...

Viewing 15 posts - 31 through 45 (of 2,903 total)