Thanks, for the quick response!
Unfortunately, I'm getting errors upon running this. 
Is any other syntax that I can use, especially without a CTE?  I don't understand why it's...

Thanks, for the response!

Actually, I figured this out on my own.

I used a COUNT(*) clause, as follows:

COUNT(*) OVER (PARTITION BY RM20101.CUSTNMBR, RM20201.APTODCNM, RM20201.APTODCDT) as Cnt.

Specifically, I embedded this...

Hi There:

Actually, thanks to someone named "RogerRogerATX" on the Microsoft Dynamics Community message board, I was able to get this figured out thanks to the following code that he and...

Hi There!

I have eight attachments, here on this post. The six queries are sample data that you requested.

The last two attachments are Excel spreadsheets. The first shows what...

That article offers very little, in terms of anything along the lines of examples or knowledge transfer.

I await another response.

Thank you.

John

UPDATE: Disregard this posting. There was a SharePoint trusted account in SQL that needed to have permissions to the new database. Once I got the permissions set...

Here's the solution.

After looking at the log, it was discovered that the end user did not have db_datareader rights to the database. This was necessary since the reports...

SQL 2008 Standard Runtime. I don't know how to slip-stream. So, the answer is no on the service packs.

If there were a way to attach log files on...

Look. My point is that others have run into the same issue that the guy at the beginning of the post ran into. As I tried saying several...

Also, if anyone is curious, below is a link to a few people that ran into the same issue that I did and did not find a resolution. The...

Oh, yes, I do backups--all the time!!!!!

What's interesting is that a lot of my co-workers and people out on the various forums have had this same issue. The resolution?...

The sa account has never been manipulated, no.

I did review the log files and they told me to uninstall "MSSQLSERVER". That is not an option, as uninstalling the default SQL 2005 instance would put the client's...