Viewing 15 posts - 1 through 15 (of 86 total)
Thanks Sue.
That link is a great resource!
Cheers,
G
August 12, 2019 at 11:14 am
Hi Solomon,
Thank you for the response.
The concern is specifically that the data will be intercepted in transit between the SQL server and NFS whilst using a BULK INSERT.
Cheers,
G
April 9, 2019 at 8:43 am
Try the following:
--Load sample data
CREATE TABLE #Invoice (ID INT, InvoiceNumber INT, Created DATETIME)
INSERT INTO #Invoice
SELECT 6,125870808, '2012-12-18 15:45:30.000'
UNION ALL
SELECT 5,125870808, '2012-12-18 12:23:27.000'
UNION ALL
SELECT 4,125870808, '2012-12-18 06:45:06.000'
UNION ALL
SELECT 3,125870808, '2012-12-18...
December 21, 2012 at 2:51 am
It appears it is not possible in SharePoint integrated mode; only in native mode.
http://msdn.microsoft.com/en-us/library/ms160348%28v=sql.100%29.aspx
For a report published to a report server configured for native mode, use a full...
January 26, 2012 at 8:48 am
Hello,
Apologies to necro the thread but I got distracted before I could respond to the thread.
Thank you for the suggestions Lynn. However I just managed to confuse myself building a...
October 25, 2011 at 9:41 am
My original post appears to be ambiguous.
There are multiple databases on the server and I need the login and role for each database.
I couldn't find a link between sys.server_principals and...
September 30, 2011 at 1:29 pm
Thanks.
I was also adapting the expression for the sub total which put the sum over the entire expression.
My final expression:
=SUM(Fields!Quantity.Value*Fields!Price.Value / SUM(Fields!Quantity.Value))
Cheers for the feedback!
G
July 1, 2011 at 7:17 am
Hi,
Thanks for taking a look.
That is essentially the formula I have in place. However in my matrix totals I'm getting 1.35 for total price where I would like to get...
June 29, 2011 at 1:02 pm
Thanks for your sharing your experience guys.
I was getting the feeling that I was somehow missing something obvious in this.
May 27, 2011 at 1:00 am
Hi everyone.
Thanks for taking time to share your knowledge.
The solution I've taken is to update the statistics with full scan on the two tables pTransaction and pTransactionGroup.
Initially I only updated...
January 18, 2011 at 3:12 am
Hi and apologies for my splintered responses.
Below are the sats IO results and the execution plans. I believe the sql query can be obtained from the execution plan (right click...
January 18, 2011 at 12:19 am
Hi thank you both for your feedback!
It seems that Gila's assumption is correct, at first glance the execution plans for db1 and db2 looked the same in terms of operations...
January 17, 2011 at 1:58 am
Thank you both for taking time to look at my problem.
Peter the code and link to the function have been incredibly helpful and have opened up a new avenue for...
December 13, 2010 at 11:31 pm
Hi Jef, that is correct.
The account belongs to Bob for period 200801 - 200802 and to Fred from 200803 onwards.
G
November 26, 2010 at 2:32 am
Thanks for this.
Is there a benefit to using the Cross Apply , I've never used it before ...
November 25, 2010 at 7:59 am
Viewing 15 posts - 1 through 15 (of 86 total)