Praveen Goud Kotha (8/3/2010)

---

Eugene Elutin (8/2/2010)

I wonder, does original data comes in a such "pivoted" way? I would think that you might have the same data somewhere in a bit...

mike 57299 (8/2/2010)

---

I will try the cursor. The set based option works for when I want to do all customers but is significantly slower when I need to do...

mike 57299 (8/2/2010)

---

...

My issue seems to be in resource management. As shown below, each time stamp represents 1000 records. The first 10000 go very fast, then it drops...

jvanderberg (8/2/2010)

---

My guess is that the code posted above with be several degrees slower than the original code. CASE statements, while they can be a mess to read, are...

If you want to reduce using of "case when" statements I would suggest the following:

1. Create a function to calculate your Range count:

create function dbo.udf_CalcRange(@minR int, @maxR int

, @m01 int,...

Chris, it's look like OP data is not about person names, its URL names...

Chris Morris-439714 (7/29/2010)

---

Eugene Elutin (7/29/2010)

---

Can you test how long the following query will run and how many records does it returns:

SELECT a.*

FROM dbo.Person a

LEFT JOIN dbo.Person_exclusion b

ON a.Name LIKE...

Can you test how long the following query will run and how many records does it returns:

SELECT a.*

FROM dbo.Person a

LEFT JOIN dbo.Person_exclusion b

ON a.Name LIKE b.Name_similar

WHERE b.Name_similar IS NULL

You...

Based on your "new" requirements, I suggest you to read my previous post which can give you an idea of how to try to speed up your process...

To make it...

Santhosh Yamsani (7/29/2010)

---

...

I tried in following way :

update a set a.ExclusionID = b.ID

FROM dbo.Person a

join dbo.Person_exclusion b

on a.Name like b.Name_similar

But it...

What is a "huge" time.

Do you want to determine for how long query will run before executing it? - I doubt you can do it, as i depends on...

You should learn how to use table aliases and nicer formatting to make your query a bit more readable.

Try this:

SELECT PT.FirstName, PT.LastName, @PayPeriod AS PayPeriod

FROM...

If you don't like way posted in Post #958743 (which, as stated could benefit from using permanent tally table) and you don't have Excel to format SQL (as per Post#958732,#958745...

tasnim.siddiqi (7/26/2010)

---

Hi,

Just tested your code. It works fine now. But I dont understand, because the only difference is in the way you declared the table. Now you creating a table...

patil.mangesh.v (7/24/2010)

---

We are redeveloping our product from SQL Server 2000 to SQL server 2008(Can go for any RDBMS in future). We have design an application which designs query forms dynamically,...