Viewing 15 posts - 196 through 210 (of 3,221 total)
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...
December 18, 2012 at 9:54 pm
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,'(',''),')','-')
...
December 16, 2012 at 2:43 pm
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 =...
December 16, 2012 at 8:58 am
gloing73 (12/15/2012)
===== 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...
December 15, 2012 at 9:18 pm
In addition to robert.gerald.taylor's post, also start reading the STAIRWAYS articles here on SSC.
December 15, 2012 at 9:12 pm
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...
December 15, 2012 at 9:06 pm
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...
December 12, 2012 at 9:07 am
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...
December 4, 2012 at 7:11 am
This might be what you are looking for:
Check out Brandie Tarvin blog posting at:
Let’s start with precedence. 2 + 3 = 5. And 2 + 3 – 4 will always...
December 3, 2012 at 5:09 pm
sivashankarcheruku (12/2/2012)
hii tried to install sql server 2008r2 in mixed mode any one help on this.
Exactly what did you do (step by step) ?
What error message(s) or error(s) did you...
December 2, 2012 at 8:31 pm
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...
December 1, 2012 at 6:56 am
Rather late in getting around to attempt to answer this particular QOD and
Correct answers: .. 30% (164)
Incorrect answers: 70% (376)
Total attempts: ...
November 30, 2012 at 4:34 pm
Viewing 15 posts - 196 through 210 (of 3,221 total)