Here's what I came up with. It looks like it's working.

CREATE FUNCTION [dbo].[AddBusinessDays]

(

@numOfDays As Integer, @DateBasis As Date

)

RETURNS date

AS

BEGIN

DECLARE @d as date

DECLARE @i as integer

SET @d = @DateBasis

IF @numOfDays...

Well, ended up playing around in VBA to come up with this. Actually a bit easier than I thought. I post the T-SQL equivalent shortly. The idea is to increment...

Thanks for that link. I realized over the weekend, that I was asking the wrong question. I don't need to adjust to the nearest week day, but rather need to...

This looks promising.

http://www.sqltipsandtricks.com/2009/08/31/adding-and-subtracting-business-days-to-a-date/

So check to see if the returned value is null and if it is return the lower boundary date?

So go with two functions - one that extracts the alpha-prefix and the numeric from the value entered from the user and another that combines the two for display. Should...

Thanks a bunch that goes a long, long way to actually doing what I need to do.

And then break out the prefix from the criteria and apply the derived criteria against the derived columns?

bitbucket-25253 (3/1/2010)

---

Warning - this code has not been tested extensively -- so you must do so before placing into production.

CREATE Procedure Dbo.TrInven

@DOTNumber INT,

@OwnerId INT,

...

I understand that IDENT_CURRENT will retrieve the identity value, but how do I incorporate that into a single SQL statement that INSERTS the child record, grabs the IDENTITY and then...

Problem solved.

The Server Admin had provided a password for the 'sa' account which I was not aware of. Once I got the password, I made the mistake of logging in...

I was figuring that Windows Authentication was the best route. I've been using SQLExpress on my personal laptop and didn't consider the ramifications of trying to set it up in...

I think that the admin may have setup a password for the sa account when he installed SQLServer on the machine.

Q: Which is preferred Windows Authentication or Windows/SQLServer (mixed)?

Q:...

GilaMonster (2/24/2010)

---

david.c.holley (2/23/2010)

---

I fully understand the difference between a full backup versus a differential. Given that my experience as an Admin on a SQL Server database is nil, is it...