Phew!!!! For some time I thought my responses were visible only to me and no one else...okay - so long as we're all talking the same language I'm fine...I only...

okay - I'm going to ask for one LAST time and then forever hold my peace....

if the data is ALWAYS going to be full DOB or Year (as poster indicated)...what...

The best way to do this is to have a copy of the client's database that you can work with - you then run all the scripts, updates etc. testing...

Also, here's something else to "chew on" from BOL....

"COMPUTE and COMPUTE BY are supported for backward compatibility. The ROLLUP operator is preferred over either COMPUTE or COMPUTE BY. The summary...

you have to have an aggregate function on the column that you are selecting (max, min, avg etc...) when you do a "group by"....in other words, the selected column should...

If it's ONLY the full DOB OR just the year, what's the argument against storing the YEAR ONLY value as a '01/01/yyyy' and using the flag indicator to specify that...

I can't test this out right now but I was wondering if it would not be better to convert it to money datatype instead of float - after all, we...

Hans - for the extra cents that you threw in, maybe Ann should go with checking ascii values....

SELECT @myNum = CASE WHEN ISNUMERIC(@myCol) = 1 AND ASCII(@myCol) >= 48 AND...

...except that the # of available days is 4 and not 3 as poster says...so maybe I don't understand either ?!

I think the first query is something like:

select * from periods

where fromdate >= '2005-07-01' and until = 1) -

(select (DATEDIFF(d, '2005-07-07', until) + 1) from periods

where until > '2005-07-07' and...

Remi - this may not be "wrong" data necessarily - it could be DOB or year of birth!

Since you already have a date field you could use it to store...

Yeah! Dawn of a new era ??? This could only be the beginning of everything as it should be about certifications and testing skills!

Wonder if scc.com had (at the very...

Here's something from one of my favourite SQL books from the chapter on database design...Robert Vieira ("SQL Server 2000 Programming") - (Normalization & other basic design issues):

"Choose what you need,...

There are any number of ways to do this but you would basically be using LOWER() for the field in all but the first character - and if you have...

The response to this from Canadian GPF^... is going to be interesting because I have it on good authority that with this country the choices are so many that even...