Heh... nope... none of that... I don't even join it with a Tally Table to preserve the dates or anything... it just bubbled to the top on a simple text...

Thanks for the great feedback and the...

jcrawf02 (5/23/2008)

---

Yeah, I know, but I have limited access to the system, and can't access the system tables at all, or create indexes. Stuck with the while loop for...

In case you take Hugo's post to heart...

Yep... I agree... it ain't ANSI. Oracle (and several other RDBMS's) don't have this ability. Lot's of stuff in this world...

Sorry... didn't mean to get you excited. 🙂

"Flag" a post, in this case, meant that I save the URL for the post in my "Things to follow up on" list...

Good stuff, Gus! Looks like I have a couple of more things to play with. Glad you were bored this morning! 🙂

Heh... no problem... I didn't remember either... was reviewing old posts that I had flagged 'cause I knew I'd forget.

Thanks for the feedback!

In that case, I think I'd be tempted to use a passthrough view instead of a synonym.

Cool... if you get the chance, can you post your solution? I'm sure lot's of folks would like to see it.

RyanRandall (5/22/2008)

---

Another XML-style approach...

drop table #Results

; with a as (select RowNum, cast('<parm '+ replace(replace(Parameters,'=','="'),'&','" ')+ '"/>' as xml) as Xml from #SourceTable)

select RowNum,

Xml.value('(parm[1]/@Subject)[1]', 'varchar(255)') as Subject,

...

No problem... quick look says they all suffer from the same problems and all are in need of a major rewrite.

Heh... Kevin... I'm right there with you... I've recently been...

Looks like you got it... Thanks for the feedback and for posting your solution.

jcrawf02 (5/22/2008)

---

All right Jeff, I was having fun with your tally table example and trying to think set-based on how to clean up a column that included non-alpha characters. ...

Now THAT's an awesome compliment! Thanks!

It would really help if you did two things...

1. Post what the actual error is

2. Post the generated conten of the dynamic SQL code

You may even want to...