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:

TheSQLGuru (5/28/2014)

---

Eirikur Eiriksson (5/28/2014)

---

Luis Cazares (5/28/2014)

---

Maybe you could use SQL Server Profiler with the correct filters and use the option "Discard results after execution" (Options->Query Results->SQL Server->Results to Grid).

Maybe someone...

Luis Cazares (5/28/2014)

---

Maybe you could use SQL Server Profiler with the correct filters and use the option "Discard results after execution" (Options->Query Results->SQL Server->Results to Grid).

Maybe someone else can give...

Good question, thanks!

😎

Quick thought, if the "signs" are points then I would have thought that the STContains function would be more appropriate.

😎

The CHAR()/NCHAR() functions can be used as a parameter for the REPLACE function

😎

SELECT REPLACE('STUFF TO |REPLACE',CHAR(124),'')

Use either the ASCII() or UNICODE() to find the character code

SELECT UNICODE(N'|')

SELECT ASCII('|')

This code lists...

Quick thought, as the table is in tempdb, change the statement to

DROP TABLE tempdb..#NewEmployees

😎

viresh29 (5/28/2014)

---

Hello Folks,

I am using Flat File Connection to process files into Database.

Files coming with text qualifier and delimited by comma.

But in some of the columns I am...

Are you looking for something like this?

😎

;WITH TEST AS

(

SELECT 'KM' AS Channel, '2012-06' AS TrailMonth UNION ALL

SELECT 'KM' AS Channel, '2012-06' AS...