You're welcome.

The second query should work as written in T-SQL. Are you getting an error message from it, or just assuming it needs to be rewritten?

The usual way to cut...

Table variables definitely work. Just not temp tables (or "real" tables, of course).

Okay, that can definitely be improved relatively easily.

I'll need object definitions for the views/tables it's pulling data from to really rebuild it, but it can be done as a single...

What kind of front-end application are you using for this?

That's where user input takes place. How you do it depends on the type of application and how you build...

I'm not clear on what you're trying to do.

Why do you need a new window in order to put a T-SQL script into a job?

Functions can't create objects or modify data. You can use table variables in them, if they are either multi-value or scalar, but not table functions.

Can you post the code...

I'd use a dynamic SQL command to do Select Into from each file.

DBA is a bit overwhelming at first.

No, revise, forget "a bit". It's just plain overwhelming at first.

Unless you have good guidance from one or more people who already know...

Markus (10/31/2011)

---

The only time I ever do this is before and after applying a service pack or CU as like a safety net. That way should the master db...

I usually go as a computer geek on Halloween.

Can the second procedure call the first procedure and use the data from it that way. Then you just call the second procedure.

Otherwise, you'll need to take the recordset...

In the data flow task, add a derived column, and put the date in that. That goes between the source and the destination.

Kiara (10/28/2011)

---

GSquared (10/28/2011)

---

Touch is faster than mousing, but since I use a trackball with four buttons and a scroll-wheel that can act as a fifth button, touch doesn't anywhere near...

Yes, it can be done.

However, I'd store the hierarchy in one place if possible.

A team could have parent/child teams, but unless an employee can be in more than one team,...