Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 2,894 total)

  • RE: Join Issue

    Could you please specify all conditions you have

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

    #1494040

  • RE: Trigger behaves differently when invoked from an Access form

    Your trigger is written in such way that it can only work for update/insert of a single record at the time. It's a classical example of how "never write 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]

    May 29, 2012 at 3:11 am

    #1494035

  • RE: Proc Optimization

    It does actually look like parameter sniffing...

    But, if it's not blocked or other, try to add Option (MAXDOP 1)

    Are you running on SQL2008?

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

    #1494031

  • RE: Join Issue

    I thought there is a concept of "short-circuiting" in sql server. Try the following.

    SELECT 1 WHERE (1 = 1) OR (1 / 0 = 0)

    even if there is a division...

    _____________________________________________
    "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 29, 2012 at 2:58 am

    #1494028

  • RE: Join Issue

    pravasis (5/28/2012)

    Dung Dinh (5/28/2012)

    I'm sure that with the sample data and your query. The result is always 2 records

    idname1name2desc

    1test1 test2 ...

    _____________________________________________
    "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 28, 2012 at 2:36 pm

    #1493911

  • RE: Join Issue

    That is exactly what I've described (even a bit more).

    It returns two rows as single record in Test_Join_Source2 matches two different records in Test_Join_Destination2:

    it matches the first one 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 28, 2012 at 10:21 am

    #1493877

  • RE: Join Issue

    OP has two records as it matches to two different records in table she JOINs to, one record matches on ONE column and another record matches on SECOND column.

    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]

    May 28, 2012 at 9:48 am

    #1493865

  • RE: Trigger behaves differently when invoked from an Access form

    Could you please post the complete trigger code.

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

    #1493862

  • RE: Store Insert, Update, Delete statements in a AUDIT table as any DML operations performed on a table

    I've done it before in a place when standard SQL replication wasn't allowed for stupid reason.

    You will need to create custom triggers to capture change and build appropriate DML. 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]

    May 28, 2012 at 9:29 am

    #1493858

  • RE: General Qestions

    Schadenfreude-Mei (5/28/2012)

    pdanes (5/28/2012)

    Eugene Elutin (5/24/2012)

    P.S. There is an universal solution to stop queries running forever:

    Ask electrician to connect your server room power supply via your floor light switch, so...

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

    #1493848

  • RE: General Qestions

    Ian Scarlett (5/28/2012)

    Hmmm... I wonder if the OP will start going for interviews as a plasterer with all this knowledge being imparted. 😛

    I can say (reading detailed DIY advices 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]

    May 28, 2012 at 7:03 am

    #1493781

  • RE: stored procedure for dividing a single table into a multiple table.

    Duplicate Post!

    http://www.sqlservercentral.com/Forums/Topic1307219-391-1.aspx

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

    #1493734

  • RE: A table into a multiple table made in a stored procedure

    If guidsource in dbo.LR_TABLE_TEST is unique, ou can try this way:

    SELECT * INTO dbo.LR_TABLE_TEST_1

    FROM (SELECT ROW_NUMBER() OVER (ORDER BY guidsource) AS RN, * FROM dbo.LR_TABLE_TEST) q

    WHERE RN...

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

    #1493732

  • RE: General Qestions

    anthony.green (5/28/2012)

    external seal wont be an option as its on a joining wall with next door so, can only treat it from the inside, but yeah it is good stuff,...

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

    #1493726

  • RE: General Qestions

    I guess this thread should be placed into dedicated forum. Can be called "All SQL in 15 minutes"

    or "What I'm going to do on this weekend"

    Any other ideas?

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

    #1493041

Viewing 15 posts - 1,471 through 1,485 (of 2,894 total)