Viewing 15 posts - 6,181 through 6,195 (of 9,399 total)
palotaiarpad (4/26/2015)
If we assume, that we have the latest SQL Server Version (2014), then an over by is required according to BOL (I can't try it yet)
Others have shown BOL...
April 27, 2015 at 5:39 am
You could add an "OR p1.IsProfilePic IS NULL" to your WHERE clause. However, because your User_Photos.IsProfilePic column can be NULL, this could pose a problem when the User_Photos table...
April 25, 2015 at 8:38 am
I wish we did code reviews. I sometimes have others sit down with me and review my code, but usually when it's something new or when they might have...
April 25, 2015 at 8:25 am
I've always approached DBA tasks with the heart of a developer who loves automation. Granted, I don't look at data like that, but that's a different conversation. 😉
When it...
April 25, 2015 at 8:20 am
BOR15K (4/24/2015)
Without the DDL for the table(s) and sample data, how do you expect us to help with the code you need? We can't see what you unless you...
April 25, 2015 at 8:06 am
Eirikur Eiriksson (4/24/2015)
April 25, 2015 at 7:45 am
I hope all goes well with your hardware replacement.
April 25, 2015 at 7:42 am
The problem is in your WHERE clause. You're filtering for the profile picture, but if the outer join doesn't return a row, the value is NULL. The NULL...
April 25, 2015 at 7:41 am
Sean Lange (4/24/2015)
cerian (4/24/2015)
Mark Cowne (4/24/2015)
Have a look hereGreat, thanks, as much as this answer was over-complicated from what we needed, the function he mentions does exactly what we need
I...
April 24, 2015 at 10:38 am
Eirikur Eiriksson (4/24/2015)
crookj (4/24/2015)
Eirikur Eiriksson (4/24/2015)
Ed Wagner (4/24/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
crookj (4/23/2015)
Ed Wagner (4/23/2015)
Revenant (4/23/2015)
djj (4/23/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
April 24, 2015 at 7:52 am
I figured there would be a trick to it too. Like Alex pointed out, it's good to know I can't do it by mistake.
April 24, 2015 at 6:55 am
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
crookj (4/23/2015)
Ed Wagner (4/23/2015)
Revenant (4/23/2015)
djj (4/23/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
Dungeons
Master
Game
Theory
Relativity
Time
Travel
4th
Wormhole
Service pack
Risk
April 24, 2015 at 5:42 am
crookj (4/23/2015)
Ed Wagner (4/23/2015)
Revenant (4/23/2015)
djj (4/23/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
Dungeons
Master
Game
Theory
Relativity
Time
Travel
4th
Wormhole
April 23, 2015 at 12:56 pm
Revenant (4/23/2015)
djj (4/23/2015)
Eirikur Eiriksson (4/23/2015)
Ed Wagner (4/23/2015)
djj (4/23/2015)
TomThomson (4/22/2015)
Eirikur Eiriksson (4/22/2015)
djj (4/22/2015)
Eirikur Eiriksson (4/21/2015)
SQLRNNR (4/21/2015)
fecal fabric flinging fairiesPixie Dust
Neverland
Dragons
Dungeons
Master
Game
Theory
Relativity
Time
Travel
April 23, 2015 at 9:37 am
Viewing 15 posts - 6,181 through 6,195 (of 9,399 total)