Ah! Thank you Dave, things are clearer now!

You could store the file contents into a new staging table with char columns and try to parse the contents of each column to identify the order they were written...

Are indexes the same in both tables?

BTW, what do you mean with "source" table?

scott.pletcher (6/22/2010)

---

But if the parameters can match from one to, say, five thousand rows, and/or if each request usually uses several different parameters, you may be better off just using...

gorkchow (6/22/2010)

---

now on to my prob: whenever the date vars @msg_frdate and/or @msg_todate is used, it does not return any row but per normal select, date filtering should return some...

scott.pletcher (6/22/2010)

---

Also, I suggest you just put in the actual value rather than a variable for numeric and date columns. Yes, that means the query won't reuse a previous...

I'm sure you're aware that the same issues Gail and Grant pointed out apply to...

I can't say the information there is wrong, but I would say it's not relevant.

Comparing NULLS with the '=' sign will work depending on the ANSI_NULLS setting.

Comparing with IS NULL...

Looking at the exec plan there's an implicit conversion that sure doesn't help.

You could have posted DDL scripts (tables and indexes) and scripted out data as INSERT statements.

I don't have...

Not enough information here.

Try taking a look at this article and post all the information required to start tuning this query:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Both ETL and Reports should have some sort of API that allows you to list referenced tables.

I used them with DTS and Crystal Reports.

It's a bit tricky because you...

Relaying is a priviledged operation on a mail server. You have to make sure the IP address of the sql server is listed in the addresses...

Steve Jones - Editor (6/21/2010)

---

I haven't watched this time, but it seems the last World Cup I watched when the official clock ended, there was an "extra time clock" that...

Steve Jones - Editor (6/21/2010)

---

Lynn Pettis (6/21/2010)

---

Clock? We have a clock, it is on our wrist. In fact, take a close look at the center referee when you...

Totally agree. It this doesn't change the horrible match Italy played yesterday.

BTW, AR stands for Assistant Referee?