I am very much a novice to SQL Server, so please forgive my ignorance. I have a couple of very simple DTS packages that I created last summer that I run about once a week from Enterprise Manager. Yesterday while troubleshooting an unrelated task, I edited my SQL Server Registration Properties...
It sounds like you need a Union query- what is the SQL that you have so far? The Select Distinct statement may help you aviod dups, but it's hard to tell without knowing the SQL you're using.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.