Never mind. I found an example on Technet and it worked perfectly. Thanks a bunch!

I am using 2012. Can you give me an example of using the PARTITION and COUNT function?

Thanks!

this works, but I was hoping not to have to do a GROUP BY because there are actually several more fields being selected than shown. Just more typing, but...

One record per customer.

Hello,

I am trying to get this to work. I have a text box that I have added an action. In the action I have go to URL. For the URL,...

Great information from all of you, thank you. I will try all of these and see what works the best in this situation.

Unfortunately that does not exist. I could create such a table, I suppose. I was reading something about Common Table Expressions (CTE) but I am not familiar with them....

Well, right now things are working again. The phantom error fixed itself situation... I hate that. No one will admit they changed something.

If it starts up again, I will try...

OK. That was a great idea. I started the continuous pings and ran the query. I watched the pings get slower and slower. Then I saw one packet drop on...

Thanks. Ya I found those posts and checked those settings. They were not the problem.

Yes it does. It is using a shared data source that works with other reports. I have tried changing it, just to test, and it gives an error that the...

Perfect! Thanks!

Perfect! Thank you! I knew there had to be a way to nest the REPLACE(s). I just couldn't figure out the right order.

The format is somewhat consistent... What may change is the number of digits before and after the _

There will always be only numbers before and after the underscore, but there...

Thanks. There is an average of about 15,000 files in that directory so I went the way of writing a c# script and having it gather all the file names...