Without more detail it is hard to help, see Sean's post.

As I said I would think the union's would work but without data to test it I can't be sure....

What results are you getting? There is syntax errors in your posted SQL, commas before the from, I assume you removed some fields for the post.

Formatting the SQL will...

I recently worked on a process that had about 10 different fields I needed to check, all were had 'Y' or 'N' as the value. If any one of...

I was also having problems last month getting mine, I went in and unchecked the button to get the newsletter and saved it. Then went back in later and...

Just an FYI if you are using the CONVERT with 112 you don't need the REPLACE statement the 112 does not return the results with the slashes(yyyymmdd).

Steve Jones - SSC Editor (11/21/2013)

---

below86 (11/21/2013)

---

Version Control? What is this novel idea you speak of? Just joking. 🙂

Currently we don't really have anything in place to do...

yayomayn (11/21/2013)

---

BI Documenter from Pragmatic Works is pretty good and would do what you need. It will set you back a cool $595 though :ermm:

In SQL 2012 you have the...

This speaks to a bigger question I have at times. "What all uses this table?" It would be nice to know every SSIS package, .SQL file or stored procedure...

We have ours stored as .dtsx files on our server. I can use a Ultra Edit to search just the *.dtsx files for the table name I'm looking for.

Version Control? What is this novel idea you speak of? Just joking. 🙂

Currently we don't really have anything in place to do this here. I would love...

Thanks, Gail. That is what I was thinking but wanted some else's opinion.

If I execute the stored procedure from the bat file will I still be able to direct...

Koen Verbeeck (10/30/2013)

---

Just for your information:

osql is deprecated (and it has some issues. I remember it not working with...

We have the following in a bat file:

REM This BAT file uses the userid and password of the account that is running the BAT file.

REM %1 = SQLServer name

REM %2...

Luis Cazares (10/30/2013)

---

I wasn't saying that stored procedures save a log automatically, but are a simple way to manage your T-SQL code without touching the SSIS packages.

For the error logging,...

Luis Cazares (10/30/2013)

---

below86 (10/30/2013)

---

So until someone can tell me how I can see this same type of 'log' information for an execution of a SQL job, I will not be...