Neil Burton

Forum Replies Created

Viewing 15 posts - 631 through 645 (of 1,251 total)

RE: Size of view

SQLRNNR (7/27/2015)
Toreador (7/27/2015)
SQLRNNR (7/25/2015)
Well, if the view does not exist or is in a different schema, then the third option is correct even though it truncated part of the error....
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

July 28, 2015 at 12:50 am

#1815303
RE: Are the posted questions getting worse?

Phil Parkin (7/27/2015)
Brandie Tarvin (7/27/2015)
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught...
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

July 27, 2015 at 5:44 am

#1815089
RE: Are the posted questions getting worse?

It's home made quesadillas here. There may well be room for tequila 🙂
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

July 24, 2015 at 10:49 am

#1814840
RE: Today's Random Word!

Spelling 😀
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

July 24, 2015 at 6:54 am

#1814732
RE: Is Skynet Coming?

It might be able to write to you
It can probably string a better sentence together than the average DM 'journalist' already.
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

July 24, 2015 at 6:46 am

#1814728
RE: Find any character that isn't a number or letter - confused!

create table #PostCodes
(
PostCode varchar(15)
)
insert into #Postcodes values
('AA1 &&%((£4GG')
,('AB2 **%%6TG')
,('£FE2 %5GH')
,('BL0 9QT')
select
Postcode
,cpc.pcode
from #postcodes
cross apply
(
SELECT Pcode = (SELECT SUBSTRING(Postcode,N,1)
FROM (VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15)) AS x(N)
WHERE N<=LEN(Postcode)
...
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

July 24, 2015 at 5:10 am

#1814692
RE: Find any character that isn't a number or letter - confused!

rarara (7/24/2015)
I am struggling with what should be a simple issue....I want to search a postcode field (varchar column) for any characters that shouldn't be there, ie outwith A-Z and...
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

July 24, 2015 at 4:28 am

#1814680
RE: Are the posted questions getting worse?

rodjkidd (7/24/2015)
Morning all,
Now about to leave to catch the train to Manchester. I hope to a few of you there.
Tom don't forget to say hi!
Cheers,
Rodders...
Enjoy your stay up here. ...
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

July 24, 2015 at 2:17 am

#1814661
RE: Are the posted questions getting worse?

Ed Wagner (7/23/2015)
Brandie Tarvin (7/23/2015)
BWFC (7/23/2015)
This very morning there has been an email from the BU accepting that they had misunderstood how the report works. There have been apologies...
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

July 23, 2015 at 8:41 am

#1814399
RE: Are the posted questions getting worse?

Ed Wagner (7/23/2015)
andrew gothard (7/23/2015)
BWFC (7/22/2015)
Aargh!!
'Why didn't this appear on your report? It's wrong. There's been an incident and you've made us look bad in front of government.'...
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

July 23, 2015 at 7:48 am

#1814372
RE: Are the posted questions getting worse?

I have to agree with Jeff here. You do yourself no justice by stubbornly sticking to an approved requirements specification as justification for a system not working as a BU...
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

July 23, 2015 at 2:44 am

#1814293
RE: Are the posted questions getting worse?

The second best part is when they decide to "live with it" because they realized (after creating such a fuss) that they were misreading or misremembering something and they were...
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

July 22, 2015 at 6:27 am

#1814080
RE: Today's Random Word!

Ed Wagner (7/22/2015)
SQLRNNR (7/21/2015)
Ed Wagner (7/21/2015)
ZZartin (7/21/2015)
SQLRNNR (7/21/2015)
cow
Pie
Apple
Chunky
Smooth
Silk
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

July 22, 2015 at 5:10 am

#1814058
RE: Are the posted questions getting worse?

Aargh!!
'Why didn't this appear on your report? It's wrong. There's been an incident and you've made us look bad in front of government.' - The Business
<investigates>
'It's not supposed...
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

July 22, 2015 at 1:30 am

#1814019
RE: Today's Random Word!

jasona.work (7/21/2015)
Ed Wagner (7/21/2015)
whereisSQL? (7/21/2015)
djj (7/21/2015)
Ed Wagner (7/21/2015)
Eirikur Eiriksson (7/20/2015)
Ed Wagner (7/20/2015)
whereisSQL? (7/20/2015)
DonlSimpson (7/20/2015)
crookj (7/20/2015)
Gang
Sam Cooke
Sing
Concert
Instrument
Harmony
Discord
Rumor
Mill
Cider
House
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

July 21, 2015 at 7:58 am

#1813849

Viewing 15 posts - 631 through 645 (of 1,251 total)