Slightly puzzled how you got those procedure to work, are you certain that you posted the right code? Quickly looking at the first procedure:

1. Typo, flaot should be FLOAT, this...

shah_khan_1289 (7/23/2014)

---

Hello,

i have created a stored procedure with dynamic query and using sp_executesql . stored procedure is work fine.

now i want to call stored procedure in select statement...

ScottPletcher (7/23/2014)

---

If you're willing to push back against the myth that identity should be default clustering key, and base the clustering key(s) choice on data instead, you can change the...

You promise?

😎

pmscorca (7/23/2014)

---

Ok. I repeat the last time my question.

I haven't SQL Server 2012 media.

I need to prepare a SQL Server 2012 installation having SQL Server 2014 installation.

It is possible to...

N_Muller (7/23/2014)

---

Thanks everyone for the replies.

In regards to the XML storage as VARCHAR(MAX), we can receive XML that does not go through XSD validation and may not even be a...

pmscorca (7/23/2014)

---

I don't use the Retail channel to buy SQL Server.

I repeat that I know that SQL Server 2014 has rights to downgrade.

Simply, I want to know how technically I...

N_Muller (7/23/2014)

---

I have a table with with several XML columns stored as VARCHAR(MAX) because they some of the XMLs may not be valid XMLs. The table is quite large...

pmscorca (7/23/2014)

---

I explain better my question.

I need to install SQL Server 2012 on a new database server.

SQL Server 2012 isn't more sold and so I'm constrained to buy SQL Server...

Lynn Pettis (7/23/2014)

---

Eirikur Eiriksson (7/23/2014)

---

First suggestion would be to install the SQL...

Crystal ball in the repair shop, ESP network down, what can one do?😛

😎

Mark Harley (7/23/2014)

---

I think this is a matter of necessity. ...

Quick thought, you are using GEOMETRY ( Cartesian / planar ) for geographic operations, must be careful here!

😎

First suggestion would be to install the SQL 2012 alongside the SQL...

All things being equal between the two query executions, the difference would be pages loaded in cache. Hence a quick question, what happens if you flush the cache DBCC FREEPROCCACHE...