Forum Replies Created

Viewing 15 posts - 286 through 300 (of 1,228 total)

  • RE: SQL Help needed...

    Here's a solution with only one table scan.

    Declare @WorkItemId int = 10110

    SELECT

    WorkItemId,

    RelatedWorkItem = LEFT(z.RelatedWorkItem,LEN(z.RelatedWorkItem)-1)

    FROM @tblRawData

    CROSS APPLY (SELECT RWIStart = CHARINDEX('; Related Work',WorkItemDescription)) x

    CROSS APPLY (SELECT PWIlist =...

    [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 8, 2014 at 1:06 pm

    #1678562

  • RE: SubProcedure (Subroutines) within Stored Procedure

    skb 44459 (1/7/2014)

    Its not a SQL Program , it is a Progress Program.

    ...

    What make of car do you drive?

    [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 7, 2014 at 11:54 am

    #1678193

  • RE: Update the Time of Day, but not the Date

    AndrewSQLDBA (1/7/2014)

    Hello Everyone

    I hope that all is well.

    I am working with some dates that are in the datetime data format. What I would like to do is set the current...

    [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 7, 2014 at 11:50 am

    #1678191

  • RE: Complex Query. Please help

    Please post ddl and insert scripts for your sample data.

    What have you tried so far?

    [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 6, 2014 at 10:10 am

    #1677816

  • RE: Get Previous month data based on condition

    Which rows would you return from your sample data for today?I suspect your issue isn't the coding, but the business logic.

    [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 3, 2014 at 10:36 am

    #1677380

  • RE: Unable to convert character to datetime

    Rando (1/2/2014)

    ChrisM@home (1/2/2014)

    Rando (1/2/2014)

    ...Even if I manage to display it correctly...

    Using what?

    I'm getting the data from Microsoft Performance Monitor. The date field is not a date field

    If I sort 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]

    January 2, 2014 at 11:53 am

    #1677020

  • RE: Unable to convert character to datetime

    Rando (1/2/2014)

    ...Even if I manage to display it correctly...

    Using what?

    [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 2, 2014 at 11:36 am

    #1677012

  • RE: How to use the subquery column highglighted in the GROUP BY

    -- a little reformatting shows that the same query is referenced THREE TIMES

    CTE (comments, matter_uno) AS

    (SELECT case when isnull((

    SELECT top 1 i.comments

    FROM BO_LIVE3.dbo.HBA_SOURCE_BUS i

    INNER JOIN...

    [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 2, 2014 at 11:33 am

    #1677011

  • RE: Return random records in a table-valued function?

    Different route, similar results.

    First some sample data:

    SELECT TOP (50000)

    ID = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),

    [Version] = 'CTCAE v4.03 (MedDRAv12.0)',

    Grade = 1+ABS(CHECKSUM(NEWID()))%5

    INTO Data

    FROM SYSCOLUMNS a, SYSCOLUMNS b

    Second,...

    [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 1, 2014 at 5:27 am

    #1676717

  • RE: Buying the Developer Edition to use at home?

    In the UK, contact Grey Matter. They'll sell you 4 developer licences for about 40 quid. You choose what you want those licences to be for, so you could have...

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

    December 22, 2013 at 1:10 pm

    #1675465

  • RE: SYNTAX Help please...

    IT2012 (12/19/2013)

    Thanks for the reassurance! I was beginning to get a little afraid there might be cyber-bloodshed! 🙂

    Honestly, I am learning what I can. My situation is I am...

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

    December 19, 2013 at 1:49 pm

    #1674985

  • RE: Help with the query !!!

    Use GROUP BY.

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

    December 17, 2013 at 11:09 am

    #1674187

  • RE: display order by houseno

    Each one of your five current threads

    select quarie between houseno ..........

    select house_no order

    select only up to first '-' only

    display order by like 1,2,3,4,5...............plz write quarie

    display order by houseno

    relate to...

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

    December 15, 2013 at 11:07 am

    #1673552

  • RE: display order by like 1,2,3,4,5...............plz write quarie

    Each one of your five current threads

    select quarie between houseno ..........

    select house_no order

    select only up to first '-' only

    display order by like 1,2,3,4,5...............plz write quarie

    display order by houseno

    relate to...

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

    December 15, 2013 at 11:07 am

    #1673551

  • RE: select only up to first '-' only

    Each one of your five current threads

    select quarie between houseno ..........

    select house_no order

    select only up to first '-' only

    display order by like 1,2,3,4,5...............plz write quarie

    display order by houseno

    relate to...

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

    December 15, 2013 at 11:07 am

    #1673550

Viewing 15 posts - 286 through 300 (of 1,228 total)