adrian.facio (5/21/2012)

---

Hi, what happens is that you need to add a select that uses the CTE. a CTE by itself can't run. Try this please

;WITH XmlDocuments

as

(

select *,XmlDoc = convert(xml,'<?xml version...

rabisco (5/21/2012)

---

adrian.facio (5/18/2012)

---

This one looks slightly better i could not make it show "semicolor ampersan lt " instead of <, but if you copie the code the text is good.

;WITH...

adrian.facio (5/18/2012)

---

This one looks slightly better i could not make it show "semicolor ampersan lt " instead of <, but if you copie the code the text is good.

;WITH XmlDocuments

AS

(

select...

adrian.facio (5/18/2012)

---

Ok you too have a good wekeend, by the way my name is Adrian, SSC-Enthusiasthic is a title of the forum. This is the last update, try this one...

Thanks SSC-Enthusiastic. I'll spend some of the weekend testing it in My Dev environment.

Have a good weekend.

The sql server version is Microsoft SQL Server 2005 - 9.00.4035.00 Service Pack 2

adrian.facio (5/18/2012)

---

Hi,

I made this using a split with jeff modden style . It migth be useful if you are restricted to not use CLR.

DECLARE @sql AS VARCHAR(MAX)

SET @sql = ''

;WITH...

jim.l (5/16/2012)

---

ok, so with your clarification on code lookup, i made some changes. below you'll find some code for the CLR project which should work. It's not the...

jim.l (5/16/2012)

---

So the lookup is based on the 1 existing code?

e.g. " SELECT code2_sku FROM Linktable WHERE code1_sku = '123456' "

Are there any duplicates (code1 or code2)...

Hi Jim.l,...

Sean Lange (5/15/2012)

---

CLR is a way of executing a stored proc whose code is actually .NET code. This type of string manipulation is tricky and probably a bit easier to...

Sean Lange (5/15/2012)

---

rabisco (5/15/2012)

---

Sean Lange (5/15/2012)

---

The more I think about this the more ugly it becomes. Can this be done in managed code instead in the database? t-sql is just...

Sean Lange (5/15/2012)

---

The more I think about this the more ugly it becomes. Can this be done in managed code instead in the database? t-sql is just not that efficient...

rabisco (5/9/2012)

---

rabisco (5/8/2012)

---

Sean Lange (5/8/2012)

---

rabisco (5/8/2012)

---

Sean Lange (5/8/2012)

---

Well it certainly demonstrated the problem. Is this a one time thing or...

rabisco (5/8/2012)

---

Sean Lange (5/8/2012)

---

rabisco (5/8/2012)

---

Sean Lange (5/8/2012)

---

Well it certainly demonstrated the problem. Is this a one time thing or something...