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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
February 13, 2015 at 1:31 pm
Bummer, I don't know anything about Dynamics. 🙁
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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....
-- Itzik Ben-Gan 2001
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?
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
February 10, 2015 at 11:16 am
This is a little ambiguous. Can you post an example of what you want?
-- Itzik Ben-Gan 2001
February 10, 2015 at 9:27 am
Can you post one of the new RDL files?
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
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...
-- Itzik Ben-Gan 2001
February 10, 2015 at 6:58 am
Viewing 15 posts - 1,756 through 1,770 (of 2,458 total)