Have you tried looked at...

andyscott (3/24/2015)

---

Does this report have to be written in T-SQL? Using an Excel pivot table with a data connection to the tables would allow for a dynamic output (as long...

I need to learn to read before posting.

It looks like you have an Un-escaped single quote somewhere in the code that creates the stylesheet, check the value of the...

I did something similar, and had a helpful hint from something that was posted here on SSC (Mr Magoo I think!!)

Basically this was the code I implemented to create a...

Can you not use the built in Geography STDistance method?

https://msdn.microsoft.com/en-gb/library/bb933808.aspx

It would help us if you could provide some consumable test data with expected results in the form of a temp table or table variable.

This would allow us to see...

Its a little more complex than I first thought, I need to sleep on it, as it feels as though you have to run each row through the splitter then...

Do you have the table definition (DDL) for this table, and 4/5 rows of sample data as that would be a great help in allowing people to give you a...

Something like this might be a good starting point.

DECLARE @Table TABLE

(

aValue VARCHAR(100)

)

INSERT INTO @Table

VALUES

('01/01/2013,250')

,('02/01/2013,200')

,('03/01/2013,350')

select

o.DateValue

,o1.Value

from @Table

cross apply (select Item AS DateValue FROM [Reporting].[SplitParam_test](aValue,',') WHERE ItemNumber = 1)...

It seems that you have a problem with your source data set, so start the Investigation there as the Merge key should be unique.

The script below should show you the...

Do you do regular Transaction Log backups as these will help keep the Log file in a reasonably trim state, as the Log back up will mark free up the...

Not sure if this will help but here is a link to a couple of examples https://msdn.microsoft.com/en-us/library/ms142575(v=sql.105).aspx

Effectively the sql appears to be

ALTER FULLTEXT INDEX ON <MyTable> START UPDATE POPULATION;

If you want to mimic the TRY_PARSE or TRY_CONVERT functions that are in 2012, then you may have to resort to a CLR to accomplish this, as you cant use...

That can be flawed as it depends on your date format, eg doing

SELECT ISDATE('31-01-2015')

SELECT ISDATE('31/01/2015')

On my machine both return...

Based on the Error that you have posted, the problem seems to be in the SOURCE dataset which is producing more than one match.

It could be that you...