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...
January 22, 2008 at 4:44 pm
Very interesting technique, I can see that coming in handy. I really need to read more. 😉
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...
January 16, 2008 at 4:02 pm
Matt Miller (1/16/2008)
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...
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...
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...
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...
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...
December 31, 2007 at 8:39 am
Steve Jones - Editor (12/28/2007)
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...
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...
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...
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...
December 20, 2007 at 8:56 am
Steve Jones - Editor (12/19/2007)
December 19, 2007 at 2:42 pm
Viewing 15 posts - 826 through 840 (of 1,221 total)