Forum Replies Created

Viewing 15 posts - 2,836 through 2,850 (of 4,086 total)

  • RE: How to get metadata info on table? please

    asita (1/13/2016)

    I am using sql server 2008R2

    For future reference, there is a forum specifically for SQL2008. You would be better off posting in that forum, because you are less...

    January 13, 2016 at 10:23 am

    #1851660

  • RE: How to identify duplicate data with out Primary Key

    Even though your data doesn't have a primary key, it should have one or more natural keys. You need to identify what those natural key might be and use...

    January 13, 2016 at 10:20 am

    #1851658

  • RE: combine a datetime coulmn and varchar into new Datetime

    sqlfriends (1/12/2016)

    That is a good reminder.

    Unfortunately the original data does not have a pm, am.

    There are three possibilities:

    1) The data is set up with 24-hour times and you're all set.

    2)...

    January 12, 2016 at 3:11 pm

    #1851437

  • RE: combine a datetime coulmn and varchar into new Datetime

    Please note that since you don't include AM or PM, the hearing time will be interpreted on a 24-hour clock, so your 0330 will be 3:30 AM.

    Drew

    January 12, 2016 at 1:04 pm

    #1851404

  • RE: how count work at backend Level.

    John Mitchell-245523 (1/11/2016)

    That any integer is just a placeholder. As you've already noticed, you'll get the same result whatever argument you put in there. What you do have...

    January 11, 2016 at 11:23 am

    #1851067

  • RE: Table Creation - Tool

    You can create the tables directly from Visio. It's been awhile, and I don't have a copy of Visio to walk you through how to do it.

    Drew

    January 8, 2016 at 7:40 am

    #1850534

  • RE: Help need in using condition on join statement

    Hint: LIKE without wildcards in the second expression is equivalent to =

    Given that, think of it like the distributive property. You have an element in common in both inner...

    January 7, 2016 at 12:11 pm

    #1850308

  • RE: Join to pull mismatch data in tables

    You just need to slightly modify the query Lowell provided.

    SELECT * FROM #CoverageTable

    WHERE CoverageID IN ( SELECT CoverageID FROM #RateTable )

    EXCEPT

    SELECT * FROM #RateTable

    Drew

    January 6, 2016 at 1:45 pm

    #1850025

  • RE: Selecting a decimal

    Hugo Kornelis (1/6/2016)

    sql_only (1/6/2016)

    why does

    DECLARE @phi DECIMAL = (SQRT(5)+1)/2

    SELECT @phi;

    return 2

    and not 1.618

    Integer math.

    Actually, no. The SQRT function returns a decimal even though the input is an integer. ...

    January 6, 2016 at 11:07 am

    #1849961

  • RE: Loop through an IN() clause?

    Please post sample data and expected results as specified in Forum Etiquette: How to post data/code on a forum to get the best help[/url]

    Drew

    January 5, 2016 at 1:26 pm

    #1849658

  • RE: query for datetime

    Jeff Moden (1/1/2016)

    Ostensibly, the StartDT and EndDT would be represented using the same DATETIMEOFFSET, which also does NOT change the fact that there are 24 hours in a day. ...

    January 4, 2016 at 7:56 am

    #1849230

  • RE: query for datetime

    Jeff Moden (12/30/2015)

    Here's the code I wrote last night with the validation checks that I added today. Details are in the comments in the code.

    GREAT! But suppose your company...

    December 31, 2015 at 7:46 am

    #1848933

  • RE: query for datetime

    Jeff Moden (12/30/2015)

    Generating data to the ms across a large range of dates is very important to testing.

    I would say that depends on what you're testing and the...

    December 30, 2015 at 3:11 pm

    #1848859

  • RE: query for datetime

    Jeff Moden (12/29/2015)

    And, no... I'm not being snarky here. I'd really like to see how others would do this using only the methods you speak of. I'll post...

    December 30, 2015 at 9:08 am

    #1848772

  • RE: query for datetime

    Jeff Moden (12/29/2015)

    drew.allen (12/29/2015)

    None of the newer date/time data types support decimal math.

    I consider that to be a major failure on the part of Microsoft. I'll never understand why...

    December 29, 2015 at 2:47 pm

    #1848638

Viewing 15 posts - 2,836 through 2,850 (of 4,086 total)