Viewing 15 posts - 1,771 through 1,785 (of 2,838 total)
Also, here's the BOL entry for COALESCE
http://msdn.microsoft.com/en-us/library/ms190349.aspx
--------------------------------------
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
May 6, 2011 at 8:28 am
Paul Morris-1011726 (5/6/2011)
What I am trying to accomplish is the following:
I am trying to list the cases with the status 'filed' but...
--------------------------------------
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
May 6, 2011 at 8:26 am
Brandie Tarvin (5/6/2011)
Editor's Note:
--------------------------------------
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
May 6, 2011 at 6:40 am
jstrauch 3024 (5/5/2011)
--------------------------------------
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
May 6, 2011 at 5:51 am
Craig Farrell (5/4/2011)
Stefan Krzywicki (5/4/2011)
Craig Farrell (5/4/2011)
GSquared (5/4/2011)
Craig Farrell (5/3/2011)
--------------------------------------
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
May 5, 2011 at 10:48 am
440692 I am just a number (5/5/2011)
Stefan Krzywicki
I'm guessing you're not able to buy a version of SQL Server that comes with SSIS?
DOH! No SQL Server Agent jobs in...
--------------------------------------
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
May 5, 2011 at 8:46 am
440692 I am just a number (5/5/2011)
Stefan Krzywicki (5/5/2011)
There's a 64 bit version of the driver available herebut I don't know if that'll connect to your 32 bit office apps.
The...
--------------------------------------
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
May 5, 2011 at 8:19 am
Ninja's_RGR'us (5/5/2011)
That's only 10% of the problem.Run the same thing with 600 columns and 10 000 000 rows of data. :hehe:
This and flexibility with the addition of additional columns in...
--------------------------------------
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
May 5, 2011 at 8:12 am
There's a 64 bit version of the driver available here
but I don't know if that'll connect to your 32 bit office apps.
--------------------------------------
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
May 5, 2011 at 7:25 am
440692 I am just a number (5/5/2011)
I will follow up on these links.
A first try with installing the AccessDatabaseEngine was a little painfull.
I can only install the 32...
--------------------------------------
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
May 5, 2011 at 7:05 am
The next thing I'd try is to run it with a user mapped as database owner on futura_china. If that works, then the error is somewhere in your user permissions....
--------------------------------------
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
May 4, 2011 at 6:12 pm
kcheluvaraj 94771 (5/4/2011)
HiYes they are in futura_China database.
Are they views? If they're views it is possible that they are still pointing at tables on the old server. Look at the...
--------------------------------------
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
May 4, 2011 at 5:31 pm
Craig Farrell (5/4/2011)
Stefan Krzywicki (5/4/2011)
Craig Farrell (5/4/2011)
GSquared (5/4/2011)
Craig Farrell (5/3/2011)
--------------------------------------
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
May 4, 2011 at 5:26 pm
Craig Farrell (5/4/2011)
GSquared (5/4/2011)
Craig Farrell (5/3/2011)
--------------------------------------
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
May 4, 2011 at 1:46 pm
440692 I am just a number (5/4/2011)
--------------------------------------
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
May 4, 2011 at 1:42 pm
Viewing 15 posts - 1,771 through 1,785 (of 2,838 total)