It depends on if all the data is exactly formatted like the one example.

i'd lean more towards splitting the data, and not assuming there are three parts every time.

changing the...

in that case, you need to join against a calendar of months, and simply group by month

something like this is an example

CREATE TABLE #TallyMonthCalendar(TheMonthStart date)

INSERT INTO #TallyMonthCalendar

SELECT dateadd( mm,-48...

glad you found the issue and posted back , Wayne; that information will probably help someone else in the future.

WTG

oh, i wish i was running pure 2012 and above...that would...

i might be reading the question too simply;

can you just sum up the differences btween the two dates?

--days

/*--Results

account loc (No column name)

1 ...

convert the value to varchar instead and a temp table , and do a CASE WHEN ISNumeric(ConvertedValue) = 0 THEN 'whoops' ELSE' good conversion' END.

as everyone else has already identified,...

i don't update the registry, but i have a lot of admin scripts that do things like read the registry data/log/backup folders from the registry, so i can use them...

you need to cross apply any nodes that you expect multiple values from;

something like this example might help.

DECLARE @xml XML

SELECT @xml='<Root>

<Data>

<Item ID="1" AdditionalInfo="Some info">

<SubItem ID="1">apples</SubItem>

<SubItem ID="2">oranges</SubItem>

<SubItem ID="3">cherries</SubItem>

</Item>

<Item ID="2" AdditionalInfo="Some info">

<SubItem...

ok i think that requires data driven subscriptions, which require Enterprise Edition, so make sure you have that.

when you create a shared schedule in Reporting Services, there's a third selection...

you need to make sure the sub report fits inside the main report panel you defined, i think.

a common mistake is where the main report and the sub report are...

those files are on your local C drive, and not on the internet...we can't see them.

DuncEduardo (2/2/2015)

---

Here is the SQL to create Sequence, destination Dimension and initial Dimension population:

C:\Users\dunsmi\Pictures\VGroup\SCD.png[/...

does this get you started, by normalizing and doing a preliminary join?

WITH BarsNormalized

AS

(

select * from #Wobbly

CROSS APPLY dbo.DelimitedSplit8K(Scotch,';') F1

)

SELECT T1.Bar ,T1.Item As ScothName,T2.Bar

FROM BarsNormalized T1

LEFT OUTER JOIN BarsNormalized T2 ON...

you would typically do formatting in the application, and not in the database.

because you want to mix data types, ie decimal(19,3) and integer , you need to either format as...

the dateadd and datediff functions together, are the best ways to do this.

so you might now that getdate() is the right now timestamp, all the way down to milliseconds.

by using...

i have a dashboard, that pulls multiple sub reports from a couple of central tables;

those tracking tables get populated by queries/sql jobs that grab statistics and insert them into...