Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 5,502 total)

  • RE: Verifying Data against a list of symbol characters

    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]

    May 18, 2010 at 3:00 pm

    #1169123

  • RE: Verifying Data against a list of symbol characters

    Robert.Weeden (5/18/2010)

    The root problem I am having is trying to find any instance of the incorrect symbols amongst a myriad of combinations. I need to be able to find...


    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 18, 2010 at 2:48 pm

    #1169115

  • RE: converting Iif from access 2007 to SQL Server 2005

    Untested, so you definitely need to verify in detail:

    UPDATE [shiptype]

    SET [shiptype].[Order Type] = [EDI_T]

    CASE

    WHEN ([shiptype].[EDI_T]) LIKE 'web%' THEN 'WEB'

    WHEN ([shiptype].[FrctStnd]) = '1' THEN 'EDI'

    WHEN ([shiptype].[EDI_T]) IS NULL THEN 'MAN'

    ELSE...


    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 18, 2010 at 2:42 pm

    #1169113

  • RE: Verifying Data against a list of symbol characters

    Would something like the following help?

    SELECT * FROM

    (

    SELECT 'Smith John' AS lastname UNION ALL

    SELECT 'S#ith Jane' UNION ALL

    SELECT '\ Jim' UNION ALL

    SELECT 'Anderson Ken' UNION ALL

    SELECT 'Smith-Barny Andre'''

    ) a

    WHERE lastname...


    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 18, 2010 at 2:34 pm

    #1169109

  • RE: Verifying Data against a list of symbol characters

    Robert.Weeden (5/18/2010)

    Most commonly I will get data like this

    LastName

    SmithJohn

    ???

    Seems like the page formatting eat up all your "special" character... Maybe you could provide a (small) screen shot as an image?


    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 18, 2010 at 2:22 pm

    #1169102

  • RE: T-SQL query to exclude certain rows

    Several questions:

    How do you calculate the duration?

    Example:

    If you exclude the second occurance of event 1 for Odometer 194780 (Date = 2010-03-26 08:32:00.000), how do you get 32minutes (I'd expect...


    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 18, 2010 at 2:16 pm

    #1169096

  • RE: Verifying Data against a list of symbol characters

    You might want to look into the wildcards used in a LIKE query.

    For details please see BOL, section "LIKE", examples.

    Another option would be to check if the string contains an...


    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 18, 2010 at 2:00 pm

    #1169085

  • RE: Open URL using T-SQL Code

    duplicate post.

    Please continue discussion here


    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 18, 2010 at 12:57 pm

    #1169048

  • RE: Copying data frm Sql Server to MS Access

    duplicate post.

    Please continue discussion here


    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 18, 2010 at 12:54 pm

    #1169044

  • RE: Accessing my ssas olap cubes via http

    duplicate post.

    Please continue discussion here


    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 18, 2010 at 12:52 pm

    #1169042

  • RE: Slelect Problem: kind of like a pivot but different

    Jeff Moden (5/17/2010)

    @nsontag,

    Nice job. It was only your second post and you came right around with some really nice test data. A lot of people squawk about doing...


    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 18, 2010 at 11:45 am

    #1168999

  • RE: Slelect Problem: kind of like a pivot but different

    nsontag (5/17/2010)

    Interesting..so this is essentially creating a binary test for selected terms and then selecting the max values from those tests and grouping by employee ID.

    That's great!

    Thanks for all your...


    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 17, 2010 at 4:53 pm

    #1168520

  • RE: Slelect Problem: kind of like a pivot but different

    Here's a tested version based on your sample data. That's the advantage of providing ready to use sample data the way you did! Excellent job!!

    Side note: the concept below is...


    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 17, 2010 at 4:11 pm

    #1168498

  • RE: Enforce entry in one of two fields

    Another option not depending on the CONCAT_NULL_YIELDS_NULL setting would be using (col1 IS NULL OR col2 IS NULL) instead of (col1 +col2) IS NULL...


    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 17, 2010 at 3:06 pm

    #1168469

  • RE: Enforce entry in one of two fields

    I'm sorry!! I missed the second part of the requirement...

    Here's the expanded constraint:

    ALTER TABLE #temp

    ADD CONSTRAINT chkCol1Col2 CHECK ( (ISNULL(col1,col2) IS NOT NULL) AND (col1 + col2 IS NULL));

    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 17, 2010 at 3:00 pm

    #1168467

Viewing 15 posts - 3,481 through 3,495 (of 5,502 total)