StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POextracting certain part of string in SQL stored procedure
primarykey
Id
8164455
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-11-17T08:59:29.553
FavoriteCount
0
LastActivityDate
2011-11-17T13:24:03.617
LastEditDate
2011-11-17T09:11:08.820
LastEditorUserId
288747
OwnerUserId
1051364
ParentId
0
PostTypeId
1
Score
0
ViewCount
481
LastEditorDisplayName
text
Body
<p>I have this stored procedure at the moment. I would like to limit the String ChanceOfSuccess to only a the percentage like "40%". Right now the string reads something like this "40% - Thinking about it". What would be the best way to do this?</p> <pre><code>CREATE PROCEDURE [dbo].[procActivity_SelectbyOutstandingActivitiesNew] AS SELECT C.[Name] AS [Customer], C.CustomerId AS [CustomerID], E.FirstName + ' ' + E.Surname AS [Employee], AT.[TypeName] AS [Activity Type], A.[ActivityDate] AS ActivityDate, A.NextActivityDate, A.[ChanceOfSuccess] AS ChanceOfSuccess, A.[Comments] AS Comments, U.Surname + ' ' + U.FirstName AS [User], E.EmployeeId, A.ActivityId, CONVERT(INT, SUBSTRING(A.ChanceOfSuccess, 0, CHARINDEX ('%',A.ChanceOfSuccess))) AS [Success Percentage], A.[IsComplete] FROM Customer C INNER JOIN Activity A ON A.CustomerId = C.CustomerId INNER JOIN Employee E ON E.EmployeeId = A.EmployeeId AND E.CustomerId = C.CustomerId INNER JOIN [ActivityType] AT ON A.[ActivityTypeId] = AT.[ActivityTypeId] INNER JOIN [User] U ON A.[UserId] = U.[UserId] LEFT OUTER JOIN Activity A2 ON A.CustomerId = A2.CustomerId AND A.UserId = A2.UserId AND A2.ActivityDate > A.ActivityDate WHERE C.[IsDeleted] = 0 AND A.NextActivityDate <= GETDATE() AND E.IsDeleted = 0 AND A.IsDeleted = 0 AND (A2.ActivityId IS NULL OR A2.IsDeleted > 0) AND CONVERT(INT, SUBSTRING(A.ChanceOfSuccess, 0, CHARINDEX ('%',A.ChanceOfSuccess))) < 100 ORDER BY A.NextActivityDate ASC, Customer, A.ActivityDate ASC, [Success Percentage] DESC GO </code></pre>
Tags
<sql><string>
Title
extracting certain part of string in SQL stored procedure
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSeph
UserOwnerUserId
1. USuser1051364
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYou should really be storing the chance of success in a separate integer field. Also this question isn't anything related to stored procedures it's more about string manipulation and sub stringing
  singulars
  PostPostId
  POextracting certain part of string in SQL stored procedure
  UserUserId
  USSeph

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.