Viewing 15 posts - 1,756 through 1,770 (of 2,458 total)
Building on Eirikur's solution here's a couple ways to do this without the outer apply...
If there only 1 trk element and only 1 trkseg with trkpt child elements you could...
February 13, 2015 at 3:26 pm
Couple things to note...
First, 2008 R2 has an EOMONTH function.
Second, if you want to assign those values using SQL and not an SSRS expression you could create...
February 13, 2015 at 1:31 pm
Bummer, I don't know anything about Dynamics. 🙁
February 13, 2015 at 1:12 pm
If I am not mistaken (forgive me, I have not done this in awhile) you can use a shared datasource. Say you have a shared datasource called DS1... You would...
February 13, 2015 at 12:46 pm
Ok, I put together some sample data that emulates (crudely) what it is I think you are working with... in the script below there is a table that contains multiple...
February 13, 2015 at 12:18 pm
clucasi (2/12/2015)
I have a sql table with the following information in one of the columns<CallSing xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><CallSign><FRSID>BG</FRSID><DeploymentGroup>SALF</DeploymentGroup><Eastings>384779000</Eastings><Northings>399005000</Northings><CurrentLocation>PRINCESS STREET MANCHESTER</CurrentLocation><HomeStation>G80</HomeStation><CurrentStationGround>G80</CurrentStationGround><LastStatusTimeStamp>20150210083237GS</LastStatusTimeStamp><CallSign>GA011</CallSign><ResourceType>AM</ResourceType><CurrentResourceStatus>AV</CurrentResourceStatus></CallSign>
<CallSign><FRSID>BG</FRSID><DeploymentGroup>SALF</DeploymentGroup><Eastings>396033000</Eastings><Northings>405503000</Northings><CurrentLocation>ROUNTREE HOUSE MANCHESTER STREET OLDHAM OL96HQ</CurrentLocation><HomeStation>G80</HomeStation><CurrentStationGround>G80</CurrentStationGround><LastStatusTimeStamp>20150203153228GS</LastStatusTimeStamp><CallSign>GA012</CallSign><ResourceType>AM</ResourceType><CurrentResourceStatus>AV</CurrentResourceStatus></CallSign>
Your request is a little ambiguous. What data...
February 12, 2015 at 11:08 am
Like many people I started out using maintenance plans then began writing my own scripts. Like Grant said, there's nothing that a maintenance plan does that you can't script out....
February 12, 2015 at 8:49 am
There are certainly a few things you can do to improve this. Can you post a sample XML file?
February 12, 2015 at 6:23 am
So I think of to compress the table with the aim of reducing I/O.
Compression will help reduce I/O
1. is that really suitable for this requirement?
Yes
If So which compression is...
February 11, 2015 at 9:12 am
Note the article in my signature about best practices on getting help. We would need some DDL to help you out. If you could attach the execution plan that would...
February 11, 2015 at 8:56 am
Here's what I came up with (Assuming this is what you are asking for).
-- SAMPLE DATA
DECLARE @salesbycategory TABLE (category varchar(20) not null, totalamt int not null);
INSERT @salesbycategory
SELECT *
FROM...
February 10, 2015 at 11:16 am
This is a little ambiguous. Can you post an example of what you want?
February 10, 2015 at 9:27 am
Can you post one of the new RDL files?
February 10, 2015 at 8:55 am
djj (2/10/2015)
Alan.B (2/10/2015)
CREATE TABLE dbo.T1 (col1 int primary key)
A clustered index is a "table" that is sorted by a specific key or combination of keys.
This...
February 10, 2015 at 8:23 am
This could be a lot of things causing the problem but the issue is with the resulting XML name spaces in your new reports. If your XML knowledge is good...
February 10, 2015 at 6:58 am
Viewing 15 posts - 1,756 through 1,770 (of 2,458 total)