Forum Replies Created

Viewing 15 posts - 1,621 through 1,635 (of 2,894 total)

  • RE: insert 100 rows without using loop or union etc.,

    I asked one candidate "what do you think are the 5 most important things to remember when working with SQL server?"

    Sorry, I hate such questions. They are generic and very...

    _____________________________________________
    "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 8, 2012 at 9:42 am

    #1484617

  • RE: Need help with SQL statement using COUNT function

    michael vessey (5/8/2012)

    mldardy (5/8/2012)

    Well I tried something a little different with the difference formula and I get a 'Divide by zero error encountered'. This is on the bolded line below

    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]

    May 8, 2012 at 9:32 am

    #1484602

  • RE: Query Performance issue.

    ggjjbb1983 (5/8/2012)

    Thanks.

    Can you tell me how Full Text Indexes are stored please? I know how clustered indexes are stored. How are Full Text Indexes stored in comparison?

    Thanks

    That will let...

    _____________________________________________
    "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 8, 2012 at 9:27 am

    #1484597

  • RE: insert 100 rows without using loop or union etc.,

    Jeff Moden (5/8/2012)

    michael vessey (5/8/2012)

    i see my humour is lost on you jeff

    Nah... I had a smiley face there. 🙂 I just didn't want a newbie reading that to...

    _____________________________________________
    "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 8, 2012 at 9:13 am

    #1484590

  • RE: Dynamic Joins

    lanky_doodle (5/8/2012)

    Any thoughts guys?

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    Not everyone here have a desire to setup everything from scratch. If you could follow tips from the above link, you will get more relevant help 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 8, 2012 at 9:06 am

    #1484585

  • RE: Need help with SQL statement using COUNT function

    mldardy (5/8/2012)

    I am using a Select statement where I get the difference between two columns (ForecastQtyContainers and LastYearQtyActualContainers). I'm able to get that fine but I want take the Difference...

    _____________________________________________
    "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 8, 2012 at 8:59 am

    #1484577

  • RE: How to use table column values as such for calculations?

    It's possible with use of dynamic SQL

    BUT! It's a crazy desire!

    p.s. you can draw using T-SQL too...

    _____________________________________________
    "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 8, 2012 at 8:05 am

    #1484525

  • RE: case statement

    The best what you can do is:

    ;with r1 as (select ROW_NUMBER() over (order by field2) rn, field2

    ...

    _____________________________________________
    "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 8, 2012 at 7:53 am

    #1484519

  • RE: case statement

    michaelyarbrough1975 (5/8/2012)

    When I run the query in sql server management studio I need it to return 3 columns (type1, type2, type3) with 3 records each.

    column type1 has the following...

    _____________________________________________
    "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 8, 2012 at 7:37 am

    #1484511

  • RE: how to separate value columns my matching two flag

    imex (5/4/2012)

    Hi,

    Try:

    select

    s.FLAG1 as INBOUND,

    s.AMOUNT as BASE_AMOUNT,

    Coalesce( (select i.AMOUNT from @Sample as i

    ...

    _____________________________________________
    "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 4, 2012 at 6:20 am

    #1483487

  • RE: Issue with duplicate data

    Good Luck!

    _____________________________________________
    "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 4, 2012 at 5:55 am

    #1483478

  • RE: how to separate value columns my matching two flag

    yingchai (5/4/2012)

    Hi Eugene,

    There is really no rule to make 'aaa' to be only "inbound" but 'bbb' and 'ccc' only "outbound.

    If there is an amount for 'aaa' to 'bbb' (FLAG1 to...

    _____________________________________________
    "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 4, 2012 at 5:52 am

    #1483474

  • RE: Write all the records of a table to a text file on the local disk with in T-SQL (SP)

    BCP: still needs tursted connection, we have many 100s of customer with different authendication, the solution has to work in all situations.

    And, you will want that file be created on...

    _____________________________________________
    "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 4, 2012 at 3:49 am

    #1483443

  • RE: how to separate value columns my matching two flag

    What makes 'aaa' to be only "inbound" but 'bbb' and 'ccc' only "outbound"?

    You should have some kind of flag/rule.

    _____________________________________________
    "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 4, 2012 at 3:32 am

    #1483437

  • RE: insert 100 rows without using loop or union etc.,

    Jeff Moden (5/3/2012)

    michael vessey (5/2/2012)

    does the following count as a loop?

    INSERT INTO dbo.yourTable default values

    go 100

    ??:-P??

    BWAAAA-HAAAA!!!!! Ask that question on the receiving end of an interview and see what...

    _____________________________________________
    "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 4, 2012 at 3:27 am

    #1483435

Viewing 15 posts - 1,621 through 1,635 (of 2,894 total)