Never mind. I'm have a senior moment.

I know you can see them that way in Object Explorer Details, but is there any way to change the default sort order of tables in Object Explorer (left pane)...

I solved this by splitting it into two expressions in two different textboxes. It seems if the user leaves the date parameter null it will cause an error if...

Luis, you are correct. MAX didn't work because it always gave me the last week of the year. But MIN works fine if I compare the CalenderDate to...

Outstanding! :-D:-D

I had not used Cross Apply before. Your idea of using Cross Apply, along with dynamically creating the column list for the pivot table solved my problem....

That all applies to aggregating, which doesn't apply to my problem.

Here's some code that ALMOST does what I want. It will supply the dynamic columns, BUT only give me...

Lowell, that link just points back to this forum post.

I read the article completely, but I can't see how it applies to the specifics of my problem. I need a dynamic number of columns, with the first columns...

It hasn't happened again, only the one time. I never figured out what caused it.

GSquared, getting the vendor to add a custom alert feature will not get approved right now. We are over budget already on billing hours from the vendor. It...

So, you both agree that a trigger will do the job. But, I can't visulize the logic in a "scheduled job" that could monitor a table. We need...

I am receiving this same error. I have checked permissions on the location, and the domain account that SQL services runs under has full control of the directory. ...