Forum Replies Created

Viewing 15 posts - 661 through 675 (of 1,228 total)

  • RE: Deadlock Issues

    atchristian (1/5/2012)

    That worked! Thanks everyone for the help! Things have been smooth the last 24 hours!

    Compatibility mode? Fantastic 😀

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 5, 2012 at 10:20 am

    #1429177

  • RE: Deadlock Issues

    Not sure. Perhaps a column list isn't required with a table source

    USING #TradeVolumes AS Source --(TradeID, AnalysisTypeID, VolumeTypeID, [Hour], [Value])

    other than that, the syntax looks ok.

    I'd recommend writing and testing...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 5, 2012 at 9:32 am

    #1429119

  • RE: Split Function - Comma and/or Space Delimited

    SQLKnowItAll (1/5/2012)

    Cadavre (1/5/2012)

    SQLKnowItAll (1/4/2012)

    Cadavre (1/4/2012)

    Jeff Moden wrote an excellent article on splitters here[/url].

    Thanks for that, but what I am really trying to get at in this post is not an...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 5, 2012 at 9:14 am

    #1429101

  • RE: query help with scheduled dates

    Have a look at the result set from the following query - you should be able to quickly figure out what to do next:

    DECLARE @Today DATE

    SET @Today = DATEADD(dd,1,GETDATE())

    SELECT @Today

    SELECT...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 5, 2012 at 7:39 am

    #1429019

  • RE: Problem during inserting row in a table ( sql server 2005)

    kumar.sachu08 (1/5/2012)

    I know i am fresher....and i am giving interview......i have only 1 years of experience.

    then what should i do....when any interviewer asking like such type of question ?

    Should i...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 5, 2012 at 2:45 am

    #1428850

  • RE: Can we implement Clustered Index on Unique key ?

    kumar.sachu08 (1/5/2012)

    ...How many nonclustered index we can implement on one column like "id" ...

    Why would you want more than one index on the same column?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 5, 2012 at 2:40 am

    #1428848

  • RE: Update with except conditon

    drew.allen (1/4/2012)

    Actually, why are you using a subquery in the first place. Doesn't the following give you what you want?

    UPDATE PLU_1

    SET DSPL_DESCR = replace ([DSPL_DESCR],'"','in')

    WHERE AND DSPL_DESCR LIKE '%"%'

    AND...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 1:30 pm

    #1428635

  • RE: Update with except conditon

    Probably something in the UPDATE part of your statement. How about posting the whole statement?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 11:52 am

    #1428566

  • RE: Split Function - Comma and/or Space Delimited

    Replace comma plus space with comma, then space with comma. Or something similar which works with your data (test it).

    Then use Jeff's splitter.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 11:22 am

    #1428553

  • RE: Update with except conditon

    where VND_ID NOT IN (select VND_ID from PLU_1

    Where len(DSPL_DESCR)=40

    AND DSPL_DESCR LIKE '%"%' )

    This is functionally equivalent to Phil's LEFT JOIN.

    You could also use NOT EXISTS as a correlated subquery.

    Your...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 11:15 am

    #1428549

  • RE: Performance large table

    Marco V (1/4/2012)

    Hello,

    I got a database with a table (meterdata) which has little of 70 million rows. Often new rows are added to be precise every 15 mins from between...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 8:39 am

    #1428379

  • RE: Doing inserts within a select statement?

    erikpoker (1/4/2012)

    Thanks for your replies.

    A merge is not gonna work for me. What i'm looking for is a way to use a function and insert something somewhere within the function.

    And...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 6:25 am

    #1428251

  • RE: select Query Issue

    DROP TABLE #Sample

    CREATE TABLE #Sample (ID INT, PID INT, Name VARCHAR(10))

    INSERT INTO #Sample (ID, PID, Name)

    SELECT 1, 0, 'Ad' UNION ALL

    SELECT 2, 0, 'Area' UNION ALL

    SELECT 3, 1, 'List' UNION...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 6:22 am

    #1428249

  • RE: Problem during inserting row in a table ( sql server 2005)

    Them's big rows. Can you post the CREATE TABLE script?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 5:58 am

    #1428239

  • RE: Deadlock Issues

    Have you tried using MERGE for the upsert, instead of your current two-stage process?

    Shredding XML isn't instant - you may gain by separating this from the table changes too:

    SELECT

    TradeID...

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

    January 4, 2012 at 5:32 am

    #1428215

Viewing 15 posts - 661 through 675 (of 1,228 total)