Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 2,894 total)

  • RE: How to write a query to pick up only duplicated records like this?

    Dear halifaxdal, I cannot believe, that with visiting SQLServerCentral over 1000 times and accumulating almost 600 points you have never seen the aricle about posting questions... There is a link...

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

    #1456582

  • RE: Using dynamic values

    Do you want to send email only if Customer FirstName is changed?

    What about Lastname?

    What about other details?

    If yes to any of the above two, what you email when few details...

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

    #1456570

  • RE: SQL SERVER question on comparing digits in different table?

    Try to post your question as per following: http://www.sqlservercentral.com/articles/Best+Practices/61537/

    and it will attract much more attention...

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

    #1456550

  • RE: Using dynamic values

    OTF (3/8/2012)

    Eugene Elutin (3/7/2012)

    It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to call xp_sendmail...

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

    #1456526

  • RE: To detect dead lock exists?

    Looks like OP managed to see my withdrawn solution, I wasn't quick enough to hit a button... :hehe:

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

    #1456522

  • RE: Creating all possible combinations of two numbers of two columns without recursion or repeatation.

    GilaMonster (3/8/2012)

    Why is cross join not allowed?

    For the comma-delimited list, look in the scripts library here for a string split function. I'd then cross apply the function to the...

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

    #1456520

  • RE: To detect dead lock exists?

    Solution withdrawn as per Gail's note:

    Give it a try (Books Online has some good resources on recursive CTEs), if you get stuck post your code and we'll help further. Since...

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

    #1456511

  • RE: SQL server Architecture

    tejdeep5107 (3/7/2012)

    Hi jayanth,

    I already read that topic in msdn. Actually i need diagrammatic representation of sql server architecture.

    I guess, you will need to draw it yourself. Found...

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

    #1456485

  • RE: Update and remove duplicates rows

    In order to achieve your requirement you will need to split the comma separated values.

    Please read the following and create this very useful udf as per article:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    There is no viable...

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

    #1456468

  • RE: NO SQL Server components should be installed on OS drive (C drive)

    Gianluca Sartori (3/8/2012)

    Yes, and it worked.

    I also tried many other horrible things with junctions, but that would be a whole different story. 😀

    It's nightmare for free...

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

    #1456439

  • RE: Remove duplicate rows

    Mark-101232 (3/8/2012)

    Here's another way

    WITH CTE AS (

    SELECT *,

    ROW_NUMBER() OVER(PARTITION BY i_Number ORDER BY pk_ResId) AS rn

    FROM #tbl_Duplicates)

    DELETE FROM CTE

    WHERE rn>1;

    And it's a better...

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

    #1456438

  • RE: Update and remove duplicates rows

    Sagar Sawant (3/8/2012)

    Hi,

    Thanks for the reply.

    So I will post again and here is:

    Table "tbl_Reservation" contains below rows.

    CREATE TABLE #tbl_Reservation

    (

    ...

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

    #1456432

  • RE: To detect dead lock exists?

    Cannot see where exactly you're expecting a dead-lock.

    May be if you follow: http://www.sqlservercentral.com/articles/Best+Practices/61537/

    we may be more helpfull...

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

    #1456428

  • RE: NO SQL Server components should be installed on OS drive (C drive)

    Gianluca Sartori (3/8/2012)

    You could move those files to a non-system drive and create a junction on the system drive.

    That way, the files would appear on both drives, but will physically...

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

    #1456426

  • RE: NO SQL Server components should be installed on OS drive (C drive)

    :

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

    #1456425

Viewing 15 posts - 1,966 through 1,980 (of 2,894 total)