Forum Replies Created

Viewing 15 posts - 1,666 through 1,680 (of 2,894 total)

  • RE: Issue with duplicate data

    ....

    I suggested the same thing you mentioned to the person who created these tables. However, I got the reply that this was out of question and I have to proceed...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 5:45 am

    #1481692

  • RE: Issue with duplicate data

    You would greatly benefit if you could normalise your Staff table.

    I would suggest to get MonHours, TueHours etc. out of this table and place it into dedicated StaffWorkHours table which...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 5:26 am

    #1481684

  • RE: Issue with duplicate data

    I can see the problem. Please wait for few minutes.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 5:11 am

    #1481679

  • RE: Issue with duplicate data

    Paul, let start from making your query a bit more readable.

    1. You can use DATENAME function instead of converting month number to string.

    2. You don't need check if "datepart(mm,s.[Date]) IN...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 5:03 am

    #1481671

  • RE: Assign values based on user's choice

    Base on limited details posted...

    Contacts = CONVERT(VARCHAR(8), EventDate, 112)

    +

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 4:44 am

    #1481667

  • RE: Issue with duplicate data

    Would you be able to post DDL and data setup not as attachments? Many workplaces do prohibit downloading from web...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 4:31 am

    #1481662

  • RE: t-sql query

    Welcome to the best SQL Forum on earth!

    In order to help you we will need a bit more details from you.

    Table's DDL, some sample data (as insert script) and...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    May 1, 2012 at 4:29 am

    #1481661

  • RE: Interview question

    never heard more stupid question!

    at the end it depends on pc power.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 30, 2012 at 2:48 am

    #1481061

  • RE: sp with begin transaction?

    exec @test-2 = ActualizaStock

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 8:25 am

    #1480473

  • RE: sp with begin transaction?

    Use TRY ... CATCH

    If you want everything undone when the error happens do everything within one TRANSACTION

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 8:06 am

    #1480449

  • RE: Calculating time difference

    It's not, just this huge set of sum's and brackets on Friday did make me dizzy. Time for a pint!

    😀

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 7:52 am

    #1480428

  • RE: Calculating time difference

    ... was able to achieve this with code:

    convert(int,((sum(datepart(hour,Timenetin) * 3600) + sum(datepart(hour,cat2_hours) * 3600) + sum(datepart(minute,Timenetin) * 60) + sum(datepart(minute,cat2_hours) * 60) + sum(datepart(second,Timenetin) * 1) +...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 7:06 am

    #1480375

  • RE: Replacement for Cursors

    vinu512 (4/27/2012)

    Jeff Moden (4/27/2012)

    vinu512 (4/26/2012)

    But the requirement is that I do not need the Names as a "Set". I need them separately(one by one), so that I can use them...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 6:59 am

    #1480367

  • RE: return multiple columns based on single CASE evaluation

    jwmott (4/26/2012)

    Is their a slick way that I can check the condition of a field and return multiple discrete fields like a begin end block in a select statment

    select...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 2:45 am

    #1480240

  • RE: SQL to get all Days in the month in Group by even with Zero values

    Which one?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    April 27, 2012 at 2:38 am

    #1480239

Viewing 15 posts - 1,666 through 1,680 (of 2,894 total)