Consistant dates for use in querys

I want to make some UDF()s to preset dates for a slew of reports that I need
to do.
In SQL Server I'm missing the mark in date math. I need to get a few basic
dates and I'll roll with the others
StartofLastMonth
EndofLastMonth
StartofLastW
EndofLastW
StartofCurrentMonth
EndofCurrentMonth
YesterdayWithWends
Is there any way to detect a holiday and know that business is closed? We
B2B with banks so we will be closed on Columbus Day! How can my
Yesterday... know that on Oct 11th it should really use Oct 7?
TIA
__StephenStephen,
Check out Aaron's page:
http://www.aspfaq.com/show.asp?id=2519
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:ufmEpv1yFHA.2516@.TK2MSFTNGP12.phx.gbl...
>I want to make some UDF()s to preset dates for a slew of reports that I
>need to do.
> In SQL Server I'm missing the mark in date math. I need to get a few
> basic dates and I'll roll with the others
> StartofLastMonth
> EndofLastMonth
> StartofLastW
> EndofLastW
> StartofCurrentMonth
> EndofCurrentMonth
> YesterdayWithWends
> Is there any way to detect a holiday and know that business is closed? We
> B2B with banks so we will be closed on Columbus Day! How can my
> Yesterday... know that on Oct 11th it should really use Oct 7?
> TIA
> __Stephen
>

Consequences of changing subscription expiry date SQL Server 2000

Hi,
I'm running a merge publication on a SQL Server 2000 database with
several anonymous subscribers. I want to change the subscription
expiry from 14 to 28 days. Aside from larger logging tables, are
there any important consequences to doing this? In particular, do I
need to reinitialise the subscriptions before the change takes effect?
Many thanks
Alex
There will be slower syncs. Yes you need to reinitialize.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<WombatDeath@.gmail.com> wrote in message
news:1173701986.327352.14330@.h3g2000cwc.googlegrou ps.com...
> Hi,
> I'm running a merge publication on a SQL Server 2000 database with
> several anonymous subscribers. I want to change the subscription
> expiry from 14 to 28 days. Aside from larger logging tables, are
> there any important consequences to doing this? In particular, do I
> need to reinitialise the subscriptions before the change takes effect?
> Many thanks
> Alex
>
|||Thanks Hilary. If I don't reinitialize the existing subscriptions
will they break, or will they just keep the old 14-day expiration time
until I get around to reinitializing them for other reasons?
Thanks
Alex