yet another who concurs on the value of a Calendar table;

then, depending on the columns /construction you add, you could do somethign as simple as this:

SELECT COUNT(*) FROM TallyCalendar

Where [Weekday]='Monday'

AND...

bumping my own thread; someone out there manage to get a folder of text files worrking in 64 bit?

Jim Woods (11/21/2011)

---

Getting message that unable to parse query with that - complete script:

UPDATE PM.Ailment_Info

SET chunk = replace(chunk, '|3^VA',...

powershell could run the command for each server, however, if you had, say 20 servers, and all 20 servers have sa witht eh same password, that's still not very secure...i'd...

stop the service on the server which has the active cluster node would be easiest,

from there you get ideas like unplugging the network cable, turning on the firewall to block...

nice alistar; only thing i would suggest is an improvement to avoid converting from int-to string and back to int again...you can use integer division and modulous to get the...

Andrew the SSMS Add In from http://www.ssmstoolspack.com/ *** the ability to script data easily from SSMS....

for a scripted solution , i've used this script from Narayana Vyas Kondreddi a lot,...

joe-1142036 (11/18/2011)

---

Thanks everyone for your help. I'm going to conclude that it can't be done with this particular hosting company. As pointed out, that's the drawback of shared...

PLSQL is very cursor oriented,where the same operation in can be redesigned to do the same work in a set based manner, which is typically several orders of magnitude faster...

my hosting company, for example, will do a backup and place it in the proper folder on my FTP site on demand; it's typically just an email away;

I'm fairlly certain...

if you are going to calculate this ont eh fly, i think this works:

--Results

/*

DateToTest LastBillingPeriodStartDate LastBillingPeriodEndDate ThisBillingPeriodStartDate ThisBillingPeriodEndDate

---------- -------------------------- ------------------------ -------------------------- ------------------------

2011-11-03 2011-10-15 00:00:00.000 2011-10-31 00:00:00.000 ...

so you want the Sunday that occurred before *today*, that would be the same code, but minus one isntead of minus 8, sorry i misunderstood the question.

for you, when does a week start? on Sunday, right?

this gives you the Monday of "this" week, regardless of the DATEFIRST parameter setting:

select DATEADD(wk, DATEDIFF(wk,0,getdate()), 0) As MondayOfThisWeek,

...

maybe it's just me, but if i tell someone from "The Outside World" that I'm a programmer, or that i work with computers, way to often I get asked if...

i think this will help;

look over the case statement, it will help you add an additional WHERe statement to find clustered vs non clustered.

SELECT OBJECT_NAME(object_id) AS TableName,

...