June 6, 2012 at 4:55 am
So, the house next door went up for short sale. I've seen this house at its worst (when it needed a serious overhaul) and it's looking pretty good right now. It's going for $169k (with a pool) that makes me wonder what my house with one of the largest backyards in the neighborhood is going for.
Maybe I should buy it as a place to store my junk. @=)
June 6, 2012 at 8:46 am
Brandie Tarvin (6/6/2012)
So, the house next door went up for short sale. I've seen this house at its worst (when it needed a serious overhaul) and it's looking pretty good right now. It's going for $169k (with a pool) that makes me wonder what my house with one of the largest backyards in the neighborhood is going for.Maybe I should buy it as a place to store my junk. @=)
Junk is like a gas, it expands to fit the volume of the space provided.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 6, 2012 at 8:47 am
Brandie Tarvin (6/6/2012)
GilaMonster (6/6/2012)
Revenant (6/5/2012)
Nope - they know you are a safe-to-deal-with customer and they hope that you will get into minus on your checking account, and they will charge you something like $10-15 for transferring money from your savings account to your checking account to "protect your credit rating."Except that transfers between linked accounts are absolutely free with the options I have. I transfer money between cheque and savings every month. Transfers to my credit card are also free unless done via telephonic banking, which I never use
It's data mining at its
bestworst. They see you as a customer with fundage and see that you're transferring money yourself. If they offer you the automatic version, they make money and "you don't have to worry about it anymore." Like Revenant said. Pure gravy. Assuming they can get you to sign up for it.
Plus, highlights once again the catch-22 in banking, if you have money you can get money, but if you don't have money (and need money), you can't get any money.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 6, 2012 at 10:50 am
To answer the original question for this thread, it must be yes.
blampe (6/6/2012)
Thank you all for your responses ..... I was able to get the procedure to run, but now when I call the procedure it gives me an error. It's just another of those pesky syntax errors but I'll post the procedure call below and the error if you guys have any ideas. thanksexec insert_table_column(dbo, test1, ssn, 1) --error occurs in the procedure call
--Msg 102, Level 15, State 1, Line 1
--Incorrect syntax near 'dbo'.
June 6, 2012 at 11:28 am
Lynn Pettis (6/6/2012)
To answer the original question for this thread, it must be yes.blampe (6/6/2012)
Thank you all for your responses ..... I was able to get the procedure to run, but now when I call the procedure it gives me an error. It's just another of those pesky syntax errors but I'll post the procedure call below and the error if you guys have any ideas. thanksexec insert_table_column(dbo, test1, ssn, 1) --error occurs in the procedure call
--Msg 102, Level 15, State 1, Line 1
--Incorrect syntax near 'dbo'.
Makes me reach for a bottle of single malt... :w00t:
June 6, 2012 at 12:14 pm
For a real 'needs alcohol thread'... http://www.sqlservercentral.com/Forums/Topic1311832-1550-1.aspx
I do love the last comment.
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
June 6, 2012 at 1:22 pm
Brandie Tarvin (6/6/2012)
GilaMonster (6/6/2012)
Revenant (6/5/2012)
Nope - they know you are a safe-to-deal-with customer and they hope that you will get into minus on your checking account, and they will charge you something like $10-15 for transferring money from your savings account to your checking account to "protect your credit rating."Except that transfers between linked accounts are absolutely free with the options I have. I transfer money between cheque and savings every month. Transfers to my credit card are also free unless done via telephonic banking, which I never use
It's data mining at its
bestworst. They see you as a customer with fundage and see that you're transferring money yourself. If they offer you the automatic version, they make money and "you don't have to worry about it anymore." Like Revenant said. Pure gravy. Assuming they can get you to sign up for it.
Probably not.
Certainly banks are pretty rapacious anywhere, but the USA banks are more so.
For example in the UK you can set things up so that there is an automatic transfer between you savings account and your current so that the current account ends up with a final balance for the day of whatever is the least of some fixed sum (say £200) and the total amount of money in the two accounts, and there'll be no charge for those transfers. And typically you don't pay any charges for an arranged overdraft other than interest on average end of day balance over a month. It's many many years since I last paid any sort of bank charge in the UK. The bad news is that interest rates on small (less than half a million pounds) balances in an ordinary savings account are typically 0.01% or something equally ludicrous (so I now have no savings accounts with British banks - switched it all over to shares and bonds).
In Spain, I find I can bank for free provided I push at least 10k Euros into the account each year; or if I buy 5000 share in my bank.. Since 10k Euros is not enough for the two of us to live on in the two thirds or more of each year we are here I didn't need to buy the shares. I do get caught through having to have a fiscal activity certificate for the Spanish government - the bank charges (peanuts) for producing that; but when I get around to obtaining a NIE and registering an NIF and formalising my residency status that should go away, I hope.
I suspect bank charges in SA are more like those in the UK or Spain than those in the USA.
Tom
June 6, 2012 at 1:57 pm
L' Eomot Inversé (6/6/2012)
I suspect bank charges in SA are more like those in the UK or Spain than those in the USA.
Very much so. I can set automatic transfers as much as I like between my accounts with no charge. I can transfer to and from my credit card with no charge. I can transfer to my homeloan without charge (and withdraw from it if I've paid more than I need to, which I do). The only way the bank would make money on an overdraft is if my cheque account actually went negative for more than a day.
Properly done data mining should tell them that a person who has never once dropped the total amount in their accounts below 10*x is a poor target for an overdraft of x (especially since trivial investigation would tell them that I earned more than x/month at the time)
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
June 6, 2012 at 4:40 pm
GilaMonster (6/6/2012)
L' Eomot Inversé (6/6/2012)
I suspect bank charges in SA are more like those in the UK or Spain than those in the USA.Very much so. I can set automatic transfers as much as I like between my accounts with no charge. I can transfer to and from my credit card with no charge. I can transfer to my homeloan without charge (and withdraw from it if I've paid more than I need to, which I do). The only way the bank would make money on an overdraft is if my cheque account actually went negative for more than a day.
Properly done data mining should tell them that a person who has never once dropped the total amount in their accounts below 10*x is a poor target for an overdraft of x (especially since trivial investigation would tell them that I earned more than x/month at the time)
Sounds fair.
Most North American banks will charge you one time fee for getting into minus which may be eventually covered by automatic transfer from say savings; that's $10-15 I mentioned. They are, however, under legal obligation to post any deposits for the day first and only then debits, so if you say have a purchase that gets you into minus but your employer posted to pay the same day, that temporary minus does not show the next day because the salary is credited first and only then go debits.
To make it work this way - to your advantage - you need overdraft, otherwise the first debit that gets you into red will get rejected as NSF.
June 7, 2012 at 6:44 am
All,
If you have a LinkedIn account, you should change your password immediately. Their servers got hacked and millions of passwords were stolen. Not everyone is affected, but it's better to be safe than sorry.
http://news.yahoo.com/blogs/cutline/linkedin-hack-leak-passwords-stolen-144334662.html
June 7, 2012 at 7:05 am
Brandie Tarvin (6/7/2012)
All,If you have a LinkedIn account, you should change your password immediately. Their servers got hacked and millions of passwords were stolen. Not everyone is affected, but it's better to be safe than sorry.
http://news.yahoo.com/blogs/cutline/linkedin-hack-leak-passwords-stolen-144334662.html
True, if someone else logged into my linked-in account I might never notice. 🙂 Probably the least used/useful social network I belong to.
--------------------------------------
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 7, 2012 at 7:13 am
Stefan Krzywicki (6/7/2012)
Brandie Tarvin (6/7/2012)
All,If you have a LinkedIn account, you should change your password immediately. Their servers got hacked and millions of passwords were stolen. Not everyone is affected, but it's better to be safe than sorry.
http://news.yahoo.com/blogs/cutline/linkedin-hack-leak-passwords-stolen-144334662.html
True, if someone else logged into my linked-in account I might never notice. 🙂 Probably the least used/useful social network I belong to.
I use it a lot. I get job offers daily through LinkedIn. Which I all immediately turn down 😀
But I got my last two jobs through my network, so it does have it's merits.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 7, 2012 at 7:16 am
Koen Verbeeck (6/7/2012)
Stefan Krzywicki (6/7/2012)
Brandie Tarvin (6/7/2012)
All,If you have a LinkedIn account, you should change your password immediately. Their servers got hacked and millions of passwords were stolen. Not everyone is affected, but it's better to be safe than sorry.
http://news.yahoo.com/blogs/cutline/linkedin-hack-leak-passwords-stolen-144334662.html
True, if someone else logged into my linked-in account I might never notice. 🙂 Probably the least used/useful social network I belong to.
I use it a lot. I get job offers daily through LinkedIn. Which I all immediately turn down 😀
But I got my last two jobs through my network, so it does have it's merits.
Oh, I'm sure it does for some people. My jobs tend to come through agencies I already work with or Dice.com
--------------------------------------
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 7, 2012 at 7:24 am
I hate to say it, but social fluff works.
I got my latest job via Twitter. Sounds impossible, but it is so.
-- Gianluca Sartori
June 7, 2012 at 8:06 am
My co-worker is leaving soon, so yesterday my manager asked me job description / keywords he should use in a job posting.
We are open to some suggestions on how to attract good candidates.
HR wants to be very generic, but we are much closer to the work and don't want to waste time on sorting through a bunch of applicants.
We're looking for someone who can do ETL (SSIS), as well as develop SSRS Reports / PerformancePoint Dashboards in Sharepoint 2010, and is familiar with Cube structure, MDX to build and maintain a cube (SSAS).
What keywords would you search on?
We struggle a bit as this seems to be quite the wide skillset.
Viewing 15 posts - 36,406 through 36,420 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply