Eric M Russell (11/30/2016)

---

Steve Jones - SSC Editor (11/30/2016)

---

Eric M Russell (11/30/2016)

---

I totally don't understand why someone would publish sample programming code on the public web and then expect other...

urbanromio2 (11/30/2016)

---

its about metal melting ,

there will be metal scraps with different purtiy,

for example , metal1 weight of 5kg will be 70% purity,

metal2 weight of 3kg will be...

can you please describe (and explain) your expected results for this sample data

edit...what version of SQL are you using?

nghiahc89 (11/29/2016)

---

Dear Christ,

i have found your solution, it's so helpful but in my case i would like to calculate how many days that customer late for installment payment.

ex :

...

halifaxdal (11/24/2016)

---

Y.B. (11/24/2016)

---

You can do this using Dynamic SQL with a Crosstab. If you'd be willing to provide consumable data I could give you an example on how to...

doesnt sound too complicated, but with out seeing your code difficult to say.

are you using an inner join between the tables based on the reference ID?

if you want a tried...

please do as you have been asked on this thread and other you posted.....provide some scripts.

take a look here and follow the good advice, I am sure it will help...

sharonmtowler (11/21/2016)

---

I provided sample data located under

the data looks like this

row number----- session----- time

1 ----- 1----- 11/16/16 5:01 AM

2 ----- 1----- 11/16/16 5:19 AM

3 ----- 1----- 11/16/16 12:10 PM

1 -----...

DesNorton (11/19/2016)

---

You need to join the table back to itself to get the previous record, and then do the math

SELECT cur.*

, ISNULL(DATEDIFF(MINUTE, prev.TimeOutRoom, cur.TimeInRoom), 0) AS TurnaroundMinutes

FROM...

ok...thanks for the set up script....great help

so can you explain what result you wish

returned for just these rows please....it will clarify your requirement

create table #Test

(

UnvUserID varchar(30),

OperDate datetime,

TimeInRoom varchar(10),

TimeOutRoom varchar(10),

SeqNum...

pietlinden (11/18/2016)

---

I think I understand what's up with this... D3 apparently consumes JSON data. check out Mike Bostock's site... If you look at the bottom of the...

sqlfriends (11/14/2016)

---

Yes , that was posted by me.

But I donot like to use recursive CTE, it is slow.

And I wonder if there are any other suggestions.

Thanks

Here is the...

maybe...

SELECT *

FROM Table_A

EXCEPT

SELECT *

FROM Table_B

would be good if the "who's on" button could filter out all the web bots as well....as it is at the moment, it is useless.

hopefully new forum software will deliver

ScottPletcher (11/3/2016)

---

J Livingston SQL (11/3/2016)

---

ScottPletcher (11/3/2016)

---

I missed that part of your post. Although you did use only 6 zeros, which would leave a digit short if the initial column...