Viewing 15 posts - 2,761 through 2,775 (of 2,861 total)
My deeepest sympathy - I have been through similar situation. (Note my white hair...)
What version of Windows/SP are you running on your workstation?
March 11, 2011 at 11:18 am
I am afraid there is no "silver bullet" solution.
You can use a Data Flow task, with several flows if data goes into several tables, or a Script Task. In...
March 11, 2011 at 11:14 am
For our BI app, we have 64 GB quad servers; we prefer to scale out.
Our largest cube is about 300 GB.
March 11, 2011 at 10:12 am
Yes, that would work. For larger tables I would do this:
SELECT Item,
Location,
SUM(Qty) Qty,
...
March 10, 2011 at 2:05 pm
Well, that explains it - my code was written (and runs) under 2008 R2.
I will try to ocme up with something backward compatible.
March 10, 2011 at 12:57 pm
This works (add after your INSERT):
--===== If the temp table already exists, drop it
IF OBJECT_ID('TempDB..#temp','U') IS NOT NULL DROP TABLE #temp
--===== Create the temp table...
March 10, 2011 at 10:29 am
I would also check whether the user ID has access to the database you are trying to open. The fact that the ID is defined does not mean much.
March 10, 2011 at 9:39 am
Please send me your e-mail address and I will mail you my white paper on this subject.
January 28, 2011 at 9:22 am
These two have nothing in common.
Writeback is a OLAP technique that allows exchange of data between Analysis Server and a pivot table in an Excel book. You can find...
January 26, 2011 at 11:08 am
I am on Zune BI. In our biggest data mart table we are getting a row whenever anyone with a Zune device, Zune PC Client or one on Xbox plays...
January 14, 2011 at 11:21 am
Oh well, I feel I am getting old.
As several times before, I need to point out that the decison what is more important (to be up ASAP or to be...
January 7, 2011 at 1:02 pm
cengland0 (1/6/2011)
There are several ranking functions:. . . One row is still a non empty rowset but that was not explained in the provided explanation.
You are absolutely right. Thank...
January 6, 2011 at 9:16 am
Eric Russell 13013 (1/5/2011)
January 5, 2011 at 12:31 pm
Gee, lots of code but actually very simple -- thanks!
January 3, 2011 at 11:05 pm
You may wish to start by reading --
http://msdn.microsoft.com/en-us/library/ee523927(SQL.100).aspx.
January 3, 2011 at 10:43 am
Viewing 15 posts - 2,761 through 2,775 (of 2,861 total)