Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,228 total)

  • RE: Avg count of cases per day

    kwoznica (10/16/2012)

    ChrisM@home (10/15/2012)[hr

    Sure! Let's start with a function which has been tweaked a little more (less late at night);

    I think you've probably figured out the rest.

    Thanks Chris. That was very...

    [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]

    October 16, 2012 at 6:45 am

    #1549515

  • RE: Avg count of cases per day

    kwoznica (10/15/2012)

    ChrisM would you mind walking me through to understand some parts of the iTvf?

    Sure! Let's start with a function which has been tweaked a little more (less late at...

    [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]

    October 15, 2012 at 1:12 pm

    #1549286

  • RE: confusion in setting up superkey

    deba_20032004 (10/15/2012)

    Dear Sir,

    I am in great trouble, my problem is I have a vendor Table

    which consist of some fields. I explaining the structure below

    Table<Vendor>

    --------------

    fields name

    -----------

    PKID int

    VENDORID int

    VENDORNAME ...

    [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]

    October 15, 2012 at 10:23 am

    #1549197

  • RE: do this update even make sense

    -- try this

    select

    MIDIRB,

    IRBT.ID as IRBT_ID,

    IRBT.IRBRATING as IRBT_IRBRATING,

    ACRT.NEGWATCH as ACRT_NEGWATCH,

    Newcolumn = case when ACRT.NEGWATCH = 1 then x.IRBRATING ELSE IRBT.IRBRATING end,

    *

    FROM ACRT

    INNER JOIN IRBT

    ON IRBT.MOODYSRATE = ACRT.MOODYSRATE

    CROSS APPLY (

    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]

    October 15, 2012 at 10:17 am

    #1549193

  • RE: Char And int

    Jan Van der Eecken (10/15/2012)

    Nice one, Tom! But does the TRY_CONVERT() make the query non-sargeable? Guess it would?

    Good point, Jan. I remember recently Howard W posted evidence that CAST(Datetime AS...

    [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]

    October 15, 2012 at 10:05 am

    #1549187

  • RE: Run time of Cursor

    Abu Dina (10/15/2012)

    With 45 cursors in one sproc he will never know which ones are taking the longest unless he implements some logging.

    This is why I suggested he inserts a...

    [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]

    October 15, 2012 at 6:58 am

    #1549115

  • RE: Run time of Cursor

    selvakumar.sms (10/15/2012)

    hi all

    i have stored procedure with 45 cursor, so the stored procedure taking long time to finish. is it possible to get running time...

    [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]

    October 15, 2012 at 6:37 am

    #1549097

  • RE: Run time of Cursor

    selvakumar.sms (10/15/2012)

    hi all

    this is my small part if code, i dont know which cursor taking more time to consolidate the data.

    Thanks for posting this. The...

    [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]

    October 15, 2012 at 6:24 am

    #1549091

  • RE: Columns not in key look up, why?

    yasubmj (10/11/2012)

    Hey all,

    We came across a problem today, no solutions yet, here is the scene, we have a query which uses an index and makes a key look up as...

    [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]

    October 15, 2012 at 5:39 am

    #1549075

  • RE: Run time of Cursor

    selvakumar.sms (10/15/2012)

    hi all

    i have stored procedure with 45 cursor, so the stored procedure taking long time to finish. is it possible to get running time...

    [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]

    October 15, 2012 at 5:07 am

    #1549070

  • RE: Run time of Cursor

    sql-programmers (10/15/2012)

    Hi Dude,

    Instead of using CURSOR you can try WHILE loop like below example.

    If possible dont use CURSORs in the procedure.

    A well written forward-only readonly cursor will perform...

    [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]

    October 15, 2012 at 5:03 am

    #1549068

  • RE: do this update even make sense

    ronan.healy (10/15/2012)

    update acrt

    set dbo.ACRT.MIDIRB = dbo.IRBT.IRBRATING

    from acrt,IRBT

    where dbo.IRBT.id = dbo.IRBT.id +1

    and NEGWATCH = 1

    It won't update any rows because dbo.IRBT.id will never equal dbo.IRBT.id +1.

    Write it as a 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]

    October 15, 2012 at 4:55 am

    #1549066

  • RE: Select column name and values.

    ecom.bigbuy (10/15/2012)

    I have to display unstable column from database, that's why I need like that.

    Can you post sample dynamic SQL procedure?

    What is an "unstable column"?

    Dynamic SQL is covered in BOL...

    [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]

    October 15, 2012 at 3:04 am

    #1549029

  • RE: Should I use a nested subquery?

    thomasrichardson2000 (10/15/2012)

    Thanks Chris, I think I need to explain myself a little bit better,

    RepairSheetNr unitnr groupid brandId modelId version Type_Fleet close_date TotalModels TotalModelsInFleet

    5000076 51 EDMN PEUGEOT 207 S 1.4...

    [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]

    October 15, 2012 at 2:58 am

    #1549026

  • RE: Using CTE doughts

    luissantos (10/14/2012)

    I want to know if is correct to use WHERE clause on each CTE to filter the information ?

    Also, for persons with more experience, i would like to know...

    [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]

    October 15, 2012 at 1:32 am

    #1549004

Viewing 15 posts - 421 through 435 (of 1,228 total)