Viewing 15 posts - 2,776 through 2,790 (of 2,838 total)
scott.pletcher (6/11/2010)
Yes, I took the short-cut, because as *I* pointed out the code will result in full scan anyway.
When...
--------------------------------------
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
June 11, 2010 at 12:15 pm
If you only have 3 months in your db per person at a time, then the following should work
SELECT Person,
CASE MonthTot
WHEN 6 THEN 1
WHEN 9 THEN 2
WHEN 12 THEN 3
WHEN...
--------------------------------------
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
June 11, 2010 at 11:58 am
I worked for a company that had a subscription to Experts Exchange and it was rare that I'd find any worthwhile answers there. Even rarer that I'd find an answer...
--------------------------------------
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
June 11, 2010 at 10:43 am
UMG Developer (6/11/2010)
--------------------------------------
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
June 11, 2010 at 10:01 am
So will future "questions of the day" just be proofreading? Find the misspelled word! I think of questions of the day as testing knowledge of concepts, not spellchecks. I know...
--------------------------------------
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
June 11, 2010 at 7:06 am
Richard Gardner-291039 (6/10/2010)
--------------------------------------
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
June 10, 2010 at 8:37 am
Richard Gardner-291039 (6/10/2010)
--------------------------------------
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
June 10, 2010 at 7:31 am
Richard Gardner-291039 (6/10/2010)
http://www.dailyhaha.com/_pics/hand_egg.jpg
I would recommend you actually start watching the football, the USA actually have more than a...
--------------------------------------
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
June 10, 2010 at 7:02 am
GilaMonster (6/9/2010)
Stefan Krzywicki (6/9/2010)
GilaMonster (6/9/2010)
Am I missing something here? http://www.sqlservercentral.com/Forums/Topic934829-146-1.aspx
Not that I can see. Base on the limited and incomplete information being provided, it does seem as if he or...
--------------------------------------
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
June 9, 2010 at 1:57 pm
Krasavita (6/9/2010)
I get this error. I am trying to copy table...
--------------------------------------
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
June 9, 2010 at 1:52 pm
GilaMonster (6/9/2010)
Am I missing something here? http://www.sqlservercentral.com/Forums/Topic934829-146-1.aspx
Not that I can see. Base on the limited and incomplete information being provided, it does seem as if he or she is getting...
--------------------------------------
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
June 9, 2010 at 1:49 pm
CirquedeSQLeil (6/9/2010)
Stefan Krzywicki (6/9/2010)
CirquedeSQLeil (6/9/2010)
Stefan Krzywicki (6/9/2010)
Steve Jones - Editor (6/9/2010)
Whoever has Cutler can keep him.
As a Packers fan, I'm fine with him right where he is.
Ship him to Green...
--------------------------------------
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
June 9, 2010 at 1:39 pm
I would suggest explicity stating each column you want to return in the query even if you want to return all 20. Using * is sloppy and can give you...
--------------------------------------
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
June 9, 2010 at 1:34 pm
CirquedeSQLeil (6/9/2010)
Stefan Krzywicki (6/9/2010)
Steve Jones - Editor (6/9/2010)
Whoever has Cutler can keep him.
As a Packers fan, I'm fine with him right where he is.
Ship him to Green bay or Minnesota...
--------------------------------------
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
June 9, 2010 at 1:30 pm
Steve Jones - Editor (6/9/2010)
Whoever has Cutler can keep him.
As a Packers fan, I'm fine with him right where he is.
Steve Jones - Editor (6/9/2010)
--------------------------------------
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
June 9, 2010 at 1:24 pm
Viewing 15 posts - 2,776 through 2,790 (of 2,838 total)