Good stuff, make certain you get the spelling right:-D

😎

klgould1 (9/17/2014)

---

Hoping someone maybe able to assist with this procedure.

I am trying to increase the price of an product by a user entered % for items with Dishwasher in the...

Maybe this article Migrating a Database to SQL Azure using SSDT will help

😎

nikhil.desai1 (9/19/2014)

---

Hi,

I our SQL server project we are using xp_cmdshell to generate .txt or .csv file. As per SQL sever hardening xp_cmdshell is a security risk. Is there any alternative...

Guess...

okbangas (9/20/2014)

---

I've searched a bit, and from what I can see, both Geometry and Gography stores the coordinates as IEEE 754 64-bit float internally, hence there is no difference in...

enriquemallon (9/20/2014)

---

I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users,...

I thought that might be the case;-)

Here is an adjustment to the code, picks the two last entries for each subject

😎

create table #temp(candId int identity(1,1),CanNum int,name varchar(50),Attempt1 int,Attempt2 int,attempt3...

Quick suggestion, use the nodes method, check out this example

😎

DECLARE @TXML XML = '<?xml version="1.0"?>

<SEARCHREQUESTRESULT>

<DOCUMENTS>

<DOCUMENTDETAIL>

<DOCUMENTDATE />

<CONSIDERATIONAMOUNT>0</CONSIDERATIONAMOUNT>

<BOOK><![CDATA[]]></BOOK>

<PAGE><![CDATA[]]></PAGE>

<REFERENCENUMBER><![CDATA[]]></REFERENCENUMBER>

<NOTES><![CDATA[]]></NOTES>

<RETURNEDTO/>

<PARTIES>

<PARTY>

<ID>1090</ID>

...

Andrew Kernodle (9/19/2014)

---

My company would certainly benefit from upgrading to 2014 at this point; not so much because of new features (though in-memory could potentially be useful for one table...

Quick thought and as g.britton pointed out, the reference has to be exact, try this out for a size

😎

DECLARE @testXml XML;

select @testXml='<invoices>

<InvoiceNo>13537010*1</InvoiceNo>

<psship>value_psship1</psship>

<InvoiceNo>13537010*3</InvoiceNo>

<psship>value_psship2</psship>

<InvoiceNo>13537010*4</InvoiceNo>

<psship>value_psship3</psship>

<InvoiceNo>13537010*5</InvoiceNo>

<psship>value_psship4</psship>

<InvoiceNo>13537010*7</InvoiceNo>

<psship>value_psship5</psship>

</invoices>';

SELECT

INVOICE.DATA.value('.[1]','VARCHAR(50)')

FROM @testXml.nodes('/invoices')...

Quick first questions, what are the server specs, has the behaviour been trending, what is the maxdop, the threshold for parallelism, server version/edition?

😎

wolfkillj (9/19/2014)

---

okbangas (9/19/2014)

---

I have some doubt on the correctness of this question. As you get the coordinates from a GPS system and your task is to store the coordinates (calculation...

Breaks my heart seeing such an opportunity waisted!

😎

Stewart "Arturius" Campbell (9/19/2014)

---

TomThomson (9/19/2014)

---

Good question.

I was feeling too depressed by my nation's decision to stay under England's domination :crying: to do any research this morning, so I took a...