Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2010

Cleaning up excess contiguous spaces in strings. A mystery.

/* Have you ever come across the problem where you have to remove spaces from a string that has too many? You'll know that if you do the obvious ...*/
SELECT REPLACE ('this         has            too                          many                               spaces' ,'  ', ' ')
-- ... you end up with your problem… Read more

4 comments, 1,558 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 30 September 2010

COMPUTE: now it is going, what else will do it?

/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad, and it is flagged for deprecation. It is an old Sybase legacy that was used when reports were printed directly from the output of SQL. You can still do it,… Read more

6 comments, 855 reads

Posted in Phil Factor's Phrenetic Phoughts: The SQL on 23 September 2010