Here are 2 options identical in execution. One uses a derived table and the other one uses a CTE.

UPDATE T

SET SALE = S.Sale,

Exp = S.EXP

FROM Sale...

If it's a bigint or similar, then a simple math operation will work.

DECLARE @Table TABLE( Somenumber bigint);

INSERT INTO @Table

SELECT 1000000017777 UNION ALL

SELECT 1000000017342;

SELECT *, Somenumber % 1000000000000

FROM @Table;

Brandie Tarvin (8/29/2016)

---

Here's a thought. So many people are asking for interview questions, why don't we create a list of subjects that are often covered by interviews (possibly including links...

SQLRNNR (8/26/2016)

---

WayneS (8/26/2016)

---

As...

What do you mean by this?

shezi (8/26/2016)

---

In TSQL it would have been listtle easy to do that but I need to get this done in SQL query. I believe...

WayneS (8/26/2016)

---

As did...

Beatrix Kiddo (8/26/2016)

---

Go to Canal street. Face east. Turn right on Mott. Go down a block. Turn right. Thai restaurant on your...

The problem with the proposed xml solutions, is that the sample data is not xml. It has to be formatted to be xml and that would be more work.

That's if...

You seem to have asked this question (or a version of it) several times.

You should be able to create a dynamic pivot for yourself now, unless you don't understand the...

Read the article that I mentioned before, here's an extract to show why it's important:

...

Jeff Moden (8/25/2016)

---

P.S. You should also avoid the use of any of the "MONEY" datatypes and small scale DECIMAL types for any work with any operators other than simple...

You have the wrong characters in your REPLACE function. Use the correct ones and you should get it done.

Fragmentation

Can you believe they also charge for their courses?

I...

Maybe this could help:

if object_id('tempdb..#t') is not null DROP TABLE #t;

create table #t( str varchar(4000) );

insert into #t(str) values ( '<DataReference>ABCGT ' );

insert into #t(str) values ( '<DataReference>UITR <DataReference>ACDE <DataReference>ERR...