Viewing 15 posts - 1,441 through 1,455 (of 1,988 total)
That format is pretty straight forward if you have the diff in seconds.
SELECT CAST( (DATEDIFF(second, '3/14/2016', getdate()) / 60) / 60 AS varchar) + ':' + CAST( (DATEDIFF(second, '3/14/2016',...
March 14, 2016 at 2:27 pm
whereisSQL? (3/14/2016)
Ed Wagner (3/14/2016)
crookj (3/14/2016)
Ed Wagner (3/14/2016)
ThomasRushton (3/14/2016)
Grumpy DBA (3/14/2016)
Ed Wagner (3/11/2016)
djj (3/11/2016)
BunnyEaster Egg
Hunt
Saboteur
Fired
Terminated
Arnold
Sylvester
Tweety
March 14, 2016 at 8:48 am
Without being super familiar with Access you could probably just change the
Count(IIf([visit_date] Between #2/1/2016# And #2/29/2016#,[registration_cd]))
To SUM(CASE WHEN visit_date >= '2/1/2016' AND visit_date <= '2/29/2016' THEN 1 ELSE 0...
March 14, 2016 at 7:45 am
The problem with place holders like that is that you are using the same field for multiple purposes. TBD for example is not an addess it's a process control...
March 11, 2016 at 7:50 am
Converting from a mainframe is always going to be painful 😛
I was more responding to how to design a freh DB.
March 10, 2016 at 6:25 pm
kenambrose (3/10/2016)
that question implies that you would otherwise have ~10000 "nullable" columns in your design?which would be nonsense design under any stretch of the imagination, wouldn't it?
If a solution doesn't...
March 10, 2016 at 4:30 pm
kenambrose (3/9/2016)
Correct, and that is NOT a requirement for a schema that disallows nulls. why would you possibly think it was?
At the end of the day a null represents...
March 9, 2016 at 10:54 pm
kenambrose (3/9/2016)
One could argue that allowing nulls facilitates poor definition of requirements. Not...
March 9, 2016 at 7:12 pm
kenambrose (3/2/2016)
it was in earlier post. put nullable column into it's own table, enforce 1 to 1 relationship to parent table.
no data for a row in...
March 2, 2016 at 1:41 pm
If those are the only two customer id's you care about and you don't care about the order.
SELECT TOP 10 * FROM DO.CUSTOMER_tbl WHERE CUSTOMER_ID IS = 'XYZ-1234'
UNION ALL
SELECT...
March 2, 2016 at 9:58 am
Ed Wagner (3/1/2016)
Ray K (3/1/2016)
DonlSimpson (3/1/2016)
ThomasRushton (3/1/2016)
Ed Wagner (3/1/2016)
Grumpy DBA (3/1/2016)
Ed Wagner (3/1/2016)
CampaignChampagne
Toast
Marmite
Marmot
Merlot
Shiraz
Shazzam
March 1, 2016 at 10:48 am
roger.plowman (3/1/2016)
patrickmcginnis59 10839 (2/29/2016)
roger.plowman (2/29/2016)
I still don't see why relational tables can't have records for TBD, N/A, and UNK.
If you need to know why a value is missing, you're going...
March 1, 2016 at 7:20 am
roger.plowman (2/29/2016)
ZZartin (2/29/2016)
roger.plowman (2/29/2016)
This A) gets rid of nulls, which are just messy to code for...
February 29, 2016 at 1:37 pm
roger.plowman (2/29/2016)
This A) gets rid of nulls, which are just messy to code for and B)...
February 29, 2016 at 1:02 pm
I love my IDE's they're just like any other tool used properly they can be very useful. That said they're not meant to turn anyone into a developer automatically...
February 29, 2016 at 11:29 am
Viewing 15 posts - 1,441 through 1,455 (of 1,988 total)