Forum Replies Created

Viewing 15 posts - 5,386 through 5,400 (of 5,502 total)

  • RE: updating xml schema collections

    As per BOL as well as Jacob Sebastians great Book "The Art of XSD" there is no way to remove an element from a stored schema using T-SQL. The only...


    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]

    May 5, 2009 at 12:07 pm

    #989088

  • RE: Problem with XML code

    Hi Gail,

    I've been through this on a different thread as well. The html code itself is fine, it's just the way it's been displayed.

    If you need the original xml code...


    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]

    May 5, 2009 at 1:20 am

    #988581

  • RE: CREATE TABLE permission denied in database 'tempdb'.

    Did you get a chance to figure out "who you are"? (see my post above)

    PS: I have the strong feeling that most of the folks around here would find it...


    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]

    May 4, 2009 at 2:27 pm

    #988386

  • RE: Like operator

    Lynn Pettis (5/4/2009)

    Have you tried this:

    SELECT description

    FROM tab1

    where description = '''%' + @Description + '%'''

    Please note, that is three single quotes at the start and end.

    You probably need to change...


    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]

    May 4, 2009 at 1:22 pm

    #988326

  • RE: CREATE TABLE permission denied in database 'tempdb'.

    Some thoughts:

    First, you shouldn't use master database for your application data. Create a separate database.

    Second, if you don't have any access to the master database you might have an issue...


    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]

    May 4, 2009 at 1:15 pm

    #988322

  • RE: xquery

    Hi,

    I assume your getting the following error message:

    Msg 2337, Level 16, State 1, Line xx

    XQuery [modify()]: The target of 'replace' must be at most one node, found 'attribute(*,xdt:untypedAtomic) *'

    The reason...


    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]

    May 4, 2009 at 10:23 am

    #988185

  • RE: CREATE TABLE permission denied in database 'tempdb'.

    WHAT is your question?

    Are you sure you're running SS2K5? (TYPE=INNODB and some other synthax throws a syntax errors - you won't even get to any permission check with the syntax...


    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]

    May 3, 2009 at 3:23 pm

    #987861

  • RE: Select for xml

    Did you notice that GSquared didn't reference the Type alias to an XML schema like you did?

    What happens if you run the SELECT the same way?

    If you still get less...


    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]

    May 2, 2009 at 5:57 am

    #987702

  • RE: How Can I speed up this query! Timing out! Help pls!

    Hi,

    Suggestions/thoughts:

    1)

    One of the biggest problems seems to be that VolunteerHours.EIN_NR is a varchar column. Does it really contain any characters?

    Reason for asking: Since the view casts all underlying columns...


    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]

    May 1, 2009 at 9:56 am

    #987408

  • RE: Select for xml

    Hi,

    please post sample data as described in http://www.sqlservercentral.com/articles/Best+Practices/61537/.

    Your sample data should include table definition, the namespace declaration as well as some sample data that pass and some that fail.

    My first...


    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]

    May 1, 2009 at 9:02 am

    #987359

  • RE: How to handle date from text file

    Hi Flo,

    looks like we're running a competition today...

    You beat me on that one :crying:

    Obviously you're not enjoying the Holiday the old-fashioned way... Neither do I 😛


    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]

    May 1, 2009 at 7:56 am

    #987315

  • RE: How to handle date from text file

    Would the following check help (for details please see BOL)?

    CASE

    WHEN ISDATE(b.LAST_DAY_WORKED) = 1 THEN b.LAST_DAY_WORKED

    ELSE ''

    END


    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]

    May 1, 2009 at 7:52 am

    #987311

  • RE: XML Parsing problem

    Hi,

    I assume you're missing the namespace declaration.

    ;WITH XMLNAMESPACES (

    DEFAULT ''

    )

    SELECT node.l.value('text()[1]','nvarchar(20)') as fieldname

    FROM my_xml_Data cross apply xml_data_column.nodes('/MyPostAd/Ad/MyPostAd') node(l)

    /*

    result:

    fieldname

    ---------

    [node]

    [node]

    [node]

    */


    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]

    May 1, 2009 at 7:45 am

    #987304

  • RE: A query

    It looks like your database is configured to be case sensitive. meaning the database is using a case sensitive collation.

    Your query should work if you change your SELECT and ORDER...


    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]

    May 1, 2009 at 6:12 am

    #987225

  • RE: How to Create an XML in MS SQL Server 2000

    reggae_blur (4/30/2009)

    Cool. Thanks for that.

    I'm glad it finally worked. Again, sorry for the mass...

    reggae_blur (4/30/2009)

    Btw, the BCP that you gave me, should I run it in SQL QA? 😀

    No.

    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]

    May 1, 2009 at 2:11 am

    #987179

Viewing 15 posts - 5,386 through 5,400 (of 5,502 total)