Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,251 total)

  • RE: Are the posted questions getting worse?

    Am I being cynical in thinking that 'cracked it' means 'can't be bothered to provide sample data'?

    http://www.sqlservercentral.com/Forums/FindPost1625755.aspx

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 15, 2014 at 4:47 am

    #1752458

  • RE: Help Newbie here, new to sql

    Have a look the example below.

    create table #EventHeader(

    HistoryIDint primary keynot null

    ,DateTimeHappened datetimenot null

    )

    create table #EventDetail

    (

    HistoryIDint

    ,DetailIDint primary key not null

    ,DateTimeProcessed datetimenot null

    ,ProcessedBy varchar(20)not null

    )

    insert into #EventHeader

    select 100001, '2014-07-23...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 15, 2014 at 3:42 am

    #1752431

  • RE: Create a stored procedure

    paul.knibbs (10/15/2014)

    Maybe the author chose the column name deliberately to catch out people who just run the SQL rather than thinking about their answer? I mean, the error about incorrect...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 15, 2014 at 2:11 am

    #1752406

  • RE: Handling Inconvenient Requests

    On occasions when particular managers have said something's urgent my first thought has been 'I'll be the judge of that'. Often a quick phone call has revealed that the...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 15, 2014 at 1:58 am

    #1752401

  • RE: Create a stored procedure

    Mauricio N (10/15/2014)

    Same error: Msg 156, Level 15, State 1, Procedure my_sp, Line 2

    Incorrect syntax near the keyword 'FROM'.

    +1

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 15, 2014 at 1:26 am

    #1752397

  • RE: Help Newbie here, new to sql

    How did you fix it in the end?

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 7:53 am

    #1752221

  • RE: Help Newbie here, new to sql

    It's a start 🙂 Could you post examples of the data in your tables next please? Have a look at this article

    http://www.sqlservercentral.com/articles/Best+Practices/61537/ and it'll show you how. As...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 6:51 am

    #1752196

  • RE: Help Newbie here, new to sql

    As I've said before, please can you post some sample data. It will make it much easier to see where there might be a problem.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 6:39 am

    #1752190

  • RE: SQL Server Agent Problem

    I wish I was. It's not installed on this server and neither can I actually install it. I'm doing this direct into SQL Server Agent.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 6:21 am

    #1752185

  • RE: Help Newbie here, new to sql

    Will not do or does not do?

    Could you post some sample data please? It will make it much easier to establish what's wrong if we've got an idea what...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 5:47 am

    #1752174

  • RE: SQL Server Agent Problem

    The owner of the job is me and the job is run by svc_xxxxr2Agent. Both accounts have sa access and datareader and datawriter enabled.

    It also seems that it's one...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 4:38 am

    #1752152

  • RE: Help Newbie here, new to sql

    Hi Imran,

    welcome to the forum.

    Try joining to the General Ledger Table with a LEFT join. That's only a guess mind you. If you go to the link on...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 4:14 am

    #1752146

  • RE: Today's Random Word!

    Ed Wagner (10/13/2014)

    djj (10/13/2014)

    Ed Wagner (10/13/2014)

    SQLRNNR (10/13/2014)

    djj (10/13/2014)

    SQLRNNR (10/13/2014)

    Danish

    Pastry

    creme

    Brulee

    Fire

    Torch

    Singer

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 14, 2014 at 1:17 am

    #1752126

  • RE: Removing Non-Alphabetical Characters

    It should just be O'Gara, there's quite a few names with Name #D in the list as it turns out.

    The good news is it appears it's not a...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 10, 2014 at 1:03 pm

    #1751720

  • RE: Fun Data Analysis

    Eric M Russell (10/10/2014)

    Speaking of research studies with questionable cause and effect, I see this type of thing all the time on the morning news shows. Below is a good...

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

    October 10, 2014 at 8:00 am

    #1751646

Viewing 15 posts - 856 through 870 (of 1,251 total)