Sean Lange (5/29/2014)

---

My code does two very important things. First, it only updates the rows that need to be updated instead of updating them all. Secondly it references the alias...

Forgive me for being slow here and slightly off the topic, but how can a single session, multiple batch thingy create multiple instances of a temporary table with the same...

:-DThat is how we learn!:-D

😎

tshad (5/29/2014)

---

I have a situation where I want to update a column if and only if it is null.

UPDATE Employee

SET VEmployeeID = CASE WHEN E.VEmployeeID IS NULL

...

GilaMonster (5/29/2014)

---

It's because batches are parsed as a whole, then executed. When the parser hits the second create for that table it fails. It works with the debug break because...

Cannot say much without knowing more about the table structures, first guess would be this part of the join

😎

dbo.TCDaily.TCDay = dbo.EmpList.EmpID

wolfkillj (5/29/2014)

---

Eirikur Eiriksson (5/29/2014)

---

wolfkillj (5/29/2014)

---

Except that the requirement was...

wolfkillj (5/29/2014)

---

Except that the requirement was to determine which...

By the way, a workaround could look like this

😎

create procedure dbo.testTempTable

as

exec ('

select 1 as val into #tmp1

select * from #tmp1

drop table #tmp1')

exec ('

select ''2'' as val into #tmp1

select * from...

Michael Meierruth (5/29/2014)

---

Eirikur,

I recently re-ran into this old problem of not being able to drop/create the same temporary table more than once in a stored procedure.

At this discussion forum

http://stackoverflow.com/questions/9812302/can-i-recreate-a-temp-table-after-dropping-it

it states...

Quick question, are the procedure executions within the same session?

😎

Are you using SSMS to import into SQL Server 2000?;-) The fault would be when the IEW tries to enumerate objects in the SQL 2000 database instance, doesn't get what...

Versions do matter here, seen this when trying to do an imp/exp from 2008 in SSMS 2005.

Could you please provide the information asked for in the previous post!

😎

Quick question, is it an IEEE 754 single precision float, and is it signed or unsigned?

😎

Can you tell us a little bit more about what you where doing, at which step this happened, server versions, user permission and so on?:cool: