June 22, 2012 at 9:21 am
Lynn Pettis (6/22/2012)
I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛
I certainly hope you don't feel insulted!!! It just hit me as I was typing and found it too funny not to post. We are all guilty of it but by your own admission you can't help yourself. 😀
_______________________________________________________________
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/
June 22, 2012 at 9:22 am
Sean Lange (6/22/2012)
Lynn Pettis (6/22/2012)
I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛I certainly hope you don't feel insulted!!! It just hit me as I was typing and found it too funny not to post. We are all guilty of it but by your own admission you can't help yourself. 😀
Trust me, I wasn't insulted. I actually found it funny, and true.
June 22, 2012 at 9:23 am
Sean Lange (6/22/2012)
Lynn Pettis (6/22/2012)
I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛I certainly hope you don't feel insulted!!! It just hit me as I was typing and found it too funny not to post. We are all guilty of it but by your own admission you can't help yourself. 😀
It's also why I had to poke some fun at you on the other thread. 😉
June 22, 2012 at 9:29 am
Lynn Pettis (6/22/2012)
Sean Lange (6/22/2012)
Lynn Pettis (6/22/2012)
I'm trying to decide if I should be happy or insulted, I mean really, Lynndrome? 😉 :w00t: 😛I certainly hope you don't feel insulted!!! It just hit me as I was typing and found it too funny not to post. We are all guilty of it but by your own admission you can't help yourself. 😀
It's also why I had to poke some fun at you on the other thread. 😉
Guilty as charged. :blush:
_______________________________________________________________
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/
June 22, 2012 at 11:15 am
L' Eomot Inversé (6/20/2012)
The thread seems very quiet. I've been away three days and there are only 62 new posts on it.But I may not find the energy to read even those few posts.
Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would be fixed quickly, and didn't worry much, but the medical team discovered it was not quite so simple late last week. Ann and I flew back to the UK on Friday night and I spoke to Nikki at the hospital by phone on Saturday, and she seemed fairly OK, so I planned to go up and see her on Monday. Then on Sunday I got a call from the hospital - it wasn't just not quite so simple, but a good deal worse. I drove up on Monday morning and spent most of 3 days visiting there, mostly with Nikki but also talking to the medical team. Early this afternoon teh medical team's view changed from "difficult to deal with" to "not curable, only limited palliative measures possible, unlikely to be able to return home". Her mother, Ann, was too ill to travel on Monday so I came back this afternoon to pick her up and will drive back up there with her tomorrow, so that she too can visit.
Sorry to hear that Tom. Praying for peace for the family.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 23, 2012 at 11:21 am
L' Eomot Inversé (6/20/2012)
Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would be fixed quickly, and didn't worry much, but the medical team discovered it was not quite so simple late last week. Ann and I flew back to the UK on Friday night and I spoke to Nikki at the hospital by phone on Saturday, and she seemed fairly OK, so I planned to go up and see her on Monday. Then on Sunday I got a call from the hospital - it wasn't just not quite so simple, but a good deal worse. I drove up on Monday morning and spent most of 3 days visiting there, mostly with Nikki but also talking to the medical team. Early this afternoon teh medical team's view changed from "difficult to deal with" to "not curable, only limited palliative measures possible, unlikely to be able to return home". Her mother, Ann, was too ill to travel on Monday so I came back this afternoon to pick her up and will drive back up there with her tomorrow, so that she too can visit.
Tom, I'm so sorry to hear about this. My thoughts and prayers are with your daughter and your family.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 24, 2012 at 12:11 pm
L' Eomot Inversé (6/20/2012)
Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would be fixed quickly, and didn't worry much, but the medical team discovered it was not quite so simple late last week. Ann and I flew back to the UK on Friday night and I spoke to Nikki at the hospital by phone on Saturday, and she seemed fairly OK, so I planned to go up and see her on Monday. Then on Sunday I got a call from the hospital - it wasn't just not quite so simple, but a good deal worse. I drove up on Monday morning and spent most of 3 days visiting there, mostly with Nikki but also talking to the medical team. Early this afternoon teh medical team's view changed from "difficult to deal with" to "not curable, only limited palliative measures possible, unlikely to be able to return home". Her mother, Ann, was too ill to travel on Monday so I came back this afternoon to pick her up and will drive back up there with her tomorrow, so that she too can visit.
Tom, I can't imagine how you and Ann must be feeling. I mean, facing the possibility of losing a child? I have three children of my own, and I'd feel totally lost in a situation like this.
I'm an atheist, so I won't pretend I would be praying for Nikki, but still, I feel with you and your family. May the doctors find a way to help Nikki. Miracles do happen every now and again.
June 25, 2012 at 8:24 am
Brandie Tarvin (6/20/2012)
SteveBell (6/20/2012)
Brandie Tarvin (6/20/2012)
Stefan Krzywicki (6/20/2012)
Oracle's documentation is less than stellar, for one thing, so when I try to look up things about the Oracle Home directory I feel like I'm a fictional detective trying to track down my arch nemesis.Sigh.
My brain is itching. It wants to write this story. As if I didn't have enough projects to work on as it is...
Write Brandy! Write like the wind!
Ummm. Okay.
"Like the wind."
Yeah, "write like the wind" doesn't work. However, the original "Run! Run like the wind!" was a tear jerker in Lassie 😛
June 25, 2012 at 8:49 am
Don't you love columns with "number" in the name that are typed as char or varchar?
--------------------------------------
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 25, 2012 at 8:55 am
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?
Or the date ones...
InsertedDateTime int
BAH!!!
_______________________________________________________________
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/
June 25, 2012 at 9:25 am
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
There should be a stretch of hard labor for crimes like this.
June 25, 2012 at 9:27 am
Revenant (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
There should be a stretch of hard labor for crimes like this.
Or for having leading 0s in your data.
--------------------------------------
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 25, 2012 at 9:49 am
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
Or VarChar(1)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 25, 2012 at 10:06 am
SQLRNNR (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
Or VarChar(1)
Oh yes! I think varchar(1) should be instantly punished. That one makes me crazy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2012 at 10:08 am
Stefan Krzywicki (6/25/2012)
Revenant (6/25/2012)
Sean Lange (6/25/2012)
Stefan Krzywicki (6/25/2012)
Don't you love columns with "number" in the name that are typed as char or varchar?Or the date ones...
InsertedDateTime int
BAH!!!
There should be a stretch of hard labor for crimes like this.
Or for having leading 0s in your data.
I can actually see the leading zeros because of certain business scenarios, but all the others, and Jason's Varchar(1)? The offenders are sentenced "to the pain" by porkchop launcher.
My "favorite" is people (not DBAs) who insist on using GUIDs because that's the thing that everyone does, and not because they actually need unique identifiers.
That and people who use character types for money / date storage, then wonder why they can't use math and date functions on the column, or why it won't convert properly. (How did ABC get into my date column?)
Viewing 15 posts - 36,631 through 36,645 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply