Please what you tried so far?

Here is my guess you need combine two tables into one first

with allRatings as (

select * from [dbo].[InputTest1]

union all

select *, null as [FormOrderForInstnRating],null as [SortOrder]

from...

Ok, do it with string manipulation. You may eliminate inner CAST if building entire string this way. But for redability i just use two CASTs.

if object_id('Tempdb..#Element1') is not null drop...

You may wish to add root element to keep output well-formed xml document when Element1 table has more rows . And subgroups naming may be rendered with attribute which...

To optimize a bit further why declare namespace which is never used in the query

;WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition')

SELECT

D.field1.value('(SharedDataSet/DataSet/Query/CommandText/text())[1]','VARCHAR(50)') AS CommandText

FROM #demo D;

You are welcome.

Xquery must contain namespace declaration as it is dealing with namespaced xml.

select field1.query('declare namespace x="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition";

/x:SharedDataSet/x:DataSet/x:Query/x:CommandText') from #demo

See http://blogs.msdn.com/b/ssdt/archive/2015/09/01/sql-server-data-tools-preview-update-for-august-2015.aspx

May be you should wait till post-august2015-preview SSDT RTM is released.

Just don't answer in a hurry, wait a...

I combine -- and /* to make it a bit easier but still have to edit code.

WITH CTE(x) AS (

SELECT NULL

)

/* possible comment */

-- /*

SELECT...

Manic Star (9/22/2015)

kim / data detection group (9/17/2015)

There are LOTS of times when I need to use a simple local function within a stored procedure, but have to create and...

CREATE TABLE #Activities(activityName NVARCHAR(100))

?

If the first word contains digit then sort by first word parts second part considered to be integer. Otherwise sort by hole column

select activityName

from #Activities

cross apply (select

...

Note 30days.. is not valid column name anyway.

8000 limit doesn't apply to sp_executesql if only you are not quering linked server, OPENQUERY may be.

Probably it's cycle detection problem

The query below will return all cycles containing 52342-00

with r as (

select parentid , DetailComponent , DetailLevel

, cast( '->' + DetailComponent + '->' ...

You may unpivote fixed number of columns and select specified col value without dynamic SQL

declare @t table (

id int identity

,ref01 varchar(10)

,ref02 varchar(10)

,ref03 varchar(10)

,ref04 varchar(10)

,ref05 varchar(10)

,ref06 varchar(10)

);

insert @t values ('a-ref01','a-ref02','a-ref03','a-ref04','a-ref05','a-ref06')

...