Viewing 15 posts - 391 through 405 (of 1,250 total)
/*****************************************
Create some sample tables based on a guess
******************************************/
CREATE TABLE #T1
(
UserIDVARCHAR(6)
,DATEDATE
)
CREATE TABLE #T2
(
UserIDVARCHAR(6)
,DATEDATE
)
CREATE TABLE #T3
(
UserIDVARCHAR(6)
,DATEDATE
)
CREATE TABLE #T4
(
UserIDVARCHAR(6)
,DATEDATE
)
CREATE TABLE #T5
(
UserIDVARCHAR(6)
,DATEDATE
)
/*
Populate the tables
*/
INSERT INTO #T1 VALUES
('User01',CAST(GETDATE() AS DATE))
,('User02',CAST(GETDATE() AS DATE))
INSERT INTO #T2 VALUES
('User01',CAST(GETDATE()...
October 4, 2016 at 4:25 am
Brandie Tarvin (9/30/2016)
BWFC (9/29/2016)
[ModenAnswer]A column found on one of our tables. I absolutely promise we are not responsible for any cold calls received by members of the Thread.
So what's...
October 3, 2016 at 12:59 am
[ModenAnswer]
A column found on one of our tables. I absolutely promise we are not responsible for any cold calls received by members of the Thread.
September 29, 2016 at 4:41 am
morlindk (9/29/2016)
I think 'None of these queries' is correct.(i) Table has Score, queries reference TestScore => Error
(ii) Even option 3 produces '9', not '9.0'
/morten
Option 3 produces 9.000000 for me...
September 29, 2016 at 1:00 am
Thanks for the responses folks.
It turns out that the cause was more simple than I feared. Allowing for aging out of anything older than a few days...
September 22, 2016 at 8:02 am
I've had chance to look over what I did before and it's more a case of over-complicated in places rather than shocking. It only actually looks a mess, rather...
September 21, 2016 at 7:11 am
Christmas Day and New Year's Day always fall on the same date but the holiday may not actually fall on that day. In the UK, Christmas Day and Boxing...
September 20, 2016 at 3:21 am
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
All works for...
September 16, 2016 at 7:09 am
Lynn Pettis (9/13/2016)
drew.allen (9/13/2016)
I think someone is in way over their head. Maybe we should just tell him to find another line of work.Drew
Who?
He's busted me...
September 14, 2016 at 6:19 am
The Dixie Flatline (9/8/2016)
Edited to add:
You can't divide by zero...
You can't divide by zero...
You can't divide by zero...
You...
September 9, 2016 at 1:32 am
manie (9/8/2016)
Gary Varga (9/8/2016)
manie (9/8/2016)
...The only way to get this right is practise, practise and practise.This is your advice for getting in trouble with ones wife??? :laugh:
What? Have you got...
September 8, 2016 at 6:37 am
Sean Lange (9/6/2016)
I tried my hand at curing my own bacon for the first time. It came out of the cure Saturday morning and hit the smoker later on Saturday....
September 7, 2016 at 1:22 am
TomThomson (9/6/2016)
Revenant (9/5/2016)
TreatTrick
Cheap
September 6, 2016 at 1:37 am
Carlo Romagnano (9/2/2016)
SPARSE is not a datatype but a property.....
+1
There's nothing in the question that suggests that there are SPARSE columns. It's not something that would jump out...
September 2, 2016 at 4:21 am
Viewing 15 posts - 391 through 405 (of 1,250 total)