How about setting a trigger on the blogs table of "freeads" to insert into table in "today"?!?!

Juanita - you should use cast or convert to retrieve your date...with "convert" you can use formatting styles...

select convert(varchar, getdate(), 101)

Why GPF2^...what a very nice "counselling" post....

Loner - Happy B'day (even though so belated) - if it's any consolation, there're very few husbands (& sons) out there who remember days...

Robert - I subscribe to another site that had this new tool on their homepage today...sounds like exactly what you (& all of us) need...

sqldbcontrol

If you get the chance...

Chandrika - if I understand you correctly, then you cannot do a select into...where the table would just automatically take on the # of columns, datatypes etc. from the table...

Many of us have family "histories" that start preying on our minds as we grow older...Didn't really read that article on retirement that you posted but I know that for...

I also believe that these used to be called global variables (2 "at at"s as opposed to the local single "at") and have since transitioned over to being (called) functions...

Tim - applause from the stands - just for the sheer brevity of the solution when compared to the convolutions that Jules was contemplating...

oops..was I not subtle enough ?!

David - was just kidding around...wasn't really miffed - no need for an apology.

You're absolutely right about there being zero training around for MS SQL Server...if at all, the ratio between training for Oracle and training for MS SQL is about a 100...

I'm still laughing over "..working with rats has helped me deal with senior management in some of the companies in my working past"..

However, am...

Didn't read Scott's response before posting mine, but this is about it..the bottom line...

"...for the price of one of me they got 2 of them and a manager to do...

Steve - I thought you'd find this interesting....I have an India Link where the same course offered by you guys is being conducted in India for Rs.5612/- (inclusive of...

hmm...my understanding is more like this:

psuedocode...

if exists(select * from table1 where....)
   begin
   update table1....
if exists(select * from table1 join table2 on table1.ID = table2.fID)
begin
 ...

would I lead you wrong...yes, that's exactly what I was suggesting...do give it some serious thought..