Neil Burton

Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,251 total)

RE: Exclude zero till get first nonzero value.(use cte or select)

Anandkumar-SQL_Developer (7/21/2016)
Hi Friends ,
input code :
CREATE TABLE #First_nonzero
(
value int
)
GO
INSERT INTO #First_nonzero VALUES
(0),
(0),
(0),
(0),
(1),
(2),
(0),
(3),
(0)
Expected_output :
1
2
0
3
0
please some one suggest me how can i do this ..?
I think...
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, 2016 at 5:44 am

#1891280
RE: Are the posted questions getting worse?

It's SQL Saturday in Manchester for me, then a wedding on Sunday. We might drag ourselves to the flicks on Monday depending on how the Guinness flows at 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

July 19, 2016 at 7:38 am

#1890860
RE: Query Question for New Guy

Edit: Not needed after Thomas and Luis's answers.
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 13, 2016 at 8:35 am

#1889882
RE: Query Question for New Guy

You'll need to join to your location table again, using the Site_Id for the end lat and long. At the moment, the query only joins on the start location...
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 13, 2016 at 6:36 am

#1889831
RE: how to get data PostCode last two after two space sql server

I'm not sure what you're asking here. Your query looks like it already returns:
Via 1 : HA3 0AB , Via 2 : WC2A 1AB , Via 3 :...
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 12, 2016 at 5:07 am

#1889561
RE: Today's Random Word!

Ed Wagner (7/11/2016)
Grumpy DBA (7/11/2016)
eccentricDBA (7/11/2016)
Ed Wagner (7/11/2016)
Manic Star (7/11/2016)
Luis Cazares (7/11/2016)
Ed Wagner (7/11/2016)
Boom
chick-chicky-boom
Explosion
Shrapnel
collateral damage
Arnold Schwarzenegger
Terminator
Semi-colon
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 11, 2016 at 7:42 am

#1889412
RE: Going On-Prem?

rob.carter 79958 (7/11/2016)
I'd echo the point about personal information, though I'm in a healthcare environment so it would be patient information that would be "cloudified" (I'm trademarking that).
As I'm in...
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 11, 2016 at 4:25 am

#1889372
RE: Are the posted questions getting worse?

ChrisM@Work (7/6/2016)
BWFC (7/6/2016)
ChrisM@Work (7/6/2016)
BWFC (7/6/2016)
Phil Parkin (7/5/2016)
tindog (7/5/2016)
Michael L John (7/5/2016)
Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? ...
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 6, 2016 at 4:10 am

#1888644
RE: Are the posted questions getting worse?

ChrisM@Work (7/6/2016)
BWFC (7/6/2016)
Phil Parkin (7/5/2016)
tindog (7/5/2016)
Michael L John (7/5/2016)
Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have...
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 6, 2016 at 2:04 am

#1888623
RE: Are the posted questions getting worse?

Phil Parkin (7/5/2016)
tindog (7/5/2016)
Michael L John (7/5/2016)
Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague...
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 6, 2016 at 1:11 am

#1888619
RE: simple merge program

Anandkumar-SQL_Developer (7/4/2016)
Hi friends ,
while i am running this simple merge program , there is an 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 4, 2016 at 4:18 am

#1888257
RE: Customers persuaded with

Reported as spam
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 4, 2016 at 3:42 am

#1888255
RE: Are the posted questions getting worse?

Brandie Tarvin (7/2/2016)
Eirikur Eiriksson (7/2/2016)
Spam, spam and again spam 🙁 Why on earth is it so hard to tackle this problem on sqlservercentral.com???
😎
Because pork shoulder is just that tasty.
😀
It'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

July 2, 2016 at 2:20 pm

#1888211
RE: Are the posted questions getting worse?

Eirikur Eiriksson (7/1/2016)
Brandie Tarvin (7/1/2016)
Oh dear. I knew things were getting tense in Asia, especially between China and Taiwain, but this?
Oh dear. I hope they talk it out first.
Brandie, 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

July 1, 2016 at 2:47 pm

#1888166
RE: Pattern match postcode area lookup

Yipes...
So even though BB4 5 is part of BB4 they may have different codes in the same database?
Could you split out the different customers' formats and codes into different lookup...
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 1, 2016 at 7:48 am

#1888092

Viewing 15 posts - 421 through 435 (of 1,251 total)