Viewing 15 posts - 301 through 315 (of 2,452 total)
Eric M Russell (11/30/2016)
Steve Jones - SSC Editor (11/30/2016)
Eric M Russell (11/30/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 30, 2016 at 12:38 pm
urbanromio2 (11/30/2016)
there will be metal scraps with different purtiy,
for example , metal1 weight of 5kg will be 70% purity,
metal2 weight of 3kg will be...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 30, 2016 at 8:42 am
can you please describe (and explain) your expected results for this sample data
edit...what version of SQL are you using?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 30, 2016 at 8:21 am
nghiahc89 (11/29/2016)
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 :
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 29, 2016 at 2:31 am
halifaxdal (11/24/2016)
Y.B. (11/24/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 24, 2016 at 1:02 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 24, 2016 at 5:32 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 23, 2016 at 3:11 pm
sharonmtowler (11/21/2016)
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 -----...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 21, 2016 at 1:18 pm
DesNorton (11/19/2016)
SELECT cur.*
, ISNULL(DATEDIFF(MINUTE, prev.TimeOutRoom, cur.TimeInRoom), 0) AS TurnaroundMinutes
FROM...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 19, 2016 at 2:27 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2016 at 1:23 pm
pietlinden (11/18/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 18, 2016 at 8:52 am
sqlfriends (11/14/2016)
But I donot like to use recursive CTE, it is slow.
And I wonder if there are any other suggestions.
Thanks
Here is the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 14, 2016 at 11:52 am
maybe...
SELECT *
FROM Table_A
EXCEPT
SELECT *
FROM Table_B
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 9, 2016 at 9:52 am
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 4, 2016 at 3:26 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 3, 2016 at 12:37 pm
Viewing 15 posts - 301 through 315 (of 2,452 total)