Project Life Cycle

1. Set delivery date.

2. Code until the day before the delivery date.

3. Do some half-assed testing.

4. If test results are good then go live else go live.

5. Declare...

This wasn't an April Fool joke; we did this as a welcome back from vacation for a "friend".

We replaced the doorway of their cubical with a solid wall section so there was...

If they do, it must not be very common.  YYYY-MM-DD is the ISO standard.

select
 dateformat,
 count(*)
from
 master.dbo.syslanguages
group by
 dateformat

dateformat             
---------- ----------- 
dmy        23
mdy        1
ymd        9

(3 row(s) affected)

You have to make sure you get your personal priorities taken care of too.  If you are just living to work, what’s the point?

They say that no one lays on...

You still didn't say which values of value_a and value_b cause the problem.

What are the data types of value_a and value_b?

What values of value_a and value_b cause the problem?

I prefer the "ignore them and let the server admins worry about it" approach.

If people with their own instance of SQL Server come to me with a problem, I tell them they installed it,...

The server probably has Internet Explorer Enhanced Security installed.

When the job runs, it pops up a dialog box to ask if you really want to run CSCRIPT.  Since it is...

You can just take the database offline before starting the restore, and that will prevent connections.

alter database MyDatabase set offline with rollback immediate

like '%[(!@#$%^&*()?><,./]%'

You code does not work for days before 1900-01-01.  Notice in the code below that it returns a Friday that is later than @mydate.

The code I posted works for any datetime...

This returns all Mondays from 2000-01-01 through 2010-12-31

select
 a.Date
from
 -- Function F_TABLE_DATE available on this link
 -- http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519
 dbo.F_TABLE_DATE ( '20000101','20101231' ) a
where
 a.DAY_OF_WEEK = 2
order by
 a.Date

You can use the Start of Week Function, F_START_OF_WEEK, on this link:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

Or you can do it directly with this statment:

Select LastFriday = dateadd(dd,(datediff(dd,-53686,@MyDate)/7)*7,-53686)

You didn't say what you wanted if...

Do the loans pay interest?  The site didn't really say anything about that.

This question was posted on SQLTeam also, and I posted a similar answer there earlier today.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=80468