Viewing 14 posts - 1 through 14 (of 14 total)
Solution:
What I didn't realise was the table alias name will take precedence over a column field name, so removing the table alias prefix from the ORDER BY is enough to...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
January 17, 2011 at 9:09 pm
Ok, penny has now dropped.
You are not suggesting to modify the entire condition, but extending the mapping table to include the "HomeSite = 'CIT'", "HomeSite <> 'CIT' with "GroupID =...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
November 18, 2008 at 10:11 pm
Thanks Garadin for the reply.
We are unable to use the hard coded strings as there are a few thousand records that need to be updated in each database and there...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
November 18, 2008 at 7:54 pm
The script only needs to run as a once off - pre upgrade (if that make sense) - but needs to run over a number of databases globally.
The task is...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
November 18, 2008 at 5:21 pm
Nayak,
I understand where you are coming from and it does always depend on your audience.
If there is a chance that the report can be viewed by...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
November 5, 2008 at 11:08 pm
I have seen a lot of posts on how to format dates, and it still astounds me that in an age of global software and multinational corporations, we are still...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
November 5, 2008 at 3:42 pm
Thankyou Jeff for the vote of confidence. It is good to know I also have a like minded person somewhere out there.
It is always troubling when you are at...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
October 2, 2008 at 7:39 pm
You have found one of my little bug bears here. There is no excuse for producing badly formatted code. Just because code has to go in quickly does...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
October 2, 2008 at 5:04 pm
The naming convention I prefer is as follows.
Table Names :
Use the plural of the entity.
Customers
Parent Child tables :
...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
September 30, 2008 at 6:19 pm
fisher08 (6/27/2008)
John Oliver (6/25/2008)
If you know that the data...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
June 29, 2008 at 5:57 pm
Agree with Stephanie and Jeff, but only on the condition that length of the data is always going to be the same.
If you know that the data is always going...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
June 25, 2008 at 5:49 pm
Glad I'm not the only one that was confused by this question.
The question stated
"The question is to have list off all employees with the employees with DateOfLeaving coming last and...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
June 23, 2008 at 5:49 pm
Tim,
very interesting article, and rather frightening what some feel is "the zone".
To me, the zone is the state of mind where all of my focus is...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
June 19, 2008 at 1:07 am
Hoila,
If the original SP contains a number of fields you are not interested in, then you are going to have to watch for duplicates in the set of...
-- John Oliver
Sometimes banging your head against a wall is the only solution.
September 15, 2003 at 11:38 pm
Viewing 14 posts - 1 through 14 (of 14 total)