Forum Replies Created

Viewing 15 posts - 1,726 through 1,740 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/23/2011)

    GilaMonster (5/23/2011)

    Jack Corbett (5/23/2011)

    Just because I've touched it doesn't mean I'm an expert.

    It doesn't? Really?

    😉

    Wish more people thought that way.

    No experts are those who have heard of...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 23, 2011 at 10:04 am

    #1328547

  • RE: Are the posted questions getting worse?

    Jack Corbett (5/23/2011)

    GilaMonster (5/23/2011)

    Now this is funny...

    http://blog.jitbit.com/2011/05/what-if-drivers-were-hired-like.html

    As someone who is interviewing, this couldn't be more accurate. If it involves electricity you are supposed to have experience with it.

    I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 23, 2011 at 7:56 am

    #1328459

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (5/19/2011)

    Any chance someone can go a better job than me in explaining this is a bad idea: http://www.sqlservercentral.com/Forums/Topic1111536-392-1.aspx?Update=1

    It looked good to me, I just suggested...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 19, 2011 at 1:40 pm

    #1327329

  • RE: Access extent and page information of an object

    abygaikwad17 (5/19/2011)

    2. Actually, I am running and retrieving data from a SQL server present on Windows m/c to a linux machine (runs JDBC program). So cannot use BULK_INSERT as data...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 19, 2011 at 12:49 pm

    #1327304

  • RE: Insert into Multivalue Table

    Ryan Tiebout (5/18/2011)

    we have a table structure similar to the following:

    Key - Pos - Data1 - Data2 - Email

    1 - 1 - Room2 - Null - jdoe@hotmail.com

    1 - 2 -...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 18, 2011 at 12:49 pm

    #1326714

  • RE: Select Only IDs that match all entries in another table

    Lynn Pettis (5/18/2011)

    I did the following using Oracle (yes, that's what I am working with right now) but you should be able to adapt the query for use in SQL...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 18, 2011 at 10:09 am

    #1326607

  • RE: Select Only IDs that match all entries in another table

    GSquared (5/18/2011)

    Lynn Pettis (5/18/2011)

    I know I'm late to the party, but I was reading the question and I'm partially lost, in that I'm not sure what your expected results are...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 18, 2011 at 7:51 am

    #1326462

  • RE: Select Only IDs that match all entries in another table

    Greg Edwards-268690 (5/18/2011)

    Seems more like a data mining model than a query.

    Why is it that they want to see this?

    Just a thought....

    Partly data mining, partly helping to hunt down problems.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 18, 2011 at 7:49 am

    #1326460

  • RE: Select Only IDs that match all entries in another table

    ColdCoffee (5/18/2011)

    Lynn Pettis (5/18/2011)

    I know I'm late to the party, but I was reading the question and I'm partially lost, in that I'm not sure what your expected results are...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 18, 2011 at 7:49 am

    #1326457

  • RE: Select Only IDs that match all entries in another table

    Lynn Pettis (5/18/2011)

    I know I'm late to the party, but I was reading the question and I'm partially lost, in that I'm not sure what your expected results are based...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 18, 2011 at 7:48 am

    #1326456

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/17/2011)

    Stefan Krzywicki (5/17/2011)

    jcrawf02 (5/17/2011)

    Data Analyst job will be opening up soon where I work (not mine) in Columbus, OH. Mostly report writing, some dev work in SSRS/SSIS, rest is...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 17, 2011 at 2:39 pm

    #1326138

  • RE: Are the posted questions getting worse?

    jcrawf02 (5/17/2011)

    Data Analyst job will be opening up soon where I work (not mine) in Columbus, OH. Mostly report writing, some dev work in SSRS/SSIS, rest is trending patient utilization...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 17, 2011 at 1:01 pm

    #1326078

  • RE: Select rows from table that don exist in another with where clause

    Jason-299789 (5/17/2011)

    Stefan, I dont think CELKO was having a go at you more the Original Poster.

    I know that, he's still wrong and rude in the process.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 17, 2011 at 11:31 am

    #1326005

  • RE: Select Only IDs that match all entries in another table

    Chad Crawford (5/17/2011)

    Drat, I'm too slow. Here's the one I came up with though. Pretty much the same, except I assumed you would be passing the list...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 17, 2011 at 11:26 am

    #1326002

  • RE: Select Only IDs that match all entries in another table

    Chad Crawford (5/17/2011)

    Drat, I'm too slow. Here's the one I came up with though. Pretty much the same, except I assumed you would be passing the list...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    May 17, 2011 at 11:25 am

    #1325999

Viewing 15 posts - 1,726 through 1,740 (of 2,838 total)