Viewing 15 posts - 646 through 660 (of 1,111 total)
January 16, 2017 at 6:53 am
January 13, 2017 at 6:50 am
djj...
January 12, 2017 at 6:49 am
Ed Wagner (1/11/2017)
Manic Star (1/11/2017)
djj (1/11/2017)
Ed Wagner (1/11/2017)
djj (1/11/2017)
whereisSQL? (1/11/2017)
Kaye Cahs (1/11/2017)
Revenant (1/11/2017)
djj (1/11/2017)
whereisSQL? (1/11/2017)
Hugo Kornelis (1/11/2017)
Ed Wagner (1/11/2017)
Grumpy DBA (1/11/2017)
Manic Star (1/11/2017)
StoryNarrative
Subtext
Actor
Director
Producer
Grower
Reaper
Grim
Happy
Birthday
Party
Clown
Stephen King
(dark) Tower
January 11, 2017 at 1:51 pm
djj (1/11/2017)
Ed Wagner (1/11/2017)
djj (1/11/2017)
whereisSQL? (1/11/2017)
Kaye Cahs (1/11/2017)
Revenant (1/11/2017)
djj (1/11/2017)
whereisSQL? (1/11/2017)
Hugo Kornelis (1/11/2017)
Ed Wagner (1/11/2017)
Grumpy DBA (1/11/2017)
Manic Star (1/11/2017)
StoryNarrative
Subtext
Actor
Director
Producer
Grower
Reaper
Grim
Happy
Birthday
Party
Clown
January 11, 2017 at 1:10 pm
If you are comfortable using PowerShell, it has pretty decent Json support. You could wire up a script to connect to your SQL server, retrieve the data you need...
January 11, 2017 at 7:01 am
ThomasRushton (1/11/2017)
GilaMonster (1/11/2017)
ThomasRushton (1/11/2017)
You could also use
SELECT FORMAT(10.500,'N1')
Although FORMAT is extremely slow compared to CONVERT.
https://sqlperformance.com/2015/06/t-sql-queries/format-is-nice-and-all-but
Good point.
Mind you, this sort of formatting should be done away...
January 11, 2017 at 6:46 am
Ed Wagner (1/11/2017)
DamianC (1/11/2017)
djj (1/11/2017)
Stuart Davies (1/11/2017)
whereisSQL? (1/10/2017)
Manic Star (1/10/2017)
djj (1/10/2017)
ZZartin (1/10/2017)
Revenant (1/10/2017)
Ray K (1/10/2017)
djj (1/10/2017)
Ed Wagner (1/10/2017)
crookj (1/10/2017)
djj (1/10/2017)
Kaye Cahs (1/10/2017)
djj (1/10/2017)
Grumpy DBA (1/10/2017)
Ed Wagner (1/10/2017)
Truth(or) Dare
Care
Bear
Hair
Cowsills
Band (and yes,...
January 11, 2017 at 6:40 am
djj (1/10/2017)
ZZartin (1/10/2017)
Revenant (1/10/2017)
Ray K (1/10/2017)
djj (1/10/2017)
Ed Wagner (1/10/2017)
crookj (1/10/2017)
djj (1/10/2017)
Kaye Cahs (1/10/2017)
djj (1/10/2017)
Grumpy DBA (1/10/2017)
Ed Wagner (1/10/2017)
Truth(or) Dare
Care
Bear
Hair
Cowsills
Band (and yes, I had to look it up :-P)[djj](youngster):-D[/djj]
Head
Tail
Comet
Bowl
Mortar
Brick
January 10, 2017 at 2:12 pm
whereisSQL? (1/9/2017)
Ed Wagner (1/9/2017)
Grumpy DBA (1/9/2017)
Revenant (1/9/2017)
Ed Wagner (1/9/2017)
QualityJapan
Recall
Denial
Acknowledge
Ignore
January 9, 2017 at 1:11 pm
eccentricDBA (1/9/2017)
Ed Wagner (1/9/2017)
DamianC (1/9/2017)
Ed Wagner (1/9/2017)
Ray K (1/6/2017)
Manic Star (1/4/2017)
ZZartin (1/4/2017)
Terminator(I'll Be) back
front
Assault
rifle
Range
Home (on the Range)
Deer
January 9, 2017 at 8:50 am
ZZartin (1/4/2017)
Revenant (1/4/2017)
Ray K (1/4/2017)
djj (1/4/2017)
whereisSQL? (1/4/2017)
Manic Star (1/4/2017)
djj (1/4/2017)
whereisSQL? (1/3/2017)
Ed Wagner (1/3/2017)
Revenant (1/3/2017)
whereisSQL? (1/3/2017)
Ed Wagner (1/3/2017)
djj (1/3/2017)
Grumpy DBA (1/3/2017)
Kaye Cahs (1/3/2017)
RepentEnd (is near)
Finally
Done
Do
Dodo
Bird
Word
Communicate
Obfuscate
Simplify
Nullify
ISNULL
COALESCE
Terminator
(I'll Be) back
January 4, 2017 at 1:04 pm
djj (1/4/2017)
whereisSQL? (1/3/2017)
Ed Wagner (1/3/2017)
Revenant (1/3/2017)
whereisSQL? (1/3/2017)
Ed Wagner (1/3/2017)
djj (1/3/2017)
Grumpy DBA (1/3/2017)
Kaye Cahs (1/3/2017)
RepentEnd (is near)
Finally
Done
Do
Dodo
Bird
Word
Communicate
Obfuscate
January 4, 2017 at 6:48 am
Ed Wagner (1/3/2017)
crookj (1/3/2017)
ThomasRushton (1/1/2017)
Revenant (1/1/2017)
Ed Wagner (12/31/2016)
DamianC (12/30/2016)
Manic Star (12/30/2016)
djj (12/30/2016)
ThomasRushton (12/30/2016)
crookj (12/30/2016)
Manic Star (12/30/2016)
Luis Cazares (12/29/2016)
Revenant (12/29/2016)
Grumpy DBA (12/29/2016)
jasona.work (12/29/2016)
PigBacon
Kevin
McCallister
Kilt
Pipes
Peace
...and I hope that's earwormed you with Paul McCartney's...
January 3, 2017 at 7:03 am
djj (12/30/2016)
ThomasRushton (12/30/2016)
crookj (12/30/2016)
Manic Star (12/30/2016)
Luis Cazares (12/29/2016)
Revenant (12/29/2016)
Grumpy DBA (12/29/2016)
jasona.work (12/29/2016)
PigBacon
Kevin
McCallister
Kilt
Pipes
Peace
...and I hope that's earwormed you with Paul McCartney's Pipes of Peace.
Hope
Understanding
December 30, 2016 at 2:34 pm
Viewing 15 posts - 646 through 660 (of 1,111 total)