April 26, 2012 at 8:04 am
Anyone want to tackle a semi-complex reporting / accounting issue?
http://www.sqlservercentral.com/Forums/Topic1290025-1291-1.aspx#bm1290373
April 26, 2012 at 8:19 am
The Dixie Flatline (4/25/2012)
"If you want to unserstand(sic) what's happening in Western (USA, UK, France, etc) society/politics today read 1984, Animal Farm, and Fahrenheit 451. Plus a good dose of Kafka, Collins' The Path to Freedom, The Man who was Thursday and The Flying Inn. Maybe one of Clifford Simak's more pessimistic novels too. "
Tom, I was curious if you had ever read "Brave New World" by Aldous Huxley? Lightweight compared to Kafka, but eerily prescient for something written in 1931.
Yes, it's an excellent book and maybe I should have included it in my list; but while a part of the populations of western countries are so steeped in irrelevance that they illustrate the dead end described and show that we still risk ending up there, I think that the oppression suggested in 1984 is more in tune with the powers that be (and their appetites for state control of everything and no control of organs of the state) on both sides of the pond.
Tom
April 26, 2012 at 8:59 am
Steve Jones - SSC Editor (4/26/2012)
Anyone want to tackle a semi-complex reporting / accounting issue?http://www.sqlservercentral.com/Forums/Topic1290025-1291-1.aspx#bm1290373
Steve, How far out do you have QotD planned? I have been trying to get one completed and submitted.
April 26, 2012 at 11:51 am
Current QOD status. I have them scheduled through May 9, plus a few random days out past that, but I also have 16 submitted right now that I'll go through tomorrow or Monday.
April 26, 2012 at 12:07 pm
Steve Jones - SSC Editor (4/26/2012)
Current QOD status. I have them scheduled through May 9, plus a few random days out past that, but I also have 16 submitted right now that I'll go through tomorrow or Monday.
I'll work hard to get you mine this weekend. I've only been sitting on it for a week or two.
April 26, 2012 at 12:18 pm
Steve Jones - SSC Editor (4/26/2012)
Current QOD status. I have them scheduled through May 9, plus a few random days out past that, but I also have 16 submitted right now that I'll go through tomorrow or Monday.
And articles, how far forward are things scheduled?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 26, 2012 at 12:25 pm
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what the problem was. this one. Wha??
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]
April 26, 2012 at 12:40 pm
capn.hector (4/26/2012)
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what the problem was. this one. Wha??
If a boolean (bit) is 1, another parameter gets a '+' in front.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 26, 2012 at 12:43 pm
GilaMonster (4/26/2012)
capn.hector (4/26/2012)
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what the problem was. this one. Wha??
If a boolean (bit) is 1, another parameter gets a '+' in front.
But, of course a bit is not boolean in SQL Server unless declared with NOT NULL
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 26, 2012 at 12:46 pm
GilaMonster (4/26/2012)
capn.hector (4/26/2012)
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what the problem was. this one. Wha??
If a boolean (bit) is 1, another parameter gets a '+' in front.
But this is what he said:
if i select true the other parameter value should include + infront fo fit.if i select no ,it should be same
If true should include '+'. If no it should be same. Does that mean it should also have a '+'?
It's really hard at times to really know what he is asking.
Actually, what I was laughing at is the mixed terms for the boolean. True and No. I always thought it was True/False, or Yes/No, or 0/1 (unless from Access, then it's 0/-1), or On/Off.
April 26, 2012 at 12:47 pm
But, of course a bit is not boolean in SQL Server unless declared with NOT NULL
It can work as a boolean but only for significantly large values of NULL. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 26, 2012 at 12:49 pm
Lynn Pettis (4/26/2012)
GilaMonster (4/26/2012)
capn.hector (4/26/2012)
Lynn Pettis (4/26/2012)
ROFLMAO!Definition of Clueless.
But do not fear, he will solve his problem.
at least on most of his other posts i could some what understand what the problem was. this one. Wha??
If a boolean (bit) is 1, another parameter gets a '+' in front.
But this is what he said:
if i select true the other parameter value should include + infront fo fit.if i select no ,it should be same
If true should include '+'. If no it should be same. Does that mean it should also have a '+'?
No. It should remain the same, ie unchanged.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 26, 2012 at 12:49 pm
Lynn Pettis
Actually, what I was laughing at is the mixed terms for the boolean. True and No. I always thought it was True/False, or Yes/No, or 0/1 (unless from Access, then it's 0/-1), or On/Off.
This would indicate that there is on/off or even black/white inside there...I think it is only slightly varying shades of nearly colorless gray.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
April 26, 2012 at 12:51 pm
Oh, so sad. He is claiming another victim.
Viewing 15 posts - 35,821 through 35,835 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply