Another version, similar to Ed's, this one uses CTEs to construct the ranges.

😎

USE tempdb;

GO

DECLARE @num AS TABLE (

Id INT IDENTITY(1, 1)

,Price MONEY

)

DECLARE @range AS TABLE (

Id INT IDENTITY(1, 1)

,Rng MONEY

)

INSERT...

g.britton (6/6/2014)

---

Eirikur Eiriksson (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore...

SQLTougherGuy (6/6/2014)

---

Hello,

I am about to embark on a massive migration from SQL 2005 - 2008 R2. We have 200+ SSIS packages that were deployed as a file system on the...

TomThomson (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore you could, in fact, divide...

Thank you for this filler Jeff, good read as always, and amazing thread! Only ran your initial code, any thoughts on how to eliminate the second scan?

😎

Koen Verbeeck (6/6/2014)

---

gbritton1 (6/6/2014)

---

Koen Verbeeck (6/6/2014)

---

TomThomson (6/6/2014)

---

Just a couple of examples: A British colleague who held an A-level in math and a bachelor's in business swore you could, in...

The Dixie Flatline (6/6/2014)

---

Eirikur Eiriksson (6/6/2014)

---

Agree on the costly part but exactly the same...

Agree on the costly part but exactly the same work then would be needed...

This is straight forward, the main pitfall is that the node value must either be typed (XSD) or referenced with text().

😎

USE tempdb;

GO

/* Create a table (variable) */

DECLARE @XMLUPDATE TABLE

(

...

dirk.dromgoole (5/20/2014)

---

I have a stored procedure that uses xp_cmdshell to execute an executable. I made code changes to the executable and compiled a new build. The stored procedure...

An even simpler solution is to grab the output into a table variable which then can be used to get the old-new values for the identity map table.

😎

DECLARE @INSVAL TABLE

...

This should get you started, notice I changed the data type of the monetary value, float is not the appropriate type!

😎

USE tempdb;

GO

create table #prova

( Valuta varchar(2),

Misura DECIMAL(18,5)

)

insert into #prova values...

Luis Cazares (6/5/2014)

---

I could alias them and join them. 😀

SELECT *

FROM NorthAmerica na

JOIN SouthAmerica sa ON na.PanamaSouthBorder = sa.ColombiaNorthBorder

JOIN Europe ...

scotteb (6/4/2014)

---

ok. I took a look at the T-SQL to attach and didn't see an option to specify the logical names, so I simply attached without the log file,...

ramana3327 (6/5/2014)

---

Hi,

I am still new to the SQL Server. So I want to know all your experiences.

If you want send a report that the SP is taking this time and...