There's always the KISS method depending on what you need this for.

DECLARE @col2 varchar(MAX),

@sql varchar(MAX)

SELECT @sql = ''

select @Col2='|AuthoriaUsers|244375064|17875716|1.14||0000037249||0000037249||||DM4||||||||||||||||||||0000037249|||||||||||||||||||||||en_US|en_US|CAD|T1_US|'

SELECT @Col2 = STUFF(REPLACE(@Col2,'|',''','''),1,2,'')

SELECT @Col2 =...

GilaMonster (5/13/2011)

---

Garadin (5/13/2011)

---

Thanks for noting that Gail. I knew you needed to add a RECOMPILE but was incorrect in thinking that WITH RECOMPILE (which I've been using) worked the...

GilaMonster (5/12/2011)

---

Thanks for noting that Gail. I knew you needed to add a RECOMPILE but was incorrect in thinking that WITH RECOMPILE...

You've got a few options here.

When you execute dynamic SQL, it runs in a separate context from your SP, so the fact that you declared your variables at the top...

Care to elaborate on that at all?

Did your server just say "No."?

Yeah, my bad on that one, read this too fast and missed the way the exists referred to the derived table. They can be removed from the base level...

Alternatively, you can use XML and parse that into a temp table.

Should be as simple as removing the columns you don't want. Or am I missing something?

It might have seemed more difficult because all kinds of shortcuts are...

AFAIK, 2005 and 2008 behave the...

Replace

SUM(trxquantity) / SUM(trxcount) AS [UPT]

WITH

CASE WHEN SUM(trxcount) > 0 THEN SUM(trxquantity) / SUM(trxcount) ELSE 0 END AS [UPT]

I think your '-' got replaced with a double minus, probably office autoformatting. Try replacing it in your script.

How about something like:

SELECT Top 1 OrderNumber

FROM Orders

ORDER BY CASE WHEN UpdateDate IS NULL THEN CreateDate ELSE UpdateDate END DESC

or

SELECT Top 1 OrderNumber

FROM Orders

ORDER BY ISNULL(UpdateDate, CreateDate) DESC

deepakagarwalathome (4/1/2011)

---

P.S.

I don't have any Create table statement - the TempTest table is just coming from an existing table as a subset. The sample data set is here if...

Check out the link to "String Concatenation" in my signature. It details quite a few different methods of doing this.

You didn't...