Viewing 15 posts - 661 through 675 (of 962 total)
Steve Jones - SSC Editor (4/24/2014)
GilaMonster (4/24/2014)
Steve Jones - SSC Editor (4/24/2014)
rodjkidd (4/23/2014)
Hope the op and recovery go well. You gotta make it over for SQL Bits.Rodders...
On the shed-dyule for...
April 24, 2014 at 11:00 am
Steve Jones - SSC Editor (4/24/2014)
rodjkidd (4/23/2014)
Hope the op and recovery go well. You gotta make it over for SQL Bits.Rodders...
On the shed-dyule for Bits, and planning on it. Can't...
April 24, 2014 at 11:00 am
Steve Jones - SSC Editor (4/23/2014)
rodjkidd (4/23/2014)
Grant,Forgot to say, I fly in Friday afternoon so can't make the SQL in the City, but have fun!
Rodders...
Enjoy, you two. Can't make this...
April 23, 2014 at 11:41 am
Grant,
Forgot to say, I fly in Friday afternoon so can't make the SQL in the City, but have fun!
Rodders...
April 23, 2014 at 11:21 am
Grant Fritchey (4/23/2014)
rodjkidd (4/23/2014)
I'm over for some more SQL Skills training, so thought I might as well attend.
Looks as...
April 23, 2014 at 10:45 am
Any of the Threadizens going to SQL Saturday in Chicago this weekend?
I'm over for some more SQL Skills training, so thought I might as well attend.
Looks as though a couple...
April 23, 2014 at 9:26 am
Steve Jones - SSC Editor (4/17/2014)
rodjkidd (4/17/2014)
Greg Edwards-268690 (4/16/2014)
WayneS (4/16/2014)
Steve Jones - SSC Editor (4/16/2014)
April 22, 2014 at 6:57 am
Greg Edwards-268690 (4/16/2014)
WayneS (4/16/2014)
Steve Jones - SSC Editor (4/16/2014)
April 17, 2014 at 3:22 am
Luis,
Thanks for that, I had a complete brain freeze on how to check for A-Z and a-z. I tried A-z - which was wrong. 🙂
I did also think there was...
April 3, 2014 at 10:25 am
Given that the OP's sample data includes spaces as well as numbers...
CREATE TABLE [dbo].[Names](
[Name] [varchar](200) NULL
) ON [PRIMARY]
INSERT INTO NAMES
VALUES ('22rajuvar'),
('45 vamsgui'),
('87 praveen'),
('67kumar'),
('32 vamshi')
SELECT REVERSE(LEFT(REVERSE(name), (PATINDEX('%[^a-z]%', REVERSE(NAME)))-1)) AS CleanedName
FROM...
April 3, 2014 at 8:07 am
I worked with one dev, when I did a bit dev, pity I don't do as mush I as I'd, we still use ON ERROR GOTO don't we?
Anyway it was...
April 2, 2014 at 2:36 am
So my friend has had an internal job move while on maternity leave. In fact she went back to find that her part of the telco business has been sold...
April 1, 2014 at 2:50 am
Sean Lange (3/31/2014)
Sean, neat wrapping it up in a proc, worth adding to a DB_Admin db.
Yep that's where I keep it. 😛
Cool.
Always find it funny when I start a new...
April 1, 2014 at 2:43 am
The Dixie Flatline (3/31/2014)
Ed Wagner (3/31/2014)
rodjkidd (3/31/2014)
Got an email from friend who was stuck on working out how many days old a debt is at...
March 31, 2014 at 3:43 pm
I do like paying it forward.
Got an email from friend who was stuck on working out how many days old a debt is at the end of the month, and...
March 31, 2014 at 12:57 pm
Viewing 15 posts - 661 through 675 (of 962 total)