SQL Kiwi (10/5/2011)

---

GilaMonster (10/5/2011)

---

You get a difference because the query adds the milliseconds since the computer started to the time that SQL started. So if SQL Server started 27 seconds...

That's what I think as well. The only issue is length of transaction, but consistency overrides concurrency in my opinion.

Secondly, I...

HowardW (10/3/2011)

---

Jack Corbett (10/3/2011)

I agree about the error message. What is vexing to me is that I'm running a trace at the same time and not seeing a better...

RichardBo (10/3/2011)

---

I have an application that uses a common stored procedure to report application errors. The common stored proc uses xp_LogEvent to log the error to the SQL Server log...

It isn't clear to me if you want the solution for SSIS or T-SQL.

The pattern provided by Ninja would apply to both.

Based on how I understand your question you are getting the results you are asking for because you are using <= AND >=. Those are INCLUSIVE so if any...

This is more of a display issue and would be easier handled in a UI like reporting services that allows you to hide duplicates. T-SQL is really designed to...

I wouldn't do multiple schemas. My preference would be multiple databases which could include one database for the common data. Synonyms could make referencing the objects in the common...

Have you stepped through the code debugging it to see what's happening? It looks like it is coded correctly.

Thanks to all I have not already thanks for the congratulations.

I guess it just a "little" plagiarism to get the Thread rocking again.:-P

Thomas Abraham (10/3/2011)

---

sknox (10/3/2011)

---

The answer is correct but the explanation ("The reason is that the table variable causes a recompilation") is 100% wrong.

The reason the table variable code is so...

HowardW (10/3/2011)

---

Jack Corbett (10/3/2011)

---

HowardW (10/3/2011)

---

Is the ADO .NET destination a SQL Server DB? Do you get different results if you change it to an OLE DB destination? You can still...

SQL Kiwi (10/2/2011)

---

That's great news Jack. Do I remember you saying something about...

Jeff Moden (10/2/2011)

---

Jack Corbett (10/1/2011)

---

Hey guys I got some really cool news today. I was awarded MVP status!

I just hope I can honor that award the way that all...

HowardW (10/3/2011)

---

Is the ADO .NET destination a SQL Server DB? Do you get different results if you change it to an OLE DB destination? You can still redirect errored rows...