Comments by Member 11931581

Member 11931581 4-May-19 14:23pm View

I don't see anything related in the provided link.could you please check it once

Member 11931581 25-Jan-19 1:36am View

Deleted

This update query is not working

Member 11931581 25-Jan-19 1:35am View

Deleted

I have given a sample column with the column values, In every record we have year,location,cell numbers and email addresses . i need to update them with blanks.
Note: I extracted all the year,location,cell number,email into different columns then i am trying to replace them with blanks. I tried to update the table like below .
UPDATE t
SET Column = REPLACE(REPLACE(REPLACE(REPLACE(Column,[year],''),location,''),cellnumber,''),email,'')
FROM table t

Member 11931581 31-Jul-17 6:17am View

Hi Pallini , i want a negative value ..Is it ok if i use like SELECT DATEDIFF(MONTH,'08/10/2017','07/01/2017') ?

Member 11931581 5-May-16 7:17am View

Thank you Zafar..

Member 11931581 27-Apr-16 7:35am View

Thank you!!

Member 11931581 10-Mar-16 5:10am View

My Problem Solved..Thanks a lot!!Animesh..

Member 11931581 10-Mar-16 3:39am View

Hi Thanks alot!! and I have a small doubt ..I hiis code what is mean by 's'(SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())-1,0)))

Comments by Member 11931581 (Top 8 by date)