Neil Burton

Forum Replies Created

Viewing 15 posts - 406 through 420 (of 1,243 total)

RE: Are the posted questions getting worse?

Jack Corbett (8/3/2016)
Lynn Pettis (8/3/2016)
Is the code I wrote here really that sophisticated, or is it that I have been doing this so long that for me it...

August 4, 2016 at 1:18 am

#1893676
RE: Temp Table Foreign Keys

Define successfully; if there's a warning generated and something, that could be critical, is not done, is that successful? The right answer is right but I don't think it's...

August 2, 2016 at 12:57 am

#1893118
RE: How Far Have You Traveled for a SQL Saturday?

Gary Varga (7/29/2016)
Hugo Kornelis (7/29/2016)
...I am aware that speakers have a different view of the conference world...I do believe that it is good to have a rule that prevents multiple...

July 29, 2016 at 4:14 am

#1892598
RE: How Far Have You Traveled for a SQL Saturday?

I think some of it is relative to the country where the events are held. In the UK, 90 miles is considered a long way but in some countries...

July 29, 2016 at 3:20 am

#1892595
RE: Are the posted questions getting worse?

Is anybody else, apart from Hugo, going to be at SQL Saturday Manchester tomorrow?

July 22, 2016 at 6:42 am

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

You're welcome. What did you use to order the rows?

July 21, 2016 at 7:09 am

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

I've assumed that there is a column indicating when row was inserted. I also taken you literally and assumed that non-zero could be a negative rather than just greater...

July 21, 2016 at 6:28 am

#1891291
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...

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...

July 19, 2016 at 7:38 am

#1890860
RE: Query Question for New Guy

Edit: Not needed after Thomas and Luis's answers.

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...

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 :...

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

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...

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? ...

July 6, 2016 at 4:10 am

#1888644

Viewing 15 posts - 406 through 420 (of 1,243 total)