skeeter042 (4/12/2010)

---

Sorry, I'm not following you. :unsure: Can you give me another example after looking at all of my original code?

select rowid, accountnumber, tenantnumber, accountname, serviceaddress, billtoaddress1,

case

when...

How will you determine which lookup table the foreign key value is from, for each row of table c?

Dour.

But so slow! I've got a little library of rCTE's now for a...

Ninja's_RGR'us (4/9/2010)

---

-- Maxrows = 16: (65,535 row(s) affected) / 00:00:02

-- Maxrows = 20: (1,048,575 row(s) affected) / 00:00:46

-- Maxrows = 21: (2,097,151 row(s) affected) / 00:01:33

-- Maxrows = 22: (4,194,303...

RBarryYoung (4/11/2010)

---

??? Really? I thought that it was a giant 75-footed carnivorous...

Garadin (4/9/2010)

---

I am, but I know Jacob already has...

Ninja's_RGR'us (4/9/2010)

---

Chris Morris-439714 (4/9/2010)

---

Hi Ninja

It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper limit would...

Hi Ninja

It would be better to change the string list from comma-delimited to fixed position, three character positions per item - that way, the upper limit would be 999 rows....

vaibhav.tiwari (4/9/2010)

---

Thanks ColdCoffee for your that much efforts your query is working fine and giving me expected output

but i got the simpler solution from some another forum i want...

Deflate

jcrawf02 (4/9/2010)

---

I need some inspiration, what do you guys do when you start to lose focus and don't have the time to go get the crap kicked out of you...

This might help. I'd recommend rejigging it to return all address elements.

ALTER FUNCTION [dbo].[udf_AddressShuffle]

(

@AddressElementID INT = 1,

@Address1 varchar(80),

@Address2 varchar(80),

@Address3 varchar(80),

@Address4 varchar(80),

@Address5 varchar(80),

@Address6 varchar(80),

@Address7 varchar(80),

@Address8 varchar(80)

)

RETURNS VARCHAR(80)

AS

BEGIN

DECLARE @AddressElement VARCHAR(60)

;WITH Stringer AS...

Here's the simplest...

This is very basic, is it coursework?

If so, the following should get you started:

SELECT

s.ID,

s.M_ID,

s.T_Name,

s.T_Desc,

s.Sch_time,

createdon = i.ModifiedOn,

createdby = i.ModifiedBy,

LastModifiedOn = s.ModifiedOn,

LastModifiedBy =...