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________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Query to give sum of items with condition from multiple tables
rosarozina - Tuesday, November 14, 2017 4:24 PMlook forward to it....
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: Query to give sum of items with condition from multiple tables
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
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.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: splitting column into two
alhakimi - Sunday, September 3, 2017 1:26 PM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
RE: splitting column into two
alhakimi - Sunday, September 3, 2017 1:01 PMThank you , whenever i used the -1 , i get error message
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: 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;________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: 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))________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Lookup values similar to VLookUp in Excel
you have posted in sql 2008 forum...please confirm this is the version you are using.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: How to do incremental loading without date filters
upendar.dilytics - Tuesday, August 22, 2017 6:39 AM________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school dayRE: Need to remove punctuation characters
rhythmk - Tuesday, August 15, 2017 11:45 AM
