Here's my version of a Calendar table;

I put a bit of time into it putting in various US holidays, which might be of some help as well.

my date range is...

well this kind of gets you the data chopped up into the pieces youa r elooking for;

i'm using the famous DelimitedSplit8K you'll find links to in many posters signitures, and...

if you know it will always be a delete and truncate, vs a merge, i'd import into a new table, and when the import was complete, rename the original table...

You could add me to a review list; I'd like to see something like an email or page where us "volunteers" go and review potential QOTD periodically, and after it's...

for me, there's different "flavors" of DBA's.

i have this saved in my snippets;

i recommend reading each of the articles, and test yourself/grade yourself on what you know how to do...

take a look at this peer acclaimed solution to backups.

http://ola.hallengren.com/sql-server-backup.html

aside from that, it doesn't matter what you use, unless you test the backups after it was completed.

running the backups is...

wierd;

i cannot get a trace to be created with either the options or the filename to be null;

it's wierd that you are able to see that.

i tried stuff like stopping...

back to the first suggestions: get with your mail administrator; tell him the IP address /machine name and account you are trying to use so he can allow relaying.

after he...

include all the columns, but blank them out based on permissions is what i would recommned.

something like this?

SELECT

SomeColumns,

CASE

WHEN IsSalesman...

I've certainly done non-reporting services HTML reports via sprocs and mailed them, is that what you are after?

the trick is to build an html string, and use FOR XML to...

can't say for sure;...

As derek and anthony identified, it'll be an issue with your mail server not allowing relaying; it's an anti spam feature.

relaying is forwarding/sending emails to a domain outside of the...

the real data might be a little more complex, but doesn't a simple group by get you the data you asked for?

/*

OrderNumber Item Fee

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

52 ...

BULK insert does not allow variables , nor will it allow concatention to create the file name;

BULK INSERT BULKACT FROM 'c:\Export_o.txt' --valid

BULK INSERT BULKACT FROM 'c:\' + @path --error

BULK INSERT...

was this even close remotely what you were looking for?