Neil Burton

Forum Replies Created

Viewing 15 posts - 376 through 390 (of 1,251 total)

RE: Today's Random Word!

Ed Wagner (10/21/2016)
djj (10/21/2016)
Stuart Davies (10/21/2016)
Ed Wagner (10/20/2016)
TomThomson (10/20/2016)
Ray K (10/20/2016)
Revenant (10/20/2016)
Penny
Nickel
Nickelodeon
Cartoon
Strip
Stripper (as in paint)
Scrape
Shell
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 21, 2016 at 5:19 am

#1907919
RE: Order SQL data by country

You're welcome. Happy to help 🙂
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 19, 2016 at 6:26 am

#1907394
RE: Order SQL data by country

Does this do what you need?
CREATE TABLE #example
(
first_nameVARCHAR(15)
,surnameVARCHAR(20)
,email_addressVARCHAR(60)
,countryVARCHAR(20)
)
INSERT INTO #example VALUES
('Andy','Capp','AndyCapp@thecouch.ie','Ireland')
,('Asterix','Thegaul','DesMenhirs@obelix.fr','France')
,('Hexe','Lilli','Spell@witches.de','Germany')
,('Paddington','Bear','Marmalade@sandwiches.pe','Peru')
,('blinky','bill','Up@bluegumtree.au','Australia')
SELECT
*
FROM #example e
ORDER BY
CASE WHEN country IN('Ireland'
,'France'
,'Germany')
THEN 1
ELSE 2
END
DROP TABLE
#example
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 19, 2016 at 6:07 am

#1907386
RE: Are the posted questions getting worse?

jasona.work (10/18/2016)
BWFC (10/18/2016)
jasona.work (10/18/2016)
Brandie Tarvin (10/18/2016)
What a morning. SSC just broke my heart.
I see an article about time traveling listed in the newsletter. Get ready to read it and realize,...
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 18, 2016 at 8:18 am

#1907152
RE: Are the posted questions getting worse?

Sean Lange (10/18/2016)
Grumpy DBA (10/18/2016)
Grant Fritchey (10/18/2016)
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Wow, just read the comments on Reddit about a recent blog post... ouch.
Evidently stating the obvious when others are stating the...
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 18, 2016 at 7:59 am

#1907144
RE: Are the posted questions getting worse?

jasona.work (10/18/2016)
Brandie Tarvin (10/18/2016)
What a morning. SSC just broke my heart.
I see an article about time traveling listed in the newsletter. Get ready to read it and realize, it's not...
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 18, 2016 at 5:46 am

#1907103
RE: Today's Random Word!

Ed Wagner (10/18/2016)
whereisSQL? (10/17/2016)
Ray K (10/17/2016)
Revenant (10/17/2016)
Ed Wagner (10/17/2016)
djj (10/17/2016)
Ed Wagner (10/17/2016)
ZZartin (10/17/2016)
djj (10/17/2016)
Ed Wagner (10/17/2016)
Grumpy DBA (10/17/2016)
crookj (10/17/2016)
Tragedy
Greek
Italian
Dressing
Undressing
Monty Pyton
Full Monty
Spam
Filter
Oil
Spill
Residual
Current
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 18, 2016 at 5:19 am

#1907095
RE: Are the posted questions getting worse?

GilaMonster (10/13/2016)
20 years ago I was at University. 2nd year specifically, Maths, Physics, Computer Science.
And I'm one of the oldest people at my current company (CEO is 2 years younger...
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 13, 2016 at 6:28 am

#1906300
RE: Cannot for the life of me Feeeze the Column Headers on a simple Tabular SRSS Report

It's not as straightforward as it first seems. Have a look at this link for one way to do it.
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 13, 2016 at 3:14 am

#1906273
RE: Stop Backups of Distributed Databases

I have to say I don't know whether the backups are tested or not. The Ops guys we were going to speak to about getting rid of the secondaries...
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 12, 2016 at 7:26 am

#1906109
RE: Stop Backups of Distributed Databases

Cheers John.
The backups are on the same drive as tempdb and I didn't think that was a good idea. If we stop the backups then tempdb will obviously be...
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 12, 2016 at 3:14 am

#1906055
RE: Are the posted questions getting worse?

Ed Wagner (10/5/2016)
Sean Lange (10/5/2016)
Eirikur Eiriksson (10/5/2016)
george sibbald (10/5/2016)
Lynn Pettis (10/5/2016)
george sibbald (10/5/2016)
well that's me done. I retire today so this will be my last post.
I made it into the...
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 6, 2016 at 1:13 am

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

Again, you're welcome.
This place has helped me out no end in the past. I'm glad I can pass on something of what I've learned here. Please...
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 7:45 am

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

1) Yes; the UNION operator can combine multiple queries with the same output columns but different sources. In this case we're returning the user ids from 5 different tables....
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 6:03 am

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

You're welcome, I'm happy to help. Do you understand what it does?
As a disclaimer, I've only Googled using a CTE in an SSRS dataset rather than actually doing it...
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 5:18 am

#1904632

Viewing 15 posts - 376 through 390 (of 1,251 total)