ByronOne (9/17/2012)

---

Clearly this is only a small sample of the data but at present I create a report in SSRS that references this table via a stored procedure. The report...

Well you can build dynamic sql so that is uses parameters to help prevent sql injection but given the nature of what you are doing I think you will find...

Yeap this is wide open to sql injection. Consider passing in "SomeRealTableName; drop table SomeRealTableName; --". You will be far better off creating a different update sproc for each table....

Probably easiest at this point to just uninstall and start over.

TecheeGirl (9/17/2012)

---

Has anyone come into a situation like this?

I have an application that is passing in 2 parameters, a string with column names and a string with values

I parse out...

Can you post the ddl for the tables involved, including all constraints and indexes? Take a look at the first link in my signature for best practices when posting questions.

Please see Gail's post about how to post performance problems here. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

I would make two recommendations about your query. First you should NEVER use select * in a production environment....

sqlrd22 (9/17/2012)

---

I am using SQL server 2008 R2 with no SSIS capabilities. I have set up a job in SQL Server Agent to run a query every morning at 9am....

Take a look at this. http://www.sqlservercentral.com/articles/T-SQL/71550/%5B/url%5D

rburko (9/17/2012)

---

This should be easy but I'm not getting this to work.

I have a number of rows that look something like this:

reckey ...

Yep my crystal ball is still out for repairs. We can't see your screen and our ability at mind reading is hindered greatly by reality. There is nothing like posting...

balajisrm (9/17/2012)

---

As you say that this data in the table is getting deleted only for the last couple of days,

Kindly check the recently deployed codes (Stored Procedures, Patches) for...

tim_harkin (9/17/2012)

---

Not sure if a delete trigger solves the problem, because TRUNCATE is non-logged. That is why it is so quick, but also why it requires elevated permissions.

Is...

Can you turn down the volume a little?

I...

ByronOne (9/17/2012)

---

Hi Sean

Thanks for getting back to me and I hope you'll be able to help.

Ok, here is the DDL you were looking for:

IF OBJECT_ID('TempDB..#MyTable') IS NOT NULL ...