Neil Burton

Forum Replies Created

Viewing 15 posts - 526 through 540 (of 1,251 total)

RE: Help with Row Number

TSQL Tryer (2/26/2016)
The only thing I'm thinking is what if the Current Period is 1 but the year is say 2017 (next financial year....it would need to pull back 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

February 26, 2016 at 4:51 am

#1861347
RE: Today's Random Word!

djj (2/26/2016)
ThomasRushton (2/26/2016)
Ed Wagner (2/25/2016)
Revenant (2/25/2016)
crookj (2/25/2016)
Grumpy DBA (2/25/2016)
Ed Wagner (2/25/2016)
ThomasRushton (2/25/2016)
DonlSimpson (2/25/2016)
Ed Wagner (2/25/2016)
Grumpy DBA (2/25/2016)
crookj (2/25/2016)
Ghost (Rider)
Pepper
Habenero
Blaze
Saddle
Horse
Mongo
Beans
Campfire
Marshmallows
Ghostbusters!
Slimer
Green
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

February 26, 2016 at 4:48 am

#1861346
RE: Help with Row Number

SELECT TOP 12 ---Create a list of numbers from 0 - 12
N = IDENTITY(INT ,0,1)
INTO #tally
FROM
master.dbo.syscolumns sc1,
master.dbo.syscolumns sc2;
WITH curr_per AS --Find all the current period indicators
(
SELECT
periodnumber
,CalendarPeriodId
,CalendarYearId
FROM
test...
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

February 26, 2016 at 2:47 am

#1861335
RE: Are the posted questions getting worse?

djj (2/25/2016)
jasona.work (2/25/2016)
Man, my music tastes go all over the place...
Listening to my playlist on my phone today, just went from Dragonforce, now I'm listening to an Alex Band tune...
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

February 26, 2016 at 1:17 am

#1861325
RE: Help with Row Number

Can you post some sample data please?
It will make it much easier to understand what you want and to come up with a solution.
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

February 25, 2016 at 8:53 am

#1861113
RE: Microsoft 70-448 Exam: Self Exam Engine developed trainings!

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

February 25, 2016 at 3:31 am

#1860990
RE: how to loop without endless joins

astrid 69000 (2/24/2016)
Hi,
I have a table that each row related to another row, and apart from that they have nothing in common.
create table #mynumbers (Appl int, Pre_App int);
insert into #mynumbers...
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

February 24, 2016 at 5:44 am

#1860674
RE: Today's Random Word!

Ed Wagner (2/23/2016)
Ed Wagner (2/22/2016)
DonlSimpson (2/22/2016)
ZZartin (2/22/2016)
Grumpy DBA (2/22/2016)
djj (2/22/2016)
Fixes
Neutered
Schnauzer
Terrier
Bichon
Greyhound
Bus
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

February 23, 2016 at 6:27 am

#1860380
RE: TRY_CONVERT smaller

Steve Jones - SSC Editor (2/18/2016)
BWFC (2/18/2016)
To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version...
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

February 18, 2016 at 10:10 am

#1859635
RE: TRY_CONVERT smaller

To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version but many people testing that, like...
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

February 18, 2016 at 1:09 am

#1859461
RE: Forcing Strong Passwords

As somebody mentioned the other day, this[/url] sums things up well.
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

February 17, 2016 at 8:01 am

#1859265
RE: Are the posted questions getting worse?

Since I know you and I have the same smoker, have you done anything to protect it from the weather? I never found a decent cover for it and 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

February 9, 2016 at 4:29 am

#1857328
RE: Are the posted questions getting worse?

ChrisM@Work (2/9/2016)
Sean Lange (2/8/2016)
Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time...
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

February 9, 2016 at 4:20 am

#1857326
RE: Changing Granularity of Fact Table

Jack Corbett (2/5/2016)
BWFC (2/5/2016)
It's done through stored procs called by SSIS. We first load a staging table then the fact table.
Okay so that makes the process...
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

February 5, 2016 at 8:59 am

#1856904
RE: Changing Granularity of Fact Table

Jack Corbett (2/5/2016)
How do you load the data warehouse?
Can a person have risk at one load and then not have a risk the next load?
How will...
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

February 5, 2016 at 7:53 am

#1856848

Viewing 15 posts - 526 through 540 (of 1,251 total)