I'm assuming your data source isn't OLE DB or ODBC compliant, or you'd just set up a linked server and be done with it.

Otherwise, you'll have to have the Where...

Your solution will work if the hierarchy only has two levels. To be precise, it will work if a child can't have a...

I think you have misinformation about how a server-side trace works. You can use one to track queries, and keep the files from it for however long you want,...

WayneS (10/27/2010)

---

GSquared (10/27/2010)

---

WayneS (10/26/2010)

---

Gus,

Since you seem to know SSIS pretty well, I have a question for you. Is there a way to have a query that generates dynamic columns exported...

maddogs (10/27/2010)

---

Sorry to hijack this thread but I'd like to extend the same line of questions if I may - Right now I have SQL Server 2000\Visual Studio 2003 for...

You'll pretty much have to crawl the hierarchy three times. Once to find the parent, once to check if any child of that parent has a Y, and once...

It depends on what you're selecting from, so far as I know.

WayneS (10/26/2010)

---

GSquared (10/26/2010)

---

Jeff Moden (10/24/2010)

---

Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. ...

Tom.Thomson (10/26/2010)

---

Stefan Krzywicki (10/26/2010)

---

I was hoping to have a discussion of the different methods and maybe some links to documentation so I could read more on something I hadn't found...

Create a temp table, Insert...Exec into that, then join to the temp table.

create table #T (Col1 int, Col2 int);

insert into #T (Col1, Col2)

exec ('My script that returns two columns');

select *

from...

Because you can't guarantee which row will be assigned to a variable if your assignment can return multiple rows, and you need the last one per your posted requirements. ...

drew.allen (10/26/2010)

---

My issue with defining it as multiple tables is that you lose the fact that the order is important when you start introducing outer joins. Consider the following...

luissantos (10/26/2010)

---

Hello comunity

I create a simple select statment whith a variable, for example:

declare @numcli int

set @numcli = 11

select name,adress from customers where customers.no = @numcli

In ACCESS, when i define a...

You're welcome.

Can you change it back to Outer and add a Where clause to the outer query that gets you what you need? Something like "where LastExit between X and...