Or an even shorter version:

SUBSTRING(OldSSN,8,4)

SELECT 
  t.OldSSN
  ,LeftTrim = LEFT(t.OldSSN,4)
  ,RightTrim = RIGHT(t.OldSSN,4)
  ,[FirstName]
  ,[LastName]
  ,LEFT(SUBSTRING(OldSSN,8,100),4)
  ,LEFT(SUBSTRING(OldSSN,CHARINDEX('-', OldSSN,6)+1,100),4)
FROM [dbo].[TestSSNTrim] AS t

Here is the exec plan.  I just figured that since a page is 8K, a single integer would easily fit on one page and since the plan is a...

Maybe to navigate through the B-tree?

For example, if the b-tree looked like this you would need to read 6 pages with 2 scans to get the min and max values...

It could be a problem with the SQL learning site. Maybe it's expecting a decimal point in the output.

You could try casting it to money:

CAST(price + amount...

WITH myTable AS (SELECT * FROM (VALUES ('3#5'),('8063#0018375'),('8063#018375'),('063#018375'),('063invalid018375')) X(AccountNumber)) 
SELECT myTable.AccountNumber, 
       RIGHT('0000'+LEFT(myTable.AccountNumber,CHARINDEX('#',myTable.AccountNumber)-1),4) PaddedLeftAccountNumber,
       RIGHT('0000000'+REVERSE(LEFT(T.RevAccountNumber,CHARINDEX('#',...

• This reply was modified 6 years, 2 months ago by Jonathan AC Roberts.

I have alter the app code with:

INSERT EtiquetasKLC.dbo.etiquetas
(
    nome_posto
   ,data
   ,lote
   ,serialnumber
   ,partnumber
  ...

So, speaking of formatting tools, I just got a complaint because I formatted the code from the stored procedure that I worked on and that generated too many differences...

I think the line:

select * from [EtiquetasKLC].[dbo].[etiquetas]with (updlock) where partnumber like...

was put there to lock all the rows with that partnumber so they can't be read by...

This will find members of staff who were not on a call when the missed call started ringing:

Set up data

IF OBJECT_ID('tempdb..#RawData','U') IS NOT NULL DROP TABLE...

Which column represents the person who answer the call?

How do you calculate the Answered and EndTime?

Where does the hold time come into it?

The CTE is just there to represent your tables (I thought you would have a Staff table and a Calls table). You shouldn't have to type anything in manually. I...

If the error is raised inside the BEGIN TRANSACTION/COMMIT block then I think there will still be a transaction open in the CATCH block. I don't use "XACT_ABORT ON" but...

This will find who was available to answer missed calls but didn't answer them.

The structure it uses is, I think, a bit more like your raw data must be.

This reply was modified 6 years, 2 months ago by Jonathan AC Roberts.