Forum Replies Created
Viewing 15 posts - 481 through 495 (of 1,251 total)
-
RE: Who's going to SQL Bits in Liverpool?
I could have been at Bits but oh no I had to go to the party.
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: More Unicode
Felix Pamittan (5/5/2016)
Correct answer:
Yes, you can run this code, This returns 97
Explanation:
You can run this code. The CHAR variable is converted to NCHAR and the first character's value...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: What’s in a name?
We've got a problem with entities having different names across different teams in the same business. To compound the issue, tables in the data warehouse have the same names...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Update Table if Stored Proc Does Not Complete
Luis Cazares (5/3/2016)
If the procedure is stopped and it's properly written, it might have to rollback everything that has been done. Because you're using a single transaction, right?AARGH! Session timeout!!...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Who's going to SQL Bits in Liverpool?
Grant Fritchey (4/27/2016)
Steve Jones - SSC Editor (4/27/2016)
tindog (4/27/2016)
I'd love to go to this, but have no SQL-y friends and get v anxious in unfamiliar places where I don't know...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: A Token Escape
That was surprisingly easy for one of Andy's questions. There weren't any tricks or things that we should have inferred from the position of a comma :cool:. I...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Who's going to SQL Bits in Liverpool?
Steve Jones - SSC Editor (4/26/2016)
BWFC (4/26/2016)
I'm now unregistered as yesterday I was officially invited to spend my Saturday afternoon with an army of four-year-olds on a sugar-rush. Although...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: How can I get two rows for the same record using SSRS?
NineIron (4/26/2016)
I have a report with too many columns to fit onto a landscape format. Is there a way to "divide" the record up to create two rows for 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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: A nice whistle and flute
Gary Varga (4/26/2016)
TomThomson (4/25/2016)
...the classic example is "dancers" which is rhyming slang for "stairs" (truncated and mutated "dancing bears")...??? Surely you mean "apples 'n' pears"!!!
I have never heard of Dancing...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Who's going to SQL Bits in Liverpool?
Hugo Kornelis (4/13/2016)
BWFC (4/13/2016)
I've got my name down for the Saturday but it clashes with a family do so it's unlikely I'll make it.If you can indeed not make 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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Are the posted questions getting worse?
Luis Cazares (4/25/2016)
Ed Wagner (4/25/2016)
Jeff Moden (4/24/2016)
TomThomson (4/22/2016)
Phil Parkin (4/22/2016)
Eirikur Eiriksson (4/22/2016)
Brandie Tarvin (4/22/2016)
In this case I did add my two cents because I've seen that damn failure before 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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: get difference from previous record
NJ Smith (4/21/2016)
You could use the LAG() Windows Function which retrieves the value of the previous row. LEAD() retrieves the value on the next row. Something like;DECLARE @StartDate AS DATETIME
SET...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: get difference from previous record
DECLARE @MeterReading TABLE
(
MeterId int,MeterDescription varchar(100), ReadingOn datetime, NewReading float
)
INSERT INTO @MeterReading ( MeterId ,MeterDescription ,ReadingOn ,NewReading) VALUES ( 1350,'Left Hand Power Pack RHM','2016-04-14 11:30:00.000',2562.9)
INSERT INTO @MeterReading ( MeterId ,MeterDescription ,ReadingOn...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: get difference from previous record
Nomvula (4/21/2016)
Hi GuysI have the following script when give me the max record on each date:
DECLARE @StartDate AS DATETIME
SET @StartDate = CONVERT(DATETIME,'15/04/2016',103)
SELECT amr.MeterId
...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
RE: Byte Me: Inadequate Cooling
Gary Varga (4/20/2016)
Picasso did surrealist paintings where items looked as though they had melted. The artist is matching this with the IT issue of cooling.Maybe it is a bad indicator...
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 PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
Viewing 15 posts - 481 through 495 (of 1,251 total)