Phil Parkin (9/7/2016)

---

One thing missing from SQL Prompt, however, is the ability to change between 'my' settings (whatever works for the individual) and 'company' settings (the common format). I'd love...

You need to extract the <ConnectString> text() node as shown previously, then use something like DelimitedSplit8K[/url] to split that string into pieces.

I'm sorry but I don't have time right now...

mw112009 (8/26/2016)

---

Question

Consider the segment of xml pasted below

<DataSources>

<DataSource Name="EDW">

<DataSourceReference>EDW</DataSourceReference>

<rd:SecurityType xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">None</rd:SecurityType>

<rd:DataSourceID xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">91905df0-3a05-4d1b-a59b-568a018c7ad1

</rd:DataSourceID>

</DataSource>

</DataSources>

The Query works fine, except i am not getting a value for the <DataSourceReference> ,

So the last item in my...

mw112009 (8/26/2016)

---

This seems like a close solution to what I want. However I am getting a syntax error ( listed below ) Can you help me with the syntax.

WITH XMLNAMESPACES(...

The content column of the catalog is xml data, so why not query it as such?

I don't have a sql 2012 RS database to grab the correct namespace and I...

Sergiy (8/24/2016)

---

mister.magoo (8/23/2016)

---

To answer your question about how (not getting involved in why)

declare @x xml;

select @x=(

select ''+b

from

(

select 'hello;friend'+CHAR(13)+CHAR(10)

union all

select 'my;world'+CHAR(13)+CHAR(10)

)a(b)

for xml path(''),type);

select @x.value('(./text())[1]','nvarchar(max)')

the important things are to use ",type"...

To answer your question about how (not getting involved in why)

declare @x xml;

select @x=(

select ''+b

from

(

select 'hello;friend'+CHAR(13)+CHAR(10)

union all

select 'my;world'+CHAR(13)+CHAR(10)

)a(b)

for xml path(''),type);

select @x.value('(./text())[1]','nvarchar(max)')

the important things are to use ",type" in the...

when i need to compare two floats, I tend to use this syntax

WHERE ABS(Float1 - Float2)<@Variance

So, for comparing to 2 d.p. I set @Variance = 0.01

to compare to 4 d.p....

How is this not just a simple update/cte?

WITH CTE AS

(

SELECT

seq

, ROW_NUMBER() OVER

(

...

Will Stillwell (7/22/2016)

---

Lowell (7/22/2016)

---

I'm betting you are not handling nulls correctly; you have to isnull every column as you build the...

Two options come to mind.

Make your column width such that no more than three columns fit per page, this will cause automatic page breaks.

The method you tried but with this...

Kasinathan (7/15/2016)

---

Hi thanks for your solutions, its working fine. but need to add value for element and also in attribute. for eg:

<cac:LegalMonetaryTotal>

...

You could try deleting the user data from %LOCALAPPDATA%\Microsoft\SQL Server Management Studio\13.0

This is a bit like a "Reset To default" for SSMS, so expect to lose settings - but that's...

It's working for me here :ermm:

The default colour is set here:

You don't have any add-ins/extensions do you ?

Unless you have dumbed something down drastically and this isn't really what you are trying to do, this is far simpler and does what you want:

GO

WITH XMLNAMESPACES (...