Forum Replies Created

Viewing 15 posts - 661 through 675 (of 859 total)

  • RE: What is the difference between SubQuery and Joins in terms of Performance

    in general. sub selects have to be executed first or for each row depending on the case and then joined to the outer query. a join is executed...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 10:18 pm

    #1469953

  • RE: Cursor help

    piotrka (4/5/2012)

    That is exactly what the 2 extra columns are; the registration date and the next earliest registration time to the new nurse station. The problem I am...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 10:11 pm

    #1469952

  • RE: Cursor help

    Jeff Moden (4/5/2012)

    Considering that you input data is only a half of what your output data is, your going to have to describe how the data describes "in" and "out"...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 6:15 pm

    #1469926

  • RE: BETWEEN ages

    I would take a slightly different approach

    --DECLARE @FromAge -- get this from your app

    --DECLARE @ToAge -- get this from your app to i like...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 5:51 pm

    #1469922

  • RE: Cursor help

    CREATE TABLE #Tbl_PATIENT_ADM (

    ADT_SOURCE VARCHAR(30),

    PATIENT_NUM VARCHAR(20),

    PATIENT_NURSESTATION VARCHAR(10),

    REGISTER_DTIME DATETIME

    )

    INSERT INTO #Tbl_PATIENT_ADM

    SELECT 'Register','54689','260', '12/30/11 9:37'

    UNION

    SELECT 'OutPatToInPat', '54689', '6S', '12/30/11 22:34'

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 5:34 pm

    #1469918

  • RE: Filter Extended Properties by Schema

    Lynn Pettis (4/5/2012)

    Lowell (4/5/2012)

    Welsh Corgi (4/5/2012)

    Lowell,

    Hey yeah your right, thanks.

    Whatever happened to your Dog Avatar? I liked it. What model is that Gas:-) Mask? I did not see that one...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 4:49 pm

    #1469907

  • RE: query for consecutive alphabets

    Jeff Moden (4/5/2012)

    sharky (4/4/2012)

    SQL is pretty bad at doing any character manipulation and comparison. I always use LIKE, CHARINDEX etc. as a last resort. I agree, your solution performs...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 4:43 pm

    #1469903

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/5/2012)

    The Dixie Flatline (4/5/2012)

    SQLRNNR (4/5/2012)

    Brandie Tarvin (4/5/2012)

    Lynn Pettis (4/5/2012)

    Oh well, no bomb. Back to work.

    Was it Twinkies?

    Strawberry flavored with a touch more fiber than normal.

    Save some for supplies...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 4:39 pm

    #1469901

  • RE: Limited permissions but able to delete data

    mohammed moinudheen (4/5/2012)

    We found it. This account was a member of two other groups which had DBO on the database.

    glad you found the user.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 12:13 pm

    #1469742

  • RE: how do you filter against a datetime field?

    Sean Lange (4/5/2012)

    Eugene Elutin (4/5/2012)

    Sean Lange (4/4/2012)

    You have to either use a datetime variable or put your string representation inside single quotes.

    select * from TICKET where createDate > '4/1/2012'

    Is it...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 8:14 am

    #1469543

  • RE: Limited permissions but able to delete data

    mohammed moinudheen (4/4/2012)

    and to the OP if he had not considered SQL Server authentication.)

    No, not yet.

    with sql authentication you dont have the nasty problem of elevated access levels inherited from...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 8:06 am

    #1469538

  • RE: Connecting a SQL server instance

    there are 3 ways to do this. the best depends on what exactly you are trying to get from server 2.

    1. add server 2 as a linked server on...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 5, 2012 at 7:44 am

    #1469512

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/4/2012)

    Lynn Pettis (4/4/2012)

    SQLRNNR (4/4/2012)

    GilaMonster (4/4/2012)

    Who feels like doing the impossible? http://www.sqlservercentral.com/Forums/Topic1278455-391-1.aspx

    A lot of attitude on that one.

    Well, apparently we can't accept the restrictions he has to work under on...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 10:19 pm

    #1469305

  • RE: Count Data in Large Seprated Text

    ColdCoffee (4/4/2012)

    Aw no!!! Dont concatenate values into a single column. Normalize and seperate them out as columns which will save u time and money!

    +1. you are seeing why normalizing...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 6:28 pm

    #1469244

  • RE: a looping subquery whose result set is used by parent? do I use a CTE?

    xenophilia (4/4/2012)

    Well, your very first query/response works and I was going to go with that (apply to real life situation), but I'll make sure to look at the others too....

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 4, 2012 at 6:22 pm

    #1469243

Viewing 15 posts - 661 through 675 (of 859 total)