Viewing 15 posts - 8,896 through 8,910 (of 14,953 total)
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. ...
July 31, 2009 at 7:13 am
Cool biz. Glad we could help.
July 30, 2009 at 2:45 pm
I have a Numbers table that goes from 1 to 10,000 that I use in this.
;
with Timeslots
as...
July 30, 2009 at 1:34 pm
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?
July 30, 2009 at 1:24 pm
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?
July 30, 2009 at 1:21 pm
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.
July 30, 2009 at 1:19 pm
Yep, that's what we do.
License says you can't use it for production databases. QA isn't production.
July 30, 2009 at 12:24 pm
Please don't double-post. This is a duplicate of your other post on another forum on this site.
July 30, 2009 at 11:48 am
sjsubscribe (7/30/2009)
jcrawf02 (7/30/2009)
There are always exceptions because that's what humans are, a large collection of exceptions. But in aggregate, the qualities mentioned can tend to be indicators of maturity.
That's a...
July 30, 2009 at 11:46 am
My solution would depend on whether the disk is full or not, at the very least.
July 30, 2009 at 11:31 am
mtucker (7/29/2009)
Lynn Pettis (7/29/2009)
And by the way, Atheism is considered a religion under the First Amendment of the Constitution.
Is it? Please provide that definition. Please also note that I operate...
July 30, 2009 at 7:30 am
Jan Van der Eecken (7/29/2009)
GSquared (7/29/2009)
Jan Van der Eecken (7/29/2009)
Lynn Pettis (7/28/2009)
July 30, 2009 at 7:07 am
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...
July 30, 2009 at 6:56 am
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...
July 30, 2009 at 6:50 am
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...
July 30, 2009 at 6:42 am
Viewing 15 posts - 8,896 through 8,910 (of 14,953 total)