Forum Replies Created

Viewing 15 posts - 4,036 through 4,050 (of 5,502 total)

  • RE: How do I show items dated 1 day from current date?

    It looks like you limit the data with one of the INNER JOINS from below.

    Please reduce your query to those tables and check whether you'll get any values for today...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 9, 2010 at 7:55 am

    #1130672

  • RE: User cannot not see stored procedures

    Glad I could help. 🙂


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 4:04 pm

    #1130331

  • RE: User cannot not see stored procedures

    Did you try

    exec sp_helpuser 'user'

    to see if they belong to different roles on the two db?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 3:02 pm

    #1130312

  • RE: Poor Performance in function AFTER Updating Stats

    I'm not sure if the rewritten versions of the attached functions will return the same as yours currently used, but it might be worth a try...

    Especially dbo.GetOrganizationBedStatusID could be simplified...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 2:38 pm

    #1130296

  • RE: parse Real data type

    @bob-2 (The-One-Who...)

    It's funny that both of us came up with the almost identical solution. Including the BOL quote. Especially, if you put it in perspective to the "discussion" on THE...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 2:03 pm

    #1130275

  • RE: parse Real data type

    wwei (3/8/2010)

    HI lmu92,

    Thank you so much for your help.

    I tried, seems still not working for me.

    If I change the destination data type to either money, decimal, or number, will...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 1:56 pm

    #1130268

  • RE: parse Real data type

    Seems like you've got trapped by some display issue when using PRINT...

    If you'd run a SELECT instead, it's a little different- but probably still not exaclty what you're looking for....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 1:35 pm

    #1130251

  • RE: Getting huge amount of data with XML as input parameter

    You could send the ID values as a comma separated list in a varchar variable to your sproc.

    Run a high performing split string function to separate the values (an example...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 1:19 pm

    #1130237

  • RE: auto increment on a datawarehouse table help

    A few questions to clarify the scenario:

    What would be the sorting criteria? (I'd expect an ID or datetime column but there's none...)

    How would you deal with an element being deleted?...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 1:06 pm

    #1130230

  • RE: Convert XML to table without using sp_xml_preparedocument

    I'd prefer using XQuery rather than OPENXML.

    Something like

    DECLARE @VChr1 XML

    SET @VChr1 = '<i>1</i><i>52</i><i>3</i>' -- had to do it in two steps due to SS2K5

    SELECT

    T.c.value('./text()[1]','int') val

    FROM @VChr1.nodes('i') T(c)


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 12:54 pm

    #1130222

  • RE: Correlated Subquery with MIN()

    Ooopps!! You're right. I missed that the [type] column holds different data. I didn't spot the different values clus vs. ulus.

    Your code should run just fine.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 12:03 pm

    #1130199

  • RE: Correlated Subquery with MIN()

    knovak (3/8/2010)

    Thanks for the responses. I figured out the query about 10 minutes after I posted here. I was missing the IN and GROUP BY clauses. The...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 8, 2010 at 10:30 am

    #1130147

  • RE: Complex T-SQL query

    clive-421796 (3/7/2010)

    ...

    Would like to hear from the likes of Jeff Moden, Lynn Pettis, etc. if they have a solution for this.

    ...

    You will notice I mentioned Jeff Moden, Lynn Pettis, etc.

    etc....


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 7, 2010 at 12:51 pm

    #1129786

  • RE: How to using trigger to prevent a rubbish record

    That's not really a normalized database design...

    If you have a lookup table (like tH) you should reference the primary key (ID) of that table rather than the tcoutcd column you...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 7, 2010 at 3:20 am

    #1129736

  • RE: How to using trigger to prevent a rubbish record

    What is the reason not to use a foreign key?

    Seems like the appropriate solution for the requirement.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 7, 2010 at 2:40 am

    #1129732

Viewing 15 posts - 4,036 through 4,050 (of 5,502 total)