Forum Replies Created

Viewing 15 posts - 676 through 690 (of 2,894 total)

  • RE: A complicated situation

    RZ52 (2/28/2013)

    Dear Eugene,

    You've completed my day.

    Thanks a lot.

    You are welcome!

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

    February 28, 2013 at 10:03 am

    #1592076

  • RE: find whether a upper case letter is there in a given string

    po 35213 (2/27/2013)

    A simple regular expression can do the job fine. I had to delete all records from my words table which begun with a capital letter. Here...

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

    February 28, 2013 at 9:45 am

    #1592060

  • RE: Compare the rowcount

    Welcome to the forum!

    ...

    Can someone help on this immediately.

    If you really want to receive help immediately (or at least close to this) here, I would suggest you to follow forum...

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

    February 28, 2013 at 9:36 am

    #1592049

  • RE: A complicated situation

    RZ52 (2/28/2013)

    Dear SQLKnitter,

    I appreciate for advice. The reason I stay with SELECT is because I use it as SP to fill a datagridview in my application.

    Thanks again

    Yeap, it's another good...

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

    February 28, 2013 at 9:31 am

    #1592041

  • RE: A complicated situation

    SQLKnitter (2/28/2013)

    Others have responded with good solutions. I have used both with good results, but want to point out that Crystal Reports can do this tidily. It has more built...

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

    February 28, 2013 at 9:21 am

    #1592032

  • RE: A complicated situation

    I guess you will need something more like that:

    SELECT AntiBiotic

    ,COUNT(CASE City WHEN 'Boston' THEN 1 ELSE NULL END) ...

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

    February 28, 2013 at 8:57 am

    #1592014

  • RE: Execute Stored Procedure Multiple Times

    I guess, if the rewriting your stored proc to work on a required set is not an option, use advise about converting proc into TVF and use it with CROSS...

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

    February 28, 2013 at 8:33 am

    #1592002

  • RE: Is a doomed transaction inevitable if deadlock occurs in a trigger (SQL Server 2008 R2)?

    davidsatz (2/28/2013)

    So I am not hearing anyone disagree with my conclusion that there is no way to accomplish this...:ermm:

    I'm not exactly sure what you are looking to do, it would...

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

    February 28, 2013 at 8:08 am

    #1591991

  • RE: converting Varchar details into nvarchar of my table

    To convert varchar to nvarchar you can use CAST or CONVERT function.

    However you don't need to convert values inserted into nvarchar column, as they already will be converted on insert.

    If...

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

    February 28, 2013 at 7:29 am

    #1591978

  • RE: Is SQL Server 2 tier architecture or 3 tier architecture

    I would call it just 1 tier application which consists of multiple tiers. 😎

    This question about SQL Server is a bit irrelevant.

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

    February 26, 2013 at 1:59 am

    #1591059

  • RE: Hierarchy example - Ken Henderson's book - not working

    polkadot (2/25/2013)

    SQL_Enthusiast,

    I double and triple checked the book and the WHILE query in my original post is a facsimile.

    The where clause condition is slightly different, it excludes o1.supervisor<>o1.employee. ...

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

    February 25, 2013 at 10:47 am

    #1590885

  • RE: Using the While loop to create temp tables based on a list table

    Debbie Edwards (2/25/2013)

    Eugene Elutin (2/25/2013)

    Jeff Moden (2/25/2013)

    I guess I just don't understand why you need separate tables for each code to begin with.

    That is exactly the thing which makes me...

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

    February 25, 2013 at 6:28 am

    #1590784

  • RE: Using the While loop to create temp tables based on a list table

    Jeff Moden (2/25/2013)

    I guess I just don't understand why you need separate tables for each code to begin with.

    That is exactly the thing which makes me suspicious that the OP...

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

    February 25, 2013 at 6:01 am

    #1590779

  • RE: Using the While loop to create temp tables based on a list table

    There are few things here.

    1. Your code example has a small visible bug:

    You cannot insert 'TOTAL_Exclamation_Mark' value into your #SSC table as it's longer than maximum allowed by 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]

    February 25, 2013 at 5:45 am

    #1590771

  • RE: Using the While loop to create temp tables based on a list table

    Abu Dina (2/25/2013)

    Okay fair enough then just make the tempt table into a global temp table and problem is sorted.

    No, this will not be exactly enough to make it robust...

    If...

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

    February 25, 2013 at 5:34 am

    #1590769

Viewing 15 posts - 676 through 690 (of 2,894 total)