Steve Jones - Editor (4/23/2008)

---

John,

Those sound like very interesting projects. Are they written up anywhere? You want to write an update for me sometime ;)?

The greenness of technologies is always...

Karthik -

You're trying to backdoor in some dynamic SQL without writing it up as dynamic SQL. It's not going to use the variable as a column name, it's...

Since we're talking energy - this caught my eye the other day....

http://wral.com/news/state/story/2746305/%5B/url%5D

As always - there seems to be some amount of controvery as to how "green" this process is, but...

Tim Curtin (4/22/2008)

---

Hmmm...

Access Issues:

- Multi-user/network corruption

- Huge Loss of indexing/performance

- Driver bottleneck.

- Jet engine vs sql engine

- scalability

Need I go on....

Convince your boss to byte the bullet and do the...

Jeremy (4/22/2008)

---

If I'm not mistaken, #temp table are implicitly dropped at the end of the stored procedure regardless of whether or not you explicitly drop it. ##temp tables (global ones)...

you'd have to use Dynamic SQL to do so.... It doesn't look like it like a variable in the Identity() call

martin scott (4/22/2008)

---

The problem is I need to referrer to a line within the same grouping.

The data is headcount data from the result of a pivot from which I get...

Jeff Moden (4/22/2008)

---

Never mind... I got it from one of the posts above... just to make sure, you're using this from one of Gus' posts?

create table NumberClean (

Number bigint,

Clean varchar(100))

go

set...

Which is what I would expect if you know the actual pattern (meaning get rid of exactly 2 lines,...

remove the INTO statement, and then put an INSERT clause in front of your select.

As in

INSERT #DLFiltered (

...

john.arnott (4/21/2008)

---

It's not so much code portability as developer portability. I prefer being able to...

I hear you Greg - I was actually more addressing the OP's where clause.

It just looked to me that he had put the values he wanted the columns SET to...

Well - SELECT DISTINCT tends to be a costly operation, so doing it over and over and over again is something to be avoided, IF it can be avoided. ...

Susan Shafer (4/21/2008)

---

Perhaps allowing the IT folks to manage their own computers would be fine......but actual user users?......not such a good idea. The first time Fred loses important data...

RyanRandall (4/21/2008)

---

Well, I'm confused with this thread. Why not just this?

select replace(@var, char(10) + char(13), '')

This works on my machine. The string you gave is '1yxyx2yx3yxyx4yx5' where y = char(13)...