Re: Day Of The Week

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 03/02/04 

Date: Tue, 2 Mar 2004 13:42:31 -0500

select datepart(weekday,getdate()) 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jim Heavey" <JHeavey@nospam.com> wrote in message
news:Xns94A07D007A203JHeaveyBDUP@207.46.248.16...
> There is probably a better way to do this...but...
> I am wanting to run a procedure which will backup a database.  I created 7
> devices, one for each day of the week.
> When I run my procedure, I was wanting it to figure out the day of the
week
> so it would know which "device" to use for a backup.
> Is there a SQL command which will allow me to determine the day of the
week
> rather then having to pass a parm which provides the day of the week?
>
> Thanks in advance for your assistance....

Relevant Pages

  • Re: Active/Active/Active without SAN
    ... Private assistance is known as "consulting" and is ... Microsoft SQL Server MVP ... >> Senior Database Administrator ... >>> would like to implement a fail safe SQL system. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... >> Try and run comclust.exe on each node to set MSDTC to cluster mode. ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Active/Active/Active/Passive and Database Mirroring
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... In the active/active/active/passive configuration is it possible to load ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Scenario
    ... limited budget, but you may need to point out to management that they will ... I support the Professional Association for SQL Server ... > "Geoff N. Hiten" wrote in message ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: AWE Memory Question
    ... Are you talking about the PageLife Expectancy counter? ... > SQL Server that I saw this as an opportunity to gain insite on another ... >>>> severe memory pressure, this won't help much. ... >>>> Senior Database Administrator ...
    (microsoft.public.sqlserver.setup)