Can not accurately recall the time taken but do remember reading the complete works of William Shakespeare in one long, long session started in late afternoon and finished up the...

Nice back to basics question - thanks

If you would like to follow Jeff Moden's suggestion (advice) then this might be what you need

DECLARE @homephone VARCHAR(20)

SET @homephone='(999)888-7777'

SET @homephone = REPLACE(replace(@homephone,'(',''),')','-')

...

Is this what you require:

DECLARE @homephone VARCHAR(20)

SET @homephone='(xxx) xxx-xxxx'

SET @homephone = (select replace(@homephone,'(',''))

set @homephone = replace(@homephone,')','-')

set @homephone =...

gloing73 (12/15/2012)

---

very good website:

===== http://www.globalmarket.name// =====

The website wholesale for many kinds of fashion shoes, like the nike, jordan, prada, also including the jeans, shirts, bags, hat and the...

In addition to robert.gerald.taylor's post, also start reading the STAIRWAYS articles here on SSC.

You are very aware of your problem, but without the table definition, the updating TSQL, and the trigger definitions. It is very, very difficult for those who wish to...

Thanks for reminding me of the basics ....

Just a wild idea, but when writing triggers I tend to be rather specific in specifying when they fire for example:

Create trigger orders_update_inventory on orders

for update

As I...

Nice back to basics question - thanks

My apologies to all .....

1. I did test the code multiple times ...

2. When testing the ; was NOT present.

3. I can only guess, but...

This might be what you are looking for:

Check out Brandie Tarvin blog posting at:

https://www.google.com/reader/view/?hl=en&tab=my#stream/feed%2Fhttp%3A%2F%2Fbrandietarvin.livejournal.com%2Fdata%2Frss

Let’s start with precedence. 2 + 3 = 5. And 2 + 3 – 4 will always...

Exactly what did you do (step by step) ?

What error message(s) or error(s) did you...

I am not sure that I understand your question correctly, but here is what I think you are looking for.

;WITH CTE as (select row_number() OVER(partition by Binder_no ORDER...

Rather late in getting around to attempt to answer this particular QOD and

Correct answers: .. 30% (164)

Incorrect answers: 70% (376)

Total attempts: ...