Viewing 15 posts - 61 through 75 (of 229 total)
Steve Jones - SSC Editor (5/6/2016)
Apologies for marking the wrong answer.Points have been awarded back to everyone as of now.
Sooo .. "thank God it's Friday" ?
May 6, 2016 at 12:01 pm
Toreador (5/6/2016)
May 6, 2016 at 11:58 am
Exactly what does upper management seek when choosing a mid-level manager?
If they only seek a suit to act as yes-man pushing down the ladder decisions made from high up it...
May 5, 2016 at 2:34 pm
Ian Elliott (5/1/2012)
I'm now back to being a support person again and have been pretty much told that I'll be in this role for the foreseeable future and that there...
May 5, 2016 at 2:25 pm
Yup, in a database designed by a third party, where some user added fields are labelled with a non human-significant (meaningful) name and filled with non-human significant uniqueidenitifier values, finding...
May 5, 2016 at 8:11 am
Marcia J (5/5/2016)
One advantage of looking at the question a day late. The STUFF had been stuffed in before I looked at the question.
:-D:-D:-D!
May 5, 2016 at 7:57 am
Forget "back points".
Those who got the right answer in spite of the defective code are entitled to BONUS points.
May 4, 2016 at 1:07 pm
Does this help you ? It works on my machine.
DECLARE @s-2 varchar(10) = CHAR(153);
INSERT INTO Table_1 (sometext)
SELECT @s-2 UNION ALL
SELECT '1' UNION ALL
SELECT @s-2...
May 4, 2016 at 12:07 pm
Lynn Pettis (5/4/2016)
edwardwill (5/4/2016)
I'd no more ask this person to administer my database than I'd ask Donald Trump to run my country.
Wow, you have your own country? Must be...
May 4, 2016 at 11:44 am
Ed Wagner (5/4/2016)
Lynn Pettis (5/4/2016)
Do this so many times I didn't catch that the STUFF function was missing. Got it right without it there.
Right there with you. The...
May 4, 2016 at 11:42 am
For "older" social security numbers, the range is LESS than the theoretical 1 billion numbers.
According to Wikipedia, the US Social Security Number does NOT include a check digit dependent upon...
May 4, 2016 at 9:55 am
I came up with a similar tool when trying to understand the structure of a database. Mine counts the number of occurrences of the searched item for each column in...
May 4, 2016 at 9:20 am
Luis C.
Could not repress a smile when I saw you dropping the bloody database at the end ...:-)
May 2, 2016 at 8:23 am
This thread has gotten so out of hand.
Can't we just have fun once in a while ? Being serious 100 % time - bleh !
I am curious to see how...
May 2, 2016 at 8:03 am
Can't help myself.
I am calling out every one to push this even further down the road.
Have we reached bottom yet ?
April 29, 2016 at 1:57 pm
Viewing 15 posts - 61 through 75 (of 229 total)