...also lee's used his "second irony quote" elsewhere on this site..and that is an absolute NO NO...read the rule book...

what - you mean you don't have one yet ?!

Farrell - it certainly sounds like you haven't gone on the much-needed vacation yet...

maybe we should have the siteowners stipulate that unless you do...

look up BOL "aggregate functions"...there're a couple of functions dealing with standard deviation...stddev() etc...

On behalf of the site-owners and all of us - GPF^...is hereby awarded a "citation for irony" - ironically enough awarded sight-unseen...

remi - stop being so picky - all GPF^...means...

If you have a large number of tables to modify, you would be better off dropping the replication - making your changes and then creating it again...if it's only a...

Rajesh - the point I was trying to make is that for an ambiguous column name - you would HAVE TO explicitly use tableName - but it need not be...

well I've certainly been "got" as I completely missed the reference (SUSE ?!?!?!?!?!)...

as for "sushi" - I've been called that often - but only by fishy people with a propensity...

I must add here - "unless you have the typing speed of the RG"...for I notice that in the 3 minutes that it took me to type this out...remi's already...

Rajesh - Remi's already (kinda) addressed the second point...as for the first - can't think how it would be resolved unless you explicitly spell out tableName.columnName when there is ambiguity...

praveen - SSC.com is a pretty comprehensive site - even for articles - have you checked them out yet ?!?!

As for making it a "funny thing" - it's a good...

tooting your own horn Phill ?!?! you may just have your friend "HeWhoMustNotBeNamed" accuse you once again of trying to increase your post count! "any thoughts....if not complete answer" even when no questions are asked and no reponses...

In my defense...I should've qualified my statement with "not allowed in this particular instance"...but you said it so much better David with your explanation of scalar & table-valued - wish...

Austin - it would be helpful if you could provide some samples from your "birth_date" column...

You may be able to do something like this..substituting the dates with the name of...

If I were to hazard a guess it would be that the culprit is getdate() itself since it is a non-deterministic function...don't think this is "allowed"...