That worked perfectly! Thank you very much!

I wrote this query to show me which record are duplicates, but can't figure out how to delete the records, but leave one:

select SERVICEOPTIONSKEY, ACCOUNTKEY, count(serviceoptionskey) AS [COUNT] from...

Thank you! This worked perfectly!

SELECT SUBSTRING(ACCOUNTNUMBER, 1, 3)+'-'+SUBSTRING(ACCOUNTNUMBER, 4, 5)+'-'+SUBSTRING(ACCOUNTNUMBER, 9, 2)

FROM BILLING.ACCOUNT

So far, I'm able to select the first three and then add an dash like this:

SELECT LEFT(ACCOUNTNUMBER, 3)+'-'

from BILLING.ACCOUNT

But I'm not sure where to go from here. Should I...

Nevermind, I got it:

select * from tablename

WHERE charindex(stsub, address) = 0

That worked perfect and give me all the records have has stsub as a part of address. Now, on the flip side of that, if I wanted to know...

Thanks! That worked perfectly. I knew that I was missing something!

Gotta remember that IN statement!

Jordon

Found the solution here:

http://www.sqlservercentral.com/Forums/Topic801367-146-1.aspx

Just as an update to this. I've tried running it as SA and a couple other accounts, with the same results. This make sense, since the sde account...

Just so that I'm clear, I never had an issue with this job running under 2005.

Thanks again!

Jordon

Ok, so this worked perfectly:

declare @fullName varchar(30)

SELECT @fullName = Name1

FROM UBMAST

select LEFT(@fullName, CHARINDEX(',', @fullName) - 1) as NameLast,

STUFF(@fullName, 1, CHARINDEX(',', @fullName), '')...

Perfect! Thank you! I forgot about the Having clause!

Perfect! Thank you!

Great point! Thanks again!

This worked perfectly

with BizDates (Bdate)

as (

select [Date]

from calendar A

left outer join HolidayTable B on A.[Date] = B.Hday

where B.Hday is NULL

)

--(alternatively you could eliminate the holidays from this table when you...