Forum Replies Created

Viewing 15 posts - 4,441 through 4,455 (of 5,502 total)

  • RE: Contracting: REFUND FOR REWORK?

    CirquedeSQLeil (1/22/2010)

    For me there are a couple of points of interest. What is a fair and equitable split? Do you want the Client as a repeat client? ...


    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]

    January 22, 2010 at 4:07 pm

    #1107632

  • RE: Contracting: REFUND FOR REWORK?

    I'm at the customer side (at least at the moment).

    The statement

    miscommunications with the client's client

    indicates to me that you've been hired as a subcontractor.

    If there would have been...


    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]

    January 22, 2010 at 3:28 pm

    #1107622

  • RE: Need help parsing HTML data stored as varchar(max)!!!!

    Pac123 (1/22/2010)

    I'm sorry what i had meant was- It would be possible to store the source data as XML. There are thousands of these records in the DB. If there...


    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]

    January 22, 2010 at 3:05 pm

    #1107613

  • RE: How to display duplicate (the tricky is need to check two sets of data as multi cols)

    Would you mind to provide table def, some sample data and expected result? Please have a look at the first article in my signature on how to do it 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]

    January 22, 2010 at 2:13 pm

    #1107590

  • RE: Help on comparing 2 rows for each id

    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]

    January 22, 2010 at 2:09 pm

    #1107586

  • RE: Need help parsing HTML data stored as varchar(max)!!!!

    Based on your statement

    i can modify the source data.

    I assumed you'd be able to convert it into "real" xml format.

    I tried to use the html format and...


    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]

    January 22, 2010 at 1:51 pm

    #1107576

  • RE: Need help parsing HTML data stored as varchar(max)!!!!

    If you could get the source data in xml format it'll be an easy task to do...

    DECLARE @t TABLE (ID INT , Conten XML)

    INSERT INTO @t VALUES(1, '<a id="AB123">sometext </a><a...


    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]

    January 22, 2010 at 1:11 pm

    #1107540

  • RE: get date range for each week of the year

    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]

    January 22, 2010 at 12:42 pm

    #1107516

  • RE: Help on comparing 2 rows for each id

    lcibert (1/22/2010)

    Lutz,

    First of all, thanks for your reply, and sorry for not putting the creation code for the data, I didn't realize about that.

    Now...


    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]

    January 22, 2010 at 12:31 pm

    #1107506

  • RE: Need help parsing HTML data stored as varchar(max)!!!!

    Before trying to resolve this issue one question:

    Would it be possible to store the data in xml format instead of html?

    Reason:

    String parsing is dangerous since it might lead to unexpected...


    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]

    January 22, 2010 at 11:57 am

    #1107495

  • RE: get date range for each week of the year

    Maybe something like this?

    Note 1: I used the tally table as described in the related link in my signature to generate the weeks

    Note 2: You may notice that this year...


    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]

    January 22, 2010 at 11:44 am

    #1107491

  • RE: Error when trying to delete

    If you still get the same error that basically means that you the procedure "Student_InsteadOf_Del_Trg" is stilled called (maybe by another trigger?)

    Just being curious (I noticed line #308 for 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]

    January 22, 2010 at 11:37 am

    #1107489

  • RE: How to Delete Right 3 Characters from a string

    DECLARE @v VARCHAR(30)

    SET @v='CA*461*NN'

    SELECT LEFT(@v,LEN(@v)-3)


    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]

    January 22, 2010 at 10:34 am

    #1107455

  • RE: Generating XML

    You should look for "FOR XML" clause in BOL or search this site for "XML Workshop Sebastian". The latter will result in a list of great articles by Jacob Sebastian.

    Or...


    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]

    January 22, 2010 at 10:27 am

    #1107447

  • RE: Stored procedure with a cursor, looks like it makes a loop

    What is the specific reason to use a cursor for this update?

    Why not doing it all in one path?


    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]

    January 22, 2010 at 10:21 am

    #1107445

Viewing 15 posts - 4,441 through 4,455 (of 5,502 total)