Viewing 15 posts - 781 through 795 (of 1,162 total)
Ok...not sure I understand the question then. In what way could you use SSRS with Silverlight 4?
The SSRS web front end does not use Silverlight, but you can embed SSRS...
April 18, 2011 at 10:17 am
This is specifically in relation to a CLR procedure, not a function. I don't believe SQL Server has any opportunity to parallelise execution of a CLR Procedure. How would it...
April 18, 2011 at 8:28 am
Still not understanding the problem. Rounding a float/real won't end up in this overflow unless you've reached the ceiling of the data type.
At which point are you implicitly converting it...
April 18, 2011 at 8:04 am
What's your calling application? Why are you not explicitly defining your data types before executing? The solution is to explicitly set your data type to the maximum precision and scale...
April 18, 2011 at 7:19 am
Tomas Bergvall (4/18/2011)
Doing the calculations in .Net does not remove parallelism since you can expicitly specify that in the code.
You can only multi-thread if you're running your CLR as UNSAFE...
April 18, 2011 at 6:55 am
This seems like a fairly inefficient method of doing this.
It may just be the way you're describing it, but if you're going to do your calculations in .Net code,...
April 18, 2011 at 6:35 am
If you post some sample data that actually represents what you're trying to do e.g. an XML document that looks like the one your referring to with multiple records and...
April 15, 2011 at 5:52 am
SQL Server's XML handling is pretty good. Basically you'll want to CROSS Apply using the XML.Nodes() method.
Here's the BOL reference:
April 15, 2011 at 5:12 am
Sorry, just realised that you've already looked at the KB I posted. It's actually not applicable to Windows 7 - there's an MS blog here detailing how to repair these...
April 15, 2011 at 3:54 am
I seem to remember most of the 6 month trial's of SQL Server are the Enterprise Edition.
Not sure if this link may help:
April 15, 2011 at 3:46 am
Ah, sorry, I misunderstood. So EOracle is a SQL Server DB and clm_edit_wq_clm is a view on it that uses a linked server to Oracle?
Yeah, that driver is a little...
April 14, 2011 at 1:52 am
Odd that it fails with a compatibility mode of 100 - I wonder if it's something to do with mapping from Oracle's dates to the new date/datetime2 data types.
Would you...
April 13, 2011 at 2:37 pm
Ok, the important thing to know is that the order of a select statement is never guaranteed unless you have an order by clause. If you want it to return...
April 13, 2011 at 6:50 am
The distinct operation must occur first because that's logically what you're asking from the query.
Reading between the lines of what you've said above, are you're saying that you sometimes receive...
April 13, 2011 at 6:37 am
Viewing 15 posts - 781 through 795 (of 1,162 total)