The main question would be: What would you define as "obsolete SQL objects"?

I think you can only refer to views, procedures and/or functions that would use tables or columns that...

It seems like a job for the "quirky update" method as described in Jeffs article[/url].

I recommend you read the article and try to modify it to meet your requirements.

If...

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