Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 2,894 total)

  • RE: EXEC sp t.C1 FROM Table t

    jp.v (3/23/2012)

    Eugene Elutin (3/23/2012)

    Instead of saying that it's doing something simple, it would be simpler to post stored proc code...

    I wonder what reasons forced you to use this SP?

    Direct...

    _____________________________________________
    "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]

    March 23, 2012 at 10:34 am

    #1463572

  • RE: how to use like operator for this store proc or any other method?

    SELECT TOP 10 ...

    There is an article about it, link at the bottom of my signature.

    _____________________________________________
    "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]

    March 23, 2012 at 10:27 am

    #1463562

  • RE: How to convert this XML into columns

    njdevils39 (3/23/2012)

    This is the easy sample data query:

    select em.emp_name, em.emp_organization, em.emp_department, eo.rate_history

    from

    employee as em

    join

    employee_other as eo

    on

    em.emp_id = eo.emp_id

    Now rate_history column is in XML FORMAT in the employee_other table for...

    _____________________________________________
    "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]

    March 23, 2012 at 10:25 am

    #1463560

  • RE: EXEC sp t.C1 FROM Table t

    jp.v (3/23/2012)

    The SP does something very simple :

    - Delete existing in a ref table.

    - Insert New in that same ref table.

    It's easy to do in two requests, but i'm forced...

    _____________________________________________
    "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]

    March 23, 2012 at 10:04 am

    #1463535

  • RE: Remove GUID within a String Field

    You don't need MDS to create and compile c# code...

    http://blogs.oberon.ch/tamberg/2007-10-17/compiling-csharp-without-visual-studio.html

    _____________________________________________
    "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]

    March 23, 2012 at 9:53 am

    #1463517

  • RE: How to convert this XML into columns

    SAMPLE DATA, should include data!

    We don't have the data in the table your are selecting from (actually we don't have any of your tables :-D)

    Please follow the link at...

    _____________________________________________
    "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]

    March 23, 2012 at 9:50 am

    #1463509

  • RE: Add varchar columns with colon in between to show time

    pwalter83 (3/23/2012)

    Hi,

    I have a requirement to add columns (varchar) where data is separated with a colon (:). For e.g.

    115:32 and 34:28

    160:00 (hrs and minutes).

    Thanks,

    Paul

    I would suggest to store your...

    _____________________________________________
    "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]

    March 23, 2012 at 9:47 am

    #1463507

  • RE: Strange Proc Behavior with a Web App

    One of the culprits to check that happens alot is the connection's setting of ARITHABORT. SSMS defaults to ARITHABORT ON, but .Net connections default to ARITHABORT OFF.

    ... meaning that...

    _____________________________________________
    "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]

    March 23, 2012 at 9:36 am

    #1463494

  • RE: Variable not getting reset inside the loop

    ...

    Object oriented COBOL is a perfect example of what we talking about. Yes it can be done, but that does not mean it is a good idea...

    It is not as...

    _____________________________________________
    "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]

    March 23, 2012 at 9:32 am

    #1463492

  • RE: Variable not getting reset inside the loop

    ...

    It is a paradigm shift that is difficult for some to make, sort of like moving from 3rd generation programming languages like COBOL to object-oriented languages.

    Is it really such difficult?...

    _____________________________________________
    "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]

    March 23, 2012 at 9:07 am

    #1463460

  • RE: EXEC sp t.C1 FROM Table t

    It may be possible to re-design your stored proc in such way that it can be executed for the whole table (or required dataset)...

    If not, cursors in T-SQL are mainly...

    _____________________________________________
    "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]

    March 23, 2012 at 9:04 am

    #1463458

  • RE: Strange Proc Behavior with a Web App

    When you state 30sec in UI vs 1sec in SSMS, are you talking about complete resultset returned and displayed in both cases or, in case of SSMS you can see...

    _____________________________________________
    "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]

    March 23, 2012 at 8:45 am

    #1463439

  • RE: Variable not getting reset inside the loop

    ... make sure you declare your variables outside the loop.

    yeah, it is widely used practice by T-SQL programmers.

    However, from performance prospective, it never was any difference as the query optimizer...

    _____________________________________________
    "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]

    March 23, 2012 at 8:18 am

    #1463421

  • RE: Strange Proc Behavior with a Web App

    Network?

    Bad code?

    Could be anything...

    Have you tried DBCC FREEPROCCACHE ?

    _____________________________________________
    "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]

    March 23, 2012 at 7:57 am

    #1463406

  • RE: Variable not getting reset inside the loop

    Sean Lange (3/23/2012)

    Please! "Even better, don't use loops."? Why? :w00t:

    I do not agree!

    If you say that, you should say it right!

    OK, don't use loops in general. They tend 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]

    March 23, 2012 at 7:43 am

    #1463392

Viewing 15 posts - 1,801 through 1,815 (of 2,894 total)