The statement executed outside of the view is the one below, filter added to both of the select statements.

SELECT accountnumber FROM agents2009 WHERE accountnumber = ''QOT039365'

UNION ALL

SELECT accountnumber FROM agents...

Personal Motto, Don't Shrink the Log unless unexpected transactions occur. Prior DBA had incorporated shrinks into the maintenance jobs, shrink only jobs etc. This left what appeared to...

Files are now available for download at the bottom of the article, sorry for the delay.

Happy Birthday Steve, mine is the 13th...

When asked this same question by my wife and kids I responded that a remote helicopter would be nice... a small one I...