... VARCHAR(10)
SET @StringInput = RTRIM(LTRIM(@StringInput))
WHILE LEN(@StringInput) > 0
BEGIN
SET @StringValue = LEFT(@StringInput,
ISNULL(NULLIF(CHARINDEX(' ...
This was called a Data-Scrambling Function but it depends on what you mean by "scrambling". This is a function which merely uses the same characters but switches their order randomly, so I've renamed ...
... AS 'Contact',
CHAR(10)+c.[Owner]+CHAR(10) AS 'Dept',
CASE
WHEN CHARINDEX('/', c.[Phone]) > 0 THEN REPLACE(REPLACE(c.[Phone], ' ', ''), '/', CHAR(10))
WHEN CHARINDEX(' or ', c.[Phone] ...
... TimeStart, TimeEnd)) [TimeTakenAvg]
LEFT(CAST(CONVERT(varchar, CAST(SUM(ByteCount) AS money), 1) AS varchar),CHARINDEX('.',CAST(CONVERT(varchar, CAST(SUM(ByteCount) AS money), 1) AS varchar))-1) AS [ByteCountSum] ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.