Viewing 15 posts - 826 through 840 (of 1,221 total)
I'm developing a system for tracking how many days it takes to complete a task from when it's requested, but I have to exclude weekends and holidays. The original...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 22, 2008 at 4:44 pm
Very interesting technique, I can see that coming in handy. I really need to read more. 😉
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 22, 2008 at 3:27 pm
One thing that I notice as conspicuous in its absence is the mention of heat and electricity, and you can also throw in physical space. Adding more SAN/NAS/whatever devices...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 16, 2008 at 4:02 pm
Matt Miller (1/16/2008)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 16, 2008 at 10:29 am
David Jackson (1/16/2008)
One more thing, you will want an Order by sptd_lineno in the function to guarantee they come out in the right order.
I've taken to removing order by's in...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 16, 2008 at 9:56 am
David Jackson (1/15/2008)
You can use a function with no cursor for this.create function fn_GetComments (@keyno int)
returns varchar(8000)
as
begin
declare @comment varchar(8000)
select @comment = coalesce(@comment,'') + Rtrim(sptd_text) from sptextdt
where sptd_keyno = @keyno
...
That's...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 15, 2008 at 2:34 pm
Martin Bastable (1/2/2008)
We contacted the suppliers and talked to a developer.
....Yes we use count(*) so our system can check if a table exists with a particular copy of our software...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 2, 2008 at 11:23 am
A college degree is useful, but it will also help you to get your foot in the door. Lots of places will not even look at you, regardless of...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 31, 2007 at 9:16 am
Being a compulsive information gatherer/cataloger, from early on and before MP3 and P2P, I had my CD collection cataloged in Access. I had over 500 discs, and wanted to...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 31, 2007 at 8:39 am
Steve Jones - Editor (12/28/2007)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 31, 2007 at 8:09 am
Excellent article. I've been a SQL Server DBA for over a decade, but I came at it from being a database developer in the early 80's in dBase III...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 28, 2007 at 4:27 pm
Thanks for the link, Jay, I'm going to have to check that out.
I spent a year contracting for a state education administration, developing a system that fed their student annual...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 27, 2007 at 8:23 am
chris webster (12/21/2007)
One of my favourite movies this year: Stardust.De Niro's performance alone is worth the entrance fee
Seconded, thirded, etceterad! I picked it up last night at Best Buy...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 21, 2007 at 8:22 am
Steve,
I just read the questions that you linked to: fantastic set! It's also definitely a good set to study when you're in the market and going to be facing...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 20, 2007 at 8:56 am
Steve Jones - Editor (12/19/2007)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 19, 2007 at 2:42 pm
Viewing 15 posts - 826 through 840 (of 1,221 total)