One thing looking at the snippets, it isn't always an issue but I have had problems with UPDATE statements like this:

update #MyTempTable set

somecol = somevalue --...

Still not sure what is going on, but it is possible indexes on the temp table would help. Without seeing the actual code, though, it is hard to say.

Oh,...

thomashohner (8/28/2014)

---

Hello all,

I inherited a Stored Procedure that has a temp table #results that is updated 65 times throughout the SP . This SP is used for a reporting only....

I really must be getting jaded. I get chastised for not being able to figure out what some ones uncommented and convoluted code on a blog does, and then...

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle Table.

Any ideas...

Jeff Moden (8/27/2014)

---

Eirikur Eiriksson (8/27/2014)

---

Then, that in itself is...

This is not an error. The * indicates that the value is too large for the currently defined size of the variable.

Eirikur Eiriksson (8/27/2014)

---

I guess that now it's your turn to make...

rxm119528 (8/27/2014)

---

with CTE(rn,steps)

As

(

select row_number() over ( order by steps),steps from #table1)

select t1.steps,t2.steps from CTE t1

left outer join CTE t2

on t1.rn...

Why did people post code? It would have been nice to see what the OP had tried first since this looks like homework even though the OP denies it.

keshabsingh (8/27/2014)

---

Run this script

create table #table1(steps int)

insert into #table1(steps)values(1)

insert into #table1(steps)values(3)

insert into #table1(steps)values(4)

insert into #table1(steps)values(5)

select steps from #table1

drop table #table1

You will get this

steps

1

3

4

5

I want this way.

stepFrom stepTo

1...

Anyone else feel uncomfortable answering this question?

stadmanwi (8/25/2014)

---

Not a best practice by any means.

Run a sql agent, set the task to powershell. I believe you need to be admin on box, etc... So not...

Evil Kraig F (8/25/2014)

---

Oh, he's been around a while. He stopped at one point. I'd hoped they'd shut his...

I agree, try being a professional and stop bashing people over the proverbial head. Instead, try being an actual mentor to...