Sergiy (10/8/2008)

---

karthikeyan (10/8/2008)

---

Actually we (mine and my manager) new to this project. My manager has looked some procedure few days back. He is not happy with the procedure case format....

Jeff Moden (10/8/2008)

---

I remember... it's a pretty tough task because it's not just quotes that Sergiy has to worry about with the data he showed me. It's data from...

The table is too small. No - really. There is something about the rebuild process that makes it essentially not work hardly at all on small tables,...

You could simply instruct the data flow task to ignore the error as well. You should see that option if you right click on the right data flow component.

When I'm trying to find differences across multiple columns.

As in something like

SELECT name, address,...

bhovious (10/8/2008)

---

Jack's right. Good eye!

For what it's worth, I always use the left join format too. It's simple to remember, fast to execute, and...

You're right - it's easier to describe with an example!:)

Thanks for the assist.

Great - glad it helped!

I wonder if they're serving up Porkchops at...

dr_csharp (10/7/2008)

---

thanks Jason you are right,but why we do this ?

i...

If you are looking to pull the top 2000 values, including any duplicates of those values, you might care to combine what Barry was demonstrating with the WITH TIES clause.

So...

Clint -

Jeff is pointing you to a high speed solution to your running totals problem. He's written a couple of articles on the topic. Follow the link...

If you want to improve performance - ditch the cursor altogether. The overhead this has to be generating (with redundant calls against the SAME table over and over again)...

bitbucket (10/7/2008)

---

You could create a stored procedure which your users could run.... the SP would use the openrowset function to import the data into the table you specify.... Read:

http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx

these will...

While I think Jeff's article explains it better - the running total/running count relies essentially on two pieces: 1. enforcing the order during an update, and 2. being able...