How will you run it?

You could schedule it with SQL Agent, but the Agent would need to be able to access the folder.

It doesn't matter how you write a SQL...

We did something similar in a financial system by putting in data and fields that marked as "as of" a certain date. This allowed us to join tables together based...

In addition to Eugene's notes, you can use a CASE statement to change things around.

case

When x = 5 then 1

when x = 4 then 2

end

You can't use ms_foreachdb to insert a parameter into a query that's directly executed. You need to submit a query as a parameter.

Luis has shown you how this would work.

crussell-931424 (7/3/2013)

---

What I worry about is the data getting degraded, "accidentally" changed or whatever, as it moves from one location to another. For example, in your editorial I noticed a...

Whether you agree/believe with/in religion, GWaK does raise a good point that many people that go are very giving. They feel it to be a part of their religion. Is...

Eric M Russell (6/28/2013)

---

LOL! I do recall once, in the aftermath of a delete script gone wrong, querying the transaction log for a clue about what stop date/time to use...

Hope things are well.

I didn't write this because of religion or government.

I have spoken on this before, and I do think it's important. Being a part of some sort of non-profit or...

jasona.work (7/1/2013)

---

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio...

Thanks, glad you liked it.

Good idea, and definitely needed. I've asked for a few items to be added to search and they've been bumped on the list. We have a few things in progress,...

batgirl (6/28/2013)

---

This is my first year in the automotive industry. I must say that for the most part, I don't like being forced to take my vacation at specfic...

touche, I was trapped by Jon and Joe.

Good seeing you in any case and glad you had a good week.

Perhaps we have different definitions of side project. As John H noted, this would be 15-20 hours outside your current job, nights, weekends, whatever.

This would assume you've gotten through an...