Neil Burton

Forum Replies Created

Viewing 15 posts - 391 through 405 (of 1,251 total)

RE: Combine 2 fields from 5 tables into one list?

rkelly58 (10/4/2016)
Please can anyone help, I have 5 SQL tables (T1, T2, T3, T4, T5) which contain just 2 fields: UserID and Timestamp
I need to read each table and pulls...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

October 4, 2016 at 4:37 am

#1904623
RE: Report to pull UserID field and Date field from 5 tables and display a List?

/*****************************************
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()...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

October 4, 2016 at 4:25 am

#1904621
RE: Are the posted questions getting worse?

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

October 3, 2016 at 12:59 am

#1904329
RE: Are the posted questions getting worse?

[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.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 29, 2016 at 4:41 am

#1903869
RE: Round averages

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 29, 2016 at 1:00 am

#1903839
RE: When Is an Execution Plan Cached?

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 22, 2016 at 8:02 am

#1902477
RE: The Bones of SQL - The Holiday Table

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 21, 2016 at 7:11 am

#1902149
RE: The Bones of SQL - The Holiday Table

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 20, 2016 at 3:21 am

#1901812
RE: Are the posted questions getting worse?

jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.
All works for...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 16, 2016 at 7:09 am

#1901330
RE: Are the posted questions getting worse?

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 14, 2016 at 6:19 am

#1900773
RE: Are the posted questions getting worse?

The Dixie Flatline (9/8/2016)
If any of you carnivores haven't tried "lacquered" bacon, you're missing a treat!
Edited to add:
You can't divide by zero...
You can't divide by zero...
You can't divide by zero...
You...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 9, 2016 at 1:32 am

#1899962
RE: You know what we really need? Better interpersonal communication

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 8, 2016 at 6:37 am

#1899779
RE: Are the posted questions getting worse?

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....
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 7, 2016 at 1:22 am

#1899511
RE: Today's Random Word!

TomThomson (9/6/2016)
Revenant (9/5/2016)
Treat
Trick
Cheap
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 6, 2016 at 1:37 am

#1899261
RE: Will It Compress?

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...
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

September 2, 2016 at 4:21 am

#1898954

Viewing 15 posts - 391 through 405 (of 1,251 total)