Viewing 15 posts - 271 through 285 (of 5,590 total)
JoseMenendez (8/29/2015)
August 29, 2015 at 8:54 pm
Joe-420121 (8/29/2015)
August 29, 2015 at 8:24 pm
drew.allen (8/28/2015)
August 28, 2015 at 6:27 pm
Just be careful. Looking at this, the first thing that pops into my head is
SQL INJECTION
August 28, 2015 at 6:05 pm
Lynn Pettis (8/13/2015)
WayneS (8/13/2015)
Do you think it would be beneficial to create an Oracle thread? (Would it actually work?)
Or a...
August 13, 2015 at 12:15 pm
Why is it SQLServerCentral gets so many Oracle questions on it?
Do you think it would be beneficial to create an Oracle thread? (Would it actually work?)
Or a banner on pages...
August 13, 2015 at 11:35 am
SQLRNNR (8/13/2015)
GilaMonster (8/13/2015)
Views upon views upon #$%$%^%$#$ views! The same damn table is getting queried 8 times.
I am dealing with that with a few clients.
Then they sit there and wonder...
August 13, 2015 at 10:13 am
Lynn Pettis (8/13/2015)
jodevil99 (8/13/2015)
John Mitchell-245523 (8/13/2015)
Another way of doing it:
SELECT A, B, C, 'Text 1' MyTextFROM MyTable
UNION ALL
SELECT A, B, C, 'Text 2'
FROM MyTable
John
Thank you John, that worked very well.
Thank...
August 13, 2015 at 10:07 am
Sean Lange (8/13/2015)
Lynn Pettis (8/13/2015)
Ed Wagner (8/13/2015)
I've worked in both environments and really prefer case-insensitive. As a habit, though, I try to write everything as case-sensitive.
Having been working in...
August 13, 2015 at 9:21 am
jodevil99 (8/13/2015)
The first one tells me I lack a "FROM" clause (and underlines union to identify where's the mistake)
The second one says it...
August 13, 2015 at 9:16 am
Luis Cazares (8/13/2015)
Ed Wagner (8/13/2015)
eccentricDBA (8/13/2015)
whereisSQL? (8/13/2015)
Ed Wagner (8/13/2015)
Luis Cazares (8/13/2015)
djj (8/13/2015)
QueueWait
Disk
Storage
array
Pointer
Beagle
Bros.
August 13, 2015 at 9:10 am
August 13, 2015 at 9:08 am
jeff.born (8/12/2015)
Unfortunately the fact that you can currently partition by first and name last is a fluck. Usually the names will be spelt differently which is why the contacts...
August 12, 2015 at 6:59 pm
staticlie (8/12/2015)
August 12, 2015 at 2:50 pm
Ed Wagner (8/12/2015)
Ed Wagner (8/12/2015)
SQLRNNR (8/12/2015)
whereisSQL? (8/12/2015)
Ed Wagner (8/12/2015)
Eirikur Eiriksson (8/12/2015)
Ed Wagner (8/12/2015)
Steve Jones - SSC Editor (8/12/2015)
brokeSpending
spree
Candy
Crush
saga :crying:
Series
Fibonacci
Sequence
August 12, 2015 at 1:59 pm
Viewing 15 posts - 271 through 285 (of 5,590 total)