Viewing 15 posts - 151 through 165 (of 637 total)
See picture below you can clearly see there are more than 5 subscriptions
These were added today. Only 2 of them got executed ( They were there before today...
April 21, 2017 at 12:55 pm
April 20, 2017 at 3:53 pm
April 20, 2017 at 3:27 pm
April 20, 2017 at 3:12 pm
Listing 1 works
Listing 2 - I amnot getting a value for the columm January. I know for sure there is a report out there where the <JANUARY>true</JANUARY> exists for...
April 20, 2017 at 3:11 pm
April 20, 2017 at 2:55 pm
The one below works..... Can someone help me extract the [days] and [January]... please
declare @xml xml
SET @xml =
'<ScheduleDefinition xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StartDateTime xmlns:xsd="http://schemas.microsoft.com/sqlserver/2006/03/15/reporting/reportingservices">2015-04-23T08:00:00.000-04:00</StartDateTime>
April 20, 2017 at 2:36 pm
April 20, 2017 at 2:24 pm
April 20, 2017 at 1:52 pm
April 20, 2017 at 1:44 pm
OK, I am close, but I need some XML manipulation help. So the matchdata column in the SUBSCRIPTION table has all the schdule info. It is in XML. I need...
April 20, 2017 at 12:18 pm
April 19, 2017 at 3:54 pm
April 19, 2017 at 1:23 pm
Thom A - Wednesday, April 19, 2017 12:33 PMWhat have you tried so far to limit your result set?
Only the query that I...
April 19, 2017 at 12:46 pm
April 19, 2017 at 10:06 am
Viewing 15 posts - 151 through 165 (of 637 total)