3rd world developing nations with more than 50% of their population infected need to stop aids

• . ´¯` . • Brany • . ´¯` . • says:

yes!

• . ´¯` . • Brany • . ´¯` . • says:

i agree

• . ´¯` . • Brany • . ´¯` . • says:

and aids infected ppl need to stop f*cking

• . ´¯` . • Brany • . ´¯` . • says:

(excuse the blunt language)

Dave Bitton (Gold Medal Coder) says:

and ya know what? i don;t the usa should do a damn thing about problems in any other nation besides our own

• . ´¯` . • Brany • . ´¯` . • says:

that’s so true

• . ´¯` . • Brany • . ´¯` . • says:

we have poor ppl here…

• . ´¯` . • Brany • . ´¯` . • says:

sick ppl

• . ´¯` . • Brany • . ´¯` . • says:

mental ppl

• . ´¯` . • Brany • . ´¯` . • says:

everything everyone else has

Dave Bitton (Gold Medal Coder) says:

i’m sorry, but it;s USA 1st, the world 2nd

• . ´¯` . • Brany • . ´¯` . • says:

yeah

• . ´¯` . • Brany • . ´¯` . • says:

are you a dem or rep?

Dave Bitton (Gold Medal Coder) says:

here;s something that needs to happen _before_ any group gets help, their needs to be an economic insentive to helping them

• . ´¯` . • Brany • . ´¯` . • says:

true…

Dave Bitton (Gold Medal Coder) says:

what economix incentive does a corporation have to help tjhe poor? none.

• . ´¯` . • Brany • . ´¯` . • says:

then again,. some countries have nothign to give

Dave Bitton (Gold Medal Coder) says:

and in case you haven’t taken a business class, but the number 1 objective of any employee is to increase shareholder equity

Dave Bitton (Gold Medal Coder) says:

and you don;t increase share holder equity by giving shit away for free

• . ´¯` . • Brany • . ´¯` . • says:

true.

Dave Bitton (Gold Medal Coder) says:

and until such time as there is a return on investment for helping the disadvantaged, it’ll have to accomplished by the fed, and that is as good as nill.

Dave Bitton (Gold Medal Coder) says:

i’ll give you a great exampole

• . ´¯` . • Brany • . ´¯` . • says:

are you a big economics guy?

Dave Bitton (Gold Medal Coder) says:

ever look at your phone bill?

• . ´¯` . • Brany • . ´¯` . • says:

you really seem to know your stuff.

• . ´¯` . • Brany • . ´¯` . • says:

umm… kinda. i don’t pay for it so…

Dave Bitton (Gold Medal Coder) says:

there’s something called a Universal Service Fee

• . ´¯` . • Brany • . ´¯` . • says:

okay, i’ve seen it

Dave Bitton (Gold Medal Coder) says:

that;s was a tax imposed by the fed to help pay for telecommunications for poor and remote regions of the country

• . ´¯` . • Brany • . ´¯` . • says:

oohh….

• . ´¯` . • Brany • . ´¯` . • says:

so some poor ppl don’t pay to have a phone?

Dave Bitton (Gold Medal Coder) says:

why you ask? because there is no economic incentive for telecom providers to do it themselves, and therefore the fed had to step in

Dave Bitton (Gold Medal Coder) says:

it’s more has to do w/ infrastructure

• . ´¯` . • Brany • . ´¯` . • says:

oh i see

Dave Bitton (Gold Medal Coder) says:

the fed gives that money back to the telecoms to aid in the build-out of infrastructure that they otherwise would not have implemented because it doesn;t make economic sense. the ROI would be negative, and that is a no-no

datetime comparisons in T-SQL aren’t always a walk in the park. One of the most annoying things that someone would need to overcoming is filtering solely on the year, month, and day component of a datetime field. This is further complicated by how .NET initializes a DateTime object.

When a DateTime object is instantiated without secifying the time, it is set to 12:00AM (midnight). When you pass the DateTime object to an SqlParameter, the following is sent over the wire:

exec GetContracts @CreationDate = 'Aug 13 2004 12:00:00:000AM'

A further complication is that even if you pass creationDate.ToShortDateString() (assuming of course that your DateTime object in code is ‘creationDate’) to the Value of your SqlParameter, the afortementioned value is still passed to the stored procedure. This is because the stored procedure parameter is typed as datetime. Now, how do you overcome this?

With values in the table such as ‘2004-08-13 13:02:44.767’, you’ll never be able to match ‘Aug 13 2004 12:00:00:000AM’, and therefore no rows will be returned. The way I have overcome this problem is to make use of DATEDIFF and the dayofyear DATEPART. By using the following in your WHERE clause:

DATEDIFF(dayofyear, @CreationDate, Contracts.CreationDate) = 0

This will return 0 whenever the day of the year is the same in both the table, and the stored procedure parameter. Any other day will either cause DATEDIFF to return a non-zero value. You can also use this if you want everything from this date and on (or before) by changing the comparitor to > or < as appropriate.
Sproc on!

The ability to page in SQL Server is one of those things that everyone wants, but can’t quite seem to get from Microsoft. Many ideas have been posted, each claiming to be _the_ way to do it. In the spirit of mine is better than yours, I’ve implemented my own paging scheme.

A feature that is in the upcoming version of SQL Server is the ability to supply a variable to the TOP keyword. Well, as it turns out, this functionality does exist in SQL Server 2000. The only difference is the syntax. To limit the number of rows returned from a query based on a variable is to use SET ROWCOUNT @Foo. Don’t forget, however, to reverse that after the query by setting ROWCOUNT to 0.

The principle of which this works is that I return all of the primary keys in a table into a table datatype up to and including the record that i want to start at. Then I grab that value by selecting the TOP 1 from that temp table, ordering by the value, descending. Now I have the starting primary key value.

At this point, it’s a matter of looping through the records, row by row until I have filled my cache table with a single page’s worth of data. Once that is complete, I return the contents of the cache table. In addition, in the form of an OUTPUT param, I return the total number of rows in the table. I have this value as a result of a sanity check that stops the proc if we are requesting a page of data that is past the end of the table.

ASP.NET MVC 4 In my ASP.NET MVC 4 partial view, I was having an issue where VaidationSummary and VaidationMessageFor were coming up blank. I scratched my head on this for quite some time. I finally came across this entry at the MVC forums at MSDN. It turns out I wasn’t passing the ViewData from parent… […]

The need for stability Meg’s sites, megbitton.com and soulsimagined.com have uptime requirements that far and away exceed those of mine. Almost the entirety of her business is predicated on a persistent Internet presence. As I’m sure you understand, a few minutes of downtime could lead to a belief that she’s no longer in business. This… […]

What catalog is that file in? That’s what I hear often from my wife Meg; a professional photographer. Meg uses Adobe Photoshop Lightroom for cataloging the pictures she takes for her business as well as the pictures she take of our family. An underlying frustration that I find with Lightroom is the fact that photos… […]

The MultiMarkdown ToC Do you ever feel like you’re never finished? I do, and I’m not happy with the fact that I haven’t been able to make Scrivener trigger the mmd-xslt script following a compile to MultiMarkdown HTML. Fine. As with the original XML epiphany, I knew there had to be code to perform an… […]

To snippet or not to snippet My last post spoke of the need to use a snippet of XHTML in order to include it in a WordPress Page. This rule was short-lived. Why am I recanting my story? I switched to MultiMarkdown 3 and attempted the use its XSLT transformation capabilities; something of which requires… […]

Learning I’ve been working on this app spec for weeks at work. In an effort to improve on what I’d accomplished, I reached out to my friend, and one of the smartest people I know, Peter Becan. I wanted him to teach me how to do it right. Peter’s been doing this sort of thing… […]

I had a need to import some CAD drawings into my Visio document. The CAD drawings were provided to me as PDF documents. Visio has no native way to insert a PDF into a drawing. SnagIt to the rescue. Besides being an excellent app for making screenshots, it installs itself as a printer. Well, all… […]

I’ve been toying around with SQL Server CE replication. For whatever reason, my code was failing with the following exception when I called Synchronize(): Failure to connect to sql server with provided connection information. sql server does not exist, access is denied because the iis user is not a valid user on the sql server,… […]

I am working on a SQL Server 2005 Reporting Services (SSRS) report that has differing row colors based on a value in each data row. The color value is defined in the database. When I initially created the report, each row had a variable background color but the foreground color was black. The first time… […]

Don’t forget when you update the RT_SiteConfig.pm file, you need to restart httpd. I was banging my head against the wall of this one until I had a moment of clarity. The post Request Tracker RT_SiteConfig.pm appeared first on Code No Evil.