Try a merge join operation. You'd have to add the other table from the other database as a new source.

Jeff Moden (4/7/2008)

---

It would be an aggregate query to sum all the CDRs (Call Detail Records for Telephone Billing) for a about 120 thousand customers in a 4-5 million row...

dmizelle (4/7/2008)

---

All of it looks good, but I'm lost within the following code, specifically the line starting with "with leader...". I've been working w/SQL for 12+ years and I've...

Jeff Moden (4/7/2008)

---

Matt... thanks for the help. You're right, though... not a big fan of CLRs but could...

Mark Shvarts (4/7/2008)

---

So you are using Visual Basic to build dynamic function! I've never done it before, but at least it will be a reason to start using CLR.

I also...

adekunle (4/7/2008)

---

If you read through from the beginning of the post you will understand that i did not say my proc did not work, the problem is I DON'T WANT...

Mark Shvarts (4/7/2008)

---

That procedure is great, but I need a function.

Particularly, for my performance testing I am selecting metrics from sys.dm_exec_query_stats by cross applying it to sys.dm_exec_sql_text, which returns database...

Matt Miller (4/7/2008)

---

Jeff Moden (4/7/2008)

---

Matt Miller (4/7/2008)

---

I know this is a REALLY ugly trick.... put "SP_" as the prefix. by doing that - it will go try to find...

Jeff Moden (4/7/2008)

---

Matt Miller (4/7/2008)

---

I know this is a REALLY ugly trick.... put "SP_" as the prefix. by doing that - it will go try to find the view...

Hmm...don't know what I was looking at earlier...nevermind.

Here's a SP that would do the trick. Publish is...

In addition to MrPolecat's request - define "currently open". How does one determine what "open" is, what "current" means? (No - I'm not channeling Bill clinton - just trying...

where is this information stored? where are the name of the destination tables stored?

Mark Shvarts (4/7/2008)

---

That was my next question. In such a case I will need to find some other solution.

What I want to build is a function that would return object...

Chinni -

GSquared has tried to answer your question 3 separate times, and you're essentially coming back with the same information each time. Although I'm sure he thoroughly enjoys...

What exactly happens? nothing? error message?...