Viewing 15 posts - 691 through 705 (of 844 total)
Nice work, I had to make a few modifications for it to work for me.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 9:08 am
Game over. Human player wins in 35 shots!:-)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 27, 2014 at 9:05 am
See if this works:
CREATE TABLE #temp
(
guidchar(5),
statuschar(3),
INOUT_timedatetime
)
insert into #temp
SELECT '1djey', 'OUT', '05/22/2014 17:13:00'
UNION
SELECT '1djey', 'IN', '05/22/2014 05:00:00'
UNION
SELECT '1djey', 'OUT', '05/22/2014 4:13:00'
UNION
SELECT '1djey', 'IN', '05/22/2014 2:00:00'
UNION
SELECT '4heyk', 'OUT', '05/22/2014 18:10:00'
UNION
SELECT '4heyk', 'IN',...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 23, 2014 at 8:46 am
Well done Luis, I haven't had the opportunity to use the Cross Join, but I will remember it for any future needs. With not knowing about the cross join...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 14, 2014 at 7:41 am
thomashohner (5/9/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 9, 2014 at 7:58 am
Steve Jones - SSC Editor (5/7/2014)
Jack Corbett (5/7/2014)
1. Direction - I don't always want to be picking...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 7, 2014 at 9:18 am
Steph Locke (5/7/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 7, 2014 at 7:41 am
Sean Lange (5/5/2014)
Phillip.Putzback (5/5/2014)
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 5, 2014 at 12:36 pm
OCTom (5/2/2014)
It was interesting to...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 5, 2014 at 12:28 pm
We have a database that we store all of our 'reference' type tables like this. We just try to give it a descriptive name and let everyone know about...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 5, 2014 at 12:05 pm
Joining to a lookup table is the way we've got around a similar issue, ever changing values from users. And for the example of midwest states, we have a...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 5, 2014 at 8:15 am
Sean, Your code looses the last value in the string, for value 'asdf12345678901' you loose the 1.
That's wierd I'm having trouble posing code now, Oh well.
Added a 1 + to...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 1, 2014 at 10:35 am
Sean's version seams to work with the data shown, but if the field is a larger field it doesn't always get the correct results. I used a CASE statement...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 1, 2014 at 8:23 am
Your calculation is a bit off, you said "13m record reads per hours / 2,163,568,622 rows = 166 days to create this index !"
That's 166 hours not days, still 7...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
May 1, 2014 at 7:48 am
Matt Miller (#4) (4/23/2014)
below86 (4/23/2014)
It is wierd that if you do .998 it shows as .997.
declare @d datetime;
set @d = '2014-04-23...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
April 23, 2014 at 3:57 pm
Viewing 15 posts - 691 through 705 (of 844 total)