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,

...

with GoDaddy being shared hsoting, you get SQL users only for access to your SQL instance.

you might consider storing...

make sure the string is a single line when sent to the cmd :

create table #Results (

ID int identity(1,1) NOT NULL,

TheOutput varchar(1000))

declare @cmd as varchar(8000)

set @cmd = ' ren c:\sgrs\SGRS_SGCTCentral_7_20111111102846.rar...

email is raw text mode or html mode?

is that a static footer/email, or are the elements pulled dynamically in a SQL statement?

SQLRNNR (11/17/2011)

---

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to where the DBA falls...

for me, there's serveral flavors of DBA's..there sthe DBA that does what yuo are probably doing...mostly administrative, handling backups, traces and the servers themselves.

a Development DBA, which (for me anyway)...

Charmer (11/17/2011)

---

i have two tables....1st one has columns name RlseId and a datetime column..

2nd table has TrackID(primary key,automatic generated) , RlseId(foreign key of 1st table) and RlsTrackId...but no date time...

in that case, i usually just do a SELECT * INTO table_Bak

FROM Table;

with that it's very easy to update the original table from that side by side table in the...