I would expect problems going FROM 2005 TO 2000 however I'm going FROM 2000 to 2005. I don't recall how I ended up going around this but I do know...

Zach

If you are still looking, please drop me an email.

Ron

ronkoppelmann@gmail.com

Thanks to all, this helped me get something usable.

John, I'll cc you on an email regarding this issue and will call do discuss.

Thanks again!

The data is all in the same table and what I'm looking to return are all records from one table where the ProjectID is different and the DialID is the...

Thanks this helped an issue I was having.

I don't see Page Life Expectancy in my list of objects in PerfMon? I'm on version 2.0 do I have to upgrade to 3.0?

Russel

Thanks, this still returned rows where the value was NULL for Q#? Joins are a weakness for me but should it be a left join?

Ron

Thank you both!

Thanks for taking the time to read my post and respond. I think we have found someone to do the work. While it's a bit more complicated than the select...

thanks!

thank you (boy I need to get some sleep!) and thank you for a kind response to a newbie

I'd love to Sergiy but it's not my data model. Is there a way to parse the string for the number of occurances?

Please tolerate the newbie! The column in question is called "ivrs"

When I run this:

select (len(ivrs)-len(replace(ivrs,'7104','')))/len('7104')

where projectid = 2223

and systemid = 6

and calldatetime between

'2006-10-01 00:00:00' and '2006-10-31 23:59:59'

and attresult in...

Noel, thanks for the prompt response. I should have mentioned that the string of numbers is variable, will this still work?

For example the very next entry might be

7104 7106 7112...

Andrew,

This literally added the columns (ie mathmatically) instead of concatenating them.

I have tried the following:

update PhoneTable

Set AreaPhone = (AreaCode & PhoneNumber)

with no luck either.

Other suggestions?

Thanks