GBeezy (7/25/2014)

---

I actually got it to work...

I took just the UPDATE statement you provided, took out the variables, input what I needed, and I was able to update my column...

Quick question, can you post the execution plans?

😎

Quick suggestion using mickyT's data, mind you, as I posted before, that this is not accurate when using geometry.

😎

SELECT

*

FROM dbo.Location L

OUTER APPLY #Events E

WHERE L.coordinates.STBuffer(10000).STIntersects(E.coordinates) =...

Here is a quick solution, should get you passed this hurdle.

😎

USE tempdb;

GO

DECLARE @XML_ID INT;

DECLARE @FILE_NAME VARCHAR(255);

SET @XML_ID = 2;

SET @FILE_NAME = 'text_file.txt';

DECLARE @TXML XML ;

DECLARE @XML_TABLE TABLE (XML_ID INT IDENTITY(1,1)...

Not certain what the purpose of the RANK is there as it is not needed in the solution. Also, writing the code took a lot less time than formatting the...

It was removed after SQL Server 2005, this article might help

Where...

Quick and simple

😎

USE tempdb;

GO

/* LETS PRETEND THIS IS THE TABLE */

;WITH BASE_DATA AS

(

SELECT

ItemId

...

Slightly different flavour of the same

😎

DECLARE @TXML XML = '<?xml version="1.0" encoding="utf-8"?>

<DataSet xmlns="http://tempuri.org/">

<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="Table">

<xs:complexType>

<xs:sequence>

<xs:element name="KeyID" type="xs:string" minOccurs="0" />

<xs:element name="LicenseAcquisitionUrl" type="xs:string" minOccurs="0"...

Guess he merits a Master...

Thanks Gregory for this nice peace, good job!

Missed seeing one essential thing though in the injection part and that is a strong coupling to the metadata. If a user can...

Yes, unless it is wrapped in an explicit transaction.

😎

From a slightly humours point of view, often there is quite a resemblance to Chinese Whispers in Data Collection, Processing and Analysis processes, which in turn makes one at least...

You can use a variable if you have an expression for the relevant property in the connection manager.

😎

mallikachowdhary 98955 (7/24/2014)

---

Hi ,

I have a issue regarding a query showing very late response on one server while it works perfectly on another.

I have a job defined in SQL server...

dkriplani97 (7/24/2014)

---

create table #tmpcopylibrary

(

dataid int,

value int

)

insert #tmpcopylibrary select 1,999

UPDATE TableA

SET Value = isnull((select top 1 Value from...