This probably could be optimized, but it seems to work...

Public Function PTO(startDT, endDT) As Integer

    Dim ptoHrs As Integer

    Dim chkDT As Date

    Dim weekendDays As Integer

   ...

If this is a one-time job, you can write an ASP page/VB app/whatever to grab all of these "crap" records into a recordset, parse through each one populating the HTML...

Sorry "fhanlon", effect is also a verb.  If you're gonna slam someone, be sure you do some research first.  Checking dictionary.com, effect "1.  To bring into existence. 2. To produce...

This QOD is going to pot really quick.  I think someone needs to QC these before they go out (I'm assuming this doesn't currently happen -- if it does, we...

I'm with Frank on this one -- I think it depends on the situation whether or not you store files/images in the DB or externally.  I've got a web app...

From what I've seen there are many different views on this subject.  Yeah, I realize there may be some performance loss but I have yet to experience any, so weighing...

Thanks for the advice...  I have no identity columns left though -- replaced them all with uniqueidentifiers that get seeded by NEWID().  Will delve into some articles I have on...

Don't worry about bogging me down with details -- the more the better.  Stirred up quite the hornet's nest I did, eh? 

Thanks for all the info.  I'll be sure to check out the links that were provided.  BTW, I am aware of Oracle being better in security but we have a...

Not familiar with ColdFusion, but if you were using ADO, use the command object.  Something like:

With cmd

   .CommandText = "sp_xml_preparedocument"

   .Parameters("@xmlpacket") = "<cfoutput>#xmlQuestions2#</cfoutput>"

   .Execute

End With

should work.  I assume there is an...

There was another thread on this yesterday and collectively we've deduced that it's an issue with Enterprise Mgr after VB6 SP6 is installed.  Unfortunately, we haven't figured out what the...

Another way is like:  SELECT RIGHT(SPACE(20) + 'example', 20).  Probably use a LEN function or variable instead of a scalar value though...

Found a bit more info... http://www.developersdex.com/sql/message.asp?p=1926&ID=%3CA59FC9F1-35DD-488D-9273-1A4AE8109E0A%40microsoft.com%3E.  Seems it may be a VB6 SP6 issue.  I am now getting a problem where if I open a diagram created pre-SP6 I...

I have the same problem.  Googled for some info, but came up pretty much empty.  Hopefully someone here knows what's up...