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 ...

rena24 (9/14/2012)

---

Ok, I am really thankful for your Help. My Company has created a ETL tool that we must use for import/Export Data. Sometimes I am allowed to use SSIS...

Sheesh!!! Some companies have the strangest rules/regulations about things. There is a tool that...

GilaMonster (9/14/2012)

---

SQLRNNR (9/14/2012)

---

GilaMonster (9/14/2012)

---

SQL Kiwi (9/14/2012)

---

GilaMonster (9/14/2012)

---

Thank you, you...

Are you reading this data in from a file? If so, then this is not a big deal at all. The biggest challenge is that if this data is already...