Glad I could help 🙂

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...

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...

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...

???

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

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...

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...

duplicate post.

Please continue discussion here

duplicate post.

Please continue discussion here

duplicate post.

Please continue discussion here

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...

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...

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...

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...

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...