Viewing 15 posts - 5,716 through 5,730 (of 8,761 total)
Jeff Moden (4/7/2015)
April 7, 2015 at 3:28 pm
Alan.B (4/7/2015)
I have smacked myself in the head to save everyone else the trouble. (not my day)...
Happy to help, need a HAND!:-P
😎
April 7, 2015 at 2:41 pm
eccentricDBA (4/7/2015)
Eirikur Eiriksson (4/7/2015)
Ed Wagner (4/7/2015)
Eirikur Eiriksson (4/7/2015)
djj (4/7/2015)
Ed Wagner (4/7/2015)
whereisSQL? (4/7/2015)
Eirikur Eiriksson (4/7/2015)
whereisSQL? (4/7/2015)
Ed Wagner (4/7/2015)
Revenant (4/7/2015)
djj (4/7/2015)
eccentricDBA (4/6/2015)
Eirikur Eiriksson (4/6/2015)
SQLRNNR (4/6/2015)
timberSplinter
Shredder
Raphael
Renaissance
Knight
Bishop
Finger
Salute
Attention
Distraction
Details
Summary
Executive
Order
Misconception
April 7, 2015 at 2:27 pm
Quick suggestion, can you edit your post so the DDL and sample data is runnable? (create table and insert)
😎
April 7, 2015 at 1:44 pm
Luis Cazares (4/7/2015)
It's easy to test this formula, but that's just the tip of the iceberg on this process. 🙂
I know all about Icebergs 😀
😎
April 7, 2015 at 1:33 pm
Luis Cazares (4/7/2015)
However, I'll stay with the original because I was trying to improve...
April 7, 2015 at 1:22 pm
Ed Wagner (4/7/2015)
Eirikur Eiriksson (4/7/2015)
djj (4/7/2015)
Ed Wagner (4/7/2015)
whereisSQL? (4/7/2015)
Eirikur Eiriksson (4/7/2015)
whereisSQL? (4/7/2015)
Ed Wagner (4/7/2015)
Revenant (4/7/2015)
djj (4/7/2015)
eccentricDBA (4/6/2015)
Eirikur Eiriksson (4/6/2015)
SQLRNNR (4/6/2015)
timberSplinter
Shredder
Raphael
Renaissance
Knight
Bishop
Finger
Salute
Attention
Distraction
Details
Summary
Executive
April 7, 2015 at 1:14 pm
Steve Jones - SSC Editor (4/7/2015)
Everyone bow their head in a moment of silence.'14-'15 ski season is over.
Powder?
April 7, 2015 at 1:05 pm
Rune Bivrin (4/7/2015)
The FIRSTROW attribute is not...
April 7, 2015 at 1:02 pm
djj (4/7/2015)
Ed Wagner (4/7/2015)
whereisSQL? (4/7/2015)
Eirikur Eiriksson (4/7/2015)
whereisSQL? (4/7/2015)
Ed Wagner (4/7/2015)
Revenant (4/7/2015)
djj (4/7/2015)
eccentricDBA (4/6/2015)
Eirikur Eiriksson (4/6/2015)
SQLRNNR (4/6/2015)
timberSplinter
Shredder
Raphael
Renaissance
Knight
Bishop
Finger
Salute
Attention
Distraction
Details
April 7, 2015 at 12:55 pm
whereisSQL? (4/7/2015)
Ed Wagner (4/7/2015)
Revenant (4/7/2015)
djj (4/7/2015)
eccentricDBA (4/6/2015)
Eirikur Eiriksson (4/6/2015)
SQLRNNR (4/6/2015)
timberSplinter
Shredder
Raphael
Renaissance
Knight
Bishop
Finger
April 7, 2015 at 11:57 am
Eric M Russell (4/7/2015)
April 7, 2015 at 9:04 am
JustMarie (4/7/2015)
April 7, 2015 at 9:00 am
BOR15K (4/7/2015)
WITH myString AS (
SELECT '001' AS num
UNION ALL
SELECT '002' AS num
UNION ALL
SELECT '003' AS num
UNION ALL
SELECT '001.' AS num
UNION ALL
SELECT '004' AS num
UNION ALL
SELECT '002.' AS...
April 7, 2015 at 8:58 am
Luis Cazares (4/7/2015)
Thank you both for your solutions.
I would be careful using my version if the initial number of digits goes below 5 but hey! you can figure that one...
April 7, 2015 at 8:53 am
Viewing 15 posts - 5,716 through 5,730 (of 8,761 total)