C-SPAN it is then...

this may just be the 3rd post in as many weeks on this..

text truncated at 256

- not quite sure what "dinged" means but it sounds very "assaulty"...and sswords - if you were addressing me then no -...

..those all the thoughts you have?!?!?!

Just a note...Islam is not to blame...it's the "interpretations"...

Assuming U.S date format you could try something like this...substituting the getdate() with your date...

set datefirst 7
select convert(varchar, (getdate() - DATEDIFF(dd, datepart(dw, getdate()), @@datefirst)), 101)

Random thoughts...

so freedom of speech is not to be confused with speaking the truth for isn't truth only a perception...

you voice your opinion and...

Henry - glad you were able to work it out...as for updating the email addresses - you don't need a separate "where exists..."....just add "and TableB.NewEmail is not null" to...

If you're sure that all your phone #s are valid, correct, of fixed length & formatted the exact same way in all the rows you could do some string manipulation...

Rohit - couple of things...

1) Your variable is obviously not storing anything - a quick PRINT @varName should confirm this for you.

2) Why're you using "distinct" to select column names...

maybe someone changed the settings in QA....go to "Tools"..."Options"...."Fonts" tab and check to see what the settings are for "Keyword"...set the "Foreground" to blue...

Follow thread here

Take a look at this...

text file truncated at 256

To conclude then...

Even though different dates were being used, since the syntax was incorrect, SQL Server was storing (or trying to) store the dates as..1900-01-01 00:00:00.000

- hence the "primary...

suggestion - why not use your pc_id in your org_type table instead of function_code and cmd_code ?!