Viewing 15 posts - 331 through 345 (of 1,243 total)
peter478 (12/5/2016)
Thank you , btw. sometimes has column2 value = NULL and result is also NULL. I this case I want to put date from column1.
CASE
WHEN column1 >= ISNULL(column2,Column1)
THEN...
December 5, 2016 at 3:56 am
Lynn Pettis (12/2/2016)
ThomasRushton (12/2/2016)
Lynn Pettis (12/1/2016)
For someone who has been "around" SSC as long as "he" has, he sure hasn't changed in all these years.
Let me guess - this is...
December 5, 2016 at 1:14 am
Luis Cazares (12/1/2016)
Lynn Pettis (12/1/2016)
I stayed away and thinking I will...
December 2, 2016 at 1:59 am
crookj (12/1/2016)
Manic Star (12/1/2016)
Ed Wagner (12/1/2016)
TomThomson (11/30/2016)
Ed Wagner (11/30/2016)
Manic Star (11/30/2016)
Ed Wagner (11/30/2016)
Kaye Cahs (11/30/2016)
ZZartin (11/30/2016)
Revenant (11/30/2016)
aPed001 (11/30/2016)
ConstitutionConstellation
Pelt
Fur
Coat
Fuzzy
Warm
Hot
Stove
Oven
Range
Rover
December 1, 2016 at 6:47 am
ThomasRushton (11/24/2016)
BLOB EATER (11/24/2016)
GilaMonster (11/24/2016)
Brandie Tarvin (11/24/2016)
Much prefer chocolate or herbal tea (decaf).
The office kitchen also caters to stranger tastes, with 3 types of tea (two black tea variants and...
November 24, 2016 at 7:52 am
Does this do what you want?
SELECT
VisitID
FROM #Test t
WHERE NOT EXISTS(
SELECT 1 FROM #Test t1
WHERE t1.IsPrimaryCareProvider ='Y'
AND t1.VisitID = t.VisitID
)
GROUP BY
VisitID
November 23, 2016 at 7:18 am
Beatrix Kiddo (11/23/2016)
Alan.B (11/22/2016)
I just deleted a table named dbo.deleteme from our Dev box. This upset some people. Nothing surprises me anymore.Impossible to resist :-D!
There used to be a folder...
November 23, 2016 at 2:04 am
TomThomson (11/22/2016)
BWFC (11/18/2016)[hrI wrote steak because I was so excited about the steaks that are arriving tomorrow I got carried away. I think on reflection you're right that it...
November 23, 2016 at 1:20 am
Ed Wagner (11/22/2016)
djj (11/22/2016)
Ed Wagner (11/22/2016)
djj (11/22/2016)
Hugo Kornelis (11/22/2016)
Brandie Tarvin (11/22/2016)
Ed Wagner (11/21/2016)
Manic Star (11/21/2016)
Grumpy DBA (11/21/2016)
Luis Cazares (11/21/2016)
djj (11/21/2016)
HighMile
Club
Sandwhich
Sub
Station
Train
Locomotive
Transport
Trainspotting
Cow-tipping
Fly-tipping
November 22, 2016 at 6:13 am
Grumpy DBA (11/21/2016)
BWFC (11/21/2016)
Ed Wagner (11/21/2016)
firemanbens6 (11/18/2016)
Ed Wagner (11/18/2016)
SnakePlissken
New York
New York
Escape
Character
November 21, 2016 at 6:39 am
Ed Wagner (11/21/2016)
firemanbens6 (11/18/2016)
Ed Wagner (11/18/2016)
ZZartin (11/18/2016)
djj (11/18/2016)
Manic Star (11/18/2016)
Grumpy DBA (11/18/2016)
Ray K (11/18/2016)
LowBall
Foot
Ankle
Biter
Snake
Plissken
New York
New York
November 21, 2016 at 5:26 am
Ed Wagner (11/18/2016)
BWFC (11/18/2016)
November 18, 2016 at 7:38 am
Ed Wagner (11/18/2016)
Hugo Kornelis (11/18/2016)
DamianC (11/18/2016)
soupof the Day
Lunch
Soon
November 18, 2016 at 5:45 am
I've not tried it yet but it's definitely on the agenda. The next thing on the curing list is a ham. Hopefully I've not left it too late to...
November 18, 2016 at 2:35 am
ChrisM@Work (11/18/2016)
Eirikur Eiriksson (11/18/2016)
BWFC (11/18/2016)
TomThomson (11/17/2016)
BWFC (11/16/2016)
Sean Lange (11/15/2016)
Ed Wagner (11/15/2016)
Y.B. (11/15/2016)
That being said I did recently...
November 18, 2016 at 2:20 am
Viewing 15 posts - 331 through 345 (of 1,243 total)