Forum Replies Created
Viewing 15 posts - 76 through 90 (of 2,452 total)
-
RE: Are the posted questions getting worse?
Lynn Pettis - Friday, November 17, 2017 8:52 AM -
RE: Query to give sum of items with condition from multiple tables
rosarozina - Tuesday, November 14, 2017 4:24 PMlook forward to it....
-
RE: Fastest way to look for a word from a string matching a list of words in a lookup table
maybe a set up script that creates the tables and inserts some simple sample data and also the expected results would help......you have had many views and only one reply.
-
RE: splitting column into two
alhakimi - Sunday, September 3, 2017 1:26 PM -
RE: splitting column into two
alhakimi - Sunday, September 3, 2017 1:01 PMThank you , whenever i used the -1 , i get error message
RE: splitting column into two
maybe...
DECLARE @name VARCHAR(50)= 'baggins/bilbo';
SELECT LEFT(@Name, CHARINDEX('/', @Name)-1) AS Lastname,
SUBSTRING(@Name, CHARINDEX('/', @Name)+1, LEN(@Name)-CHARINDEX('/', @Name)) AS Firstname;RE: Need to remove punctuation characters
maybe....
DECLARE @s VARCHAR(100)= 'rh@ythm@#%';
SELECT SUBSTRING(@s,1, LEN(@s)-(PATINDEX('%[A-Za-z]%', REVERSE(@s))-1))RE: Lookup values similar to VLookUp in Excel
you have posted in sql 2008 forum...please confirm this is the version you are using.
RE: How to do incremental loading without date filters
upendar.dilytics - Tuesday, August 22, 2017 6:39 AMRE: Need to remove punctuation characters
rhythmk - Tuesday, August 15, 2017 11:45 AM
