mtucker (7/30/2009)

---

Since it's impossible to prove the non-existence of diety, the denial of said existence is just as much a question of faith as the assertion of the opposite. ...

Cool biz. Glad we could help.

I have a Numbers table that goes from 1 to 10,000 that I use in this.

;

with Timeslots

as...

The whole things looks like it could be solved simply by using "Where In" on the column you want and the sub-query you want. Am I missing something?

It'll only work on defined foreign key constraints. Is it possible that the database(s) that won't render doesn't have those set up in it?

Is it something where you could have the proc populate a temp table instead of using a view? That might do what you need, and might be more efficient.

Yep, that's what we do.

License says you can't use it for production databases. QA isn't production.

Please don't double-post. This is a duplicate of your other post on another forum on this site.

sjsubscribe (7/30/2009)

---

That's a...

My solution would depend on whether the disk is full or not, at the very least.

mtucker (7/29/2009)

---

Is it? Please provide that definition. Please also note that I operate...

Jan Van der Eecken (7/29/2009)

---

GSquared (7/29/2009)

---

Jan Van der Eecken (7/29/2009)

---

Lynn Pettis (7/28/2009)

---

Might be E3L (or ETL, but then that might be cofused as something else), English as 3rd Language; as...

I think of it this way: If someone has already gotten far enough into your security to be logged in to the server's desktop in such a way that they...

Try this for a list of the files:

create table #T (

ID int identity primary key,

FName varchar(256));

--

insert into #T (FName)

exec master..xp_cmdshell 'dir MyTraceDirectory\*.trc /b';

--

select *

from #T;

You'll have to put in the...

Looks good.

The reason I mentioned Row_Number() for this is that you can join a CTE to itself, and you could include in the join criteria "and CTE1.Row = CTE2.Row-1", if...