alex, I think e4d4's suggestion is probably your best (and maybe only) option. Once you set up the linked servers, you can query against them like this...

SELECT a.<column_list>, b.<column_list>

...

Indeed, I believe it would be. I...

Oh my goodness, Dwain. We laughed hard when we read that one.

cs_source (1/3/2013)

---

At this time i only use SAS for the percentile not for any other function so your solution is one step further than mine. When i review this hopefully...

I'm not really sure what you are trying to do, but how can 'Nothing' be a result of doing calculations on columns with not null constraints?

Not the code for percentile, but if you can figure out a way to use OPENROWSET with the SAS...

The rest *attitude*, of your postings Joe, is totally wrong; not a little wrong,...

CELKO ACCESS is a disaster and you need to get rid of it. I saw its premiere at a COMDEX; it did not work then and it does not work...

Smash125, this is untested as I don't have AdventureWorks, but I think you will be able to gleen something from it. Also, you did not mention anything about year,...

How about this... Go find a random person, show him or her...

Wendy,...

sqlrd22 (12/19/2012)

---

People have pointed out that this code is not great, doesn't work well, but I work for a very small company and I'm just trying to do my best...

Jeff Moden (12/16/2012)

---

[font="Arial Black"]That's an absolute load of hooie! This is an SQL Server...

Nicholas, is this for a school project? It kind of seems that way, but it is such a terrible design that I would hate to think an instructor is...

lokesha.b, I did not see it anywhere, though I may have missed it in the interim banter, but why do you need to do what you are asking? Is...