Sioban Krzywicki (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

... Mark one...

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

... Mark one off, 78...

Just out of curiosity, in this case wouldn't a filter do the job, something like WHERE XX <> '' or WHERE LEN(XX) > 0 or even better, WHERE XX >...

Further on Sean's answer, here is the "hard way" (don't worry, the server does the work:-D) of doing a running total on SQL Server 2008 and earlier

😎

USE tempdb;

GO

IF OBJECT_ID(N'dbo.Test') IS...

Lynn Pettis (2/6/2015)

---

Eirikur Eiriksson (2/6/2015)

---

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

... Mark one off, 78 days to go on...

Lynn Pettis (12/12/2014)

---

Should have started this a while ago!

(To the tune 100 Bottles of Beer on the Wall)

... Mark one off, 78 days to go on the calendar. 78...

Good job, I'll look into this over the weekend

😎

Any indexes, constraints, triggers?

😎

😀

The logic is exactly the same, I just short-handed the CASE statement with a little math. Note that the math...

Quick solution using the APPLY operator

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @MappingTable TABLE

(

Productname nvarchar(10),

identification_key1 int,

identification_key2 int,

identification_key3 int

);

insert into @MappingTable(Productname,identification_key1,identification_key2,identification_key3)

VALUES ('Apple' , 1,2,1)

,('Orange', 1,2,3)

...

Further on Jeff's answer, could you post the DDL for the table and everything that comes with it (indexes, constraints, triggers etc.)?

😎

Jeff Moden (2/4/2015)

---

Sean Lange (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Sean Lange (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Eirikur Eiriksson (2/4/2015)

---

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Brandie Tarvin (2/4/2015)

---

Anyone know anything about this Grant guy? Does he...

ma701ss (2/4/2015)

---

I don't understand that. Why do you think it worked for you? If you don't mind, what happens if you import the XML with every field as varchar(50) and...

This should get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

<STOREITEMS>

<CREATED>

<CATEGORY id="127" name="Category 1">

<PRODUCT ITEM="4023">

<NAME>Patriot</NAME>

<MODEL>7505</MODEL>

<PRICE>10.46</PRICE>

<RRP>20.00</RRP>

<THUMB>07505ds.jpg</THUMB>

<IMAGE>07505.jpg</IMAGE>

<MULTI/>

<MULTI1/>

<MULTI2/>

<MULTI3/>

<BIGMULTI1/>

<BIGMULTI2/>

<BIGMULTI3/>

<DESCRIPTION>Description.</DESCRIPTION>

<XIMAGE>07505x.jpg</XIMAGE>

<XIMAGE2>07505x1.jpg</XIMAGE2>

<XIMAGE3>07505x2.jpg</XIMAGE3>

<XIMAGE4/>

<XIMAGE5/>

<LENGTH>9</LENGTH>

<DIAMETER>1.75</DIAMETER>

<ORINGCIRC/>

<ORINGDIAM/>

<WIDTH>5</WIDTH>

<CONTROLLER>Built In</CONTROLLER>

<WHATISIT/>

<FOR/>

<MOTION/>

<FEATURES>Multi speed</FEATURES>

<MISC/>

<STYLE/>

<POWER>2 x AA (Included)</POWER>

<SIZE>7</SIZE>

<ATTRIBUTES NAME="Batteries" ATTRIBUTEID="9">

<ATTRIBUTEVALUES VALUE="190" TITLE="None" PRICEADJUST="+0.00"/>

<ATTRIBUTEVALUES VALUE="182"...

Sioban Krzywicki (2/4/2015)

---

Grant Fritchey (2/4/2015)

---

Nah, I hear he's a giant bag of wind and...