Viewing 15 posts - 271 through 285 (of 3,221 total)
No problrem with
SELECT left(ageatdeath,(len(ageatdeath)-5)) as [AGE_VAL], left(ageatdeath,2) AS [AGE_Units] FROM #DEATH
Yours:
SELECT left(ageatdeath,(len(ageatdeath)-5) as [AGE_VAL], left(ageatdeath,2) AS [AGE_Units] FROM DEATH
(len(ageatdeath)-5) -- yours
(len(ageatdeath)-5)) -- correct code
October 2, 2012 at 8:35 pm
Here is a start to obtain some if not most of what you require
October 1, 2012 at 10:39 am
Is this what you want / need ?
SELECT SUBSTRING(@x,28+CHARINDEX ('CustomerFornm: Changed from ',@x),CHARINDEX('CustomerDOB',@X,1)-77) AS 'Is this really what you
want?'
Result:
Is this really what you want?
Harry to Ben
September 30, 2012 at 7:41 pm
Duplicate question see
http://www.sqlservercentral.com/Forums/Topic1365565-3077-1.aspx
September 27, 2012 at 7:48 pm
There are many formats for EDI files ... generally set by the partners (sender & receiver). So like many things in SQL the phrase "It depends" applies to your...
September 27, 2012 at 7:44 pm
sanjay .... look at the following link and determine if you can alter the table definition to use on delete cascade
For example:
ALTER TABLE SalesHistory
ADD CONSTRAINT fk_SalesHistoryProductID FOREIGN KEY (ProductID)...
September 27, 2012 at 3:10 pm
I wonder who is responsible for checking the checkers .... what if the rogue individual works for the security firm. He/she becomes aware of a fault in the system...
September 27, 2012 at 2:52 pm
Unpleasantly surprised at the high number of incorrect answers:
Correct answers: 49% (196)
Incorrect answers: 51% (207)
Total attempts: ...
September 27, 2012 at 6:57 am
Nice question for the middle of the week - thank you
September 26, 2012 at 9:45 pm
Using the code from Jeff Moden's article:
DECLARE @OriginalString VARCHAR(70)
SET @OriginalString = 'karthik keyan ...
September 25, 2012 at 7:41 am
karthikeyan-444867 (9/24/2012)
bitbucket-25253 (9/24/2012)
This article explains the "puzzle solving" behind a common set based method to replace unknown numbers of...
September 24, 2012 at 9:59 pm
Your request concerned removing a single space, while Jeff's arcticle's objective was:
This article explains the "puzzle solving" behind a common set based method to replace unknown numbers of adjacent spaces...
September 24, 2012 at 11:55 am
Here is an individual looking for guidance on taking a certification exam. I above all or maybe that should be below all is the least qualified to give the...
September 23, 2012 at 2:52 pm
Viewing 15 posts - 271 through 285 (of 3,221 total)