Forum Replies Created

Viewing 15 posts - 8,221 through 8,235 (of 15,381 total)

  • RE: how to get the text of isnull function in sql server

    Durai Samuel (5/28/2013)

    In Sql server to see the function text, we can use sp_helptext. can you please help me to view the text of the isnull (system defined function).

    Pretty sure...

    May 28, 2013 at 7:24 am

    #1618944

  • RE: calculate average time results

    jsteinbeck-618119 (5/24/2013)

    Yes.... I assume you used my code as well? Difference is I have 800 records and you have 20... this is my max value 23:59:47.8000000

    Thanks

    I added that...

    May 24, 2013 at 1:34 pm

    #1618433

  • RE: calculate average time results

    jsteinbeck-618119 (5/24/2013)

    Thank you guys...

    Geoff,

    I'm getting the error "Arithmetic overflow error converting expression to data type int."

    Is it because the column is a Data Type of Time?

    Do you get the same...

    May 24, 2013 at 1:18 pm

    #1618424

  • RE: please help; i have to find the server rebuilt information

    hydbadrose (5/24/2013)

    The rebuild date. I have to provide the incident report so i need the rebuilt date.

    Ahh meaning you already rebuilt it and you need to know when. That makes...

    May 24, 2013 at 1:12 pm

    #1618422

  • RE: Looping and variables

    davidca65 (5/24/2013)

    SSCrazy Eights - excellent results - all I need is the fields names in the output - as I mentioned I "kind of" new and I can see that...

    May 24, 2013 at 1:09 pm

    #1618421

  • RE: Selecting Multiple Substrings from a Field

    This looks vaguely like XML? Is the actual data real xml or this type of partial non-parsable xml-ish stuff?

    If it is actual XML you can use XQuery.

    May 24, 2013 at 1:03 pm

    #1618418

  • RE: calculate average time results

    Geoff posted while I was writing. I like his approach better than mine, unless you need them separated. 😛

    May 24, 2013 at 12:57 pm

    #1618414

  • RE: calculate average time results

    jsteinbeck-618119 (5/24/2013)

    Hi,

    Any reply is a good reply... lol

    What data type, I keep getting errors on converting to int... not sure which double precision to use to be able to convert...

    May 24, 2013 at 12:56 pm

    #1618413

  • RE: please help; i have to find the server rebuilt information

    hydbadrose (5/24/2013)

    Can some one help me to find the server rebuild information... I am trying to find when the server has been rebuilt. We had some disaster and needed to...

    May 24, 2013 at 12:44 pm

    #1618408

  • RE: Looping and variables

    You have a few things going on here. First of all you are using a deprecated system catalog.

    Laurie is correct that you will need use dynamic sql for this,...

    May 24, 2013 at 12:42 pm

    #1618407

  • RE: Hierarchical Child Records with Multiple Parents

    Ahh in my last post I had accidentally created a cross join which wasn't noticeable until you added some missing/duplicates.

    select

    FoodGroups.FoodGroupID,

    FoodGroups.FoodGroupName,

    FoodGroups.FoodGroupDesc,

    Foods.FoodNameID,

    Foods.FoodName,

    Foods.FoodShortName

    from

    Foods inner join

    FoodGroups...

    May 24, 2013 at 10:24 am

    #1618373

  • RE: Hierarchical Child Records with Multiple Parents

    nfs_john (5/24/2013)

    So for the foreseeable future we will only need two level. Parent Child so the tree would look like this:

    FoodGroupA

    ----Food A

    ----Food B

    FoodGroupB

    ----Food G

    ----Food K

    FoodGroupC

    ----Food A

    ----Food K

    Notice A & K...

    May 24, 2013 at 9:37 am

    #1618353

  • RE: Hierarchical Child Records with Multiple Parents

    nfs_john (5/24/2013)

    1st what did I fail to provide in terms of "consumable data" that Geoff put together. The actual query? The reason I ask is as the OP I should...

    May 24, 2013 at 9:35 am

    #1618352

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/24/2013)

    Sean Lange (5/21/2013)

    Evil Kraig F (5/21/2013)

    On a side note, my gaming rig still runs Vista (yes, it's that old). It's about to be upgraded in the next month...

    May 24, 2013 at 9:02 am

    #1618333

  • RE: Hierarchical Child Records with Multiple Parents

    Or even less coding...

    select

    FoodGroups.FoodGroupID,

    FoodGroups.FoodGroupName,

    FoodGroups.FoodGroupDesc,

    Foods.FoodNameID,

    Foods.FoodName,

    Foods.FoodShortName

    from

    Foods inner join

    FoodGroups on Foods.FoodGroupID in (Foods.FoodGroupID, foods.FoodGroupID2, Foods.FoodGroupID3)

    May 24, 2013 at 8:59 am

    #1618328

Viewing 15 posts - 8,221 through 8,235 (of 15,381 total)