Please help me with the sql code.

All of them are Varchars (Status and Phase even though they look like Integers).

Please don't ask me to change my Datamodel.. Thanks everyone in...

sainatth.wagh (10/11/2012)

---

Hi,

Can somebody sent me syntax for the mdx query for with a drillthrough option, and to find data for the specific month.

Let me know if somebody would provide any...

A recursive cte can do what you want here. Something like this.

create table #Parts

(

Part varchar(10),

ExtPart varchar(10)

)

insert #Parts

select 'ABC', '123' union all

select 'DEF', '001' union all

select 'XYZ', '456' union all

select '123',...

Adding a scalar function to the where is not going to make anything faster, in fact it will most likely make it slower.

Do you have an index on this...

This looks strikingly similar to the one I posted...

Boris Pazin (10/11/2012)

---

No, I really appreciate because you spent your time to think about my problem. Thank you.

Sean Lange (10/11/2012)

---

Are you...

Boris Pazin (10/11/2012)

---

Sean Lange (10/11/2012)

In your case you are processing 200 rows and it takes 2 hours. That screams of a serious need of performance tuning. I bet you can...

Boris Pazin (10/11/2012)

---

Sean Lange (10/11/2012)

---

Boris Pazin (10/11/2012)

---

Sean Lange (10/11/2012)

---

If the job is taking 2 hours maybe you need to look at making the job run faster? That seems like a...

You should check out RedGate's SQL Search. It is a free plugin for SSMS and it is very solid tool for this type of thing. http://www.red-gate.com/products/sql-development/sql-search/%5B/url%5D

Boris Pazin (10/11/2012)

---

Sean Lange (10/11/2012)

---

If the job is taking 2 hours maybe you need to look at making the job run faster? That seems like a long time for a...

Because now we get increased index fragmentation, page splits and a slower process?

How is the performance from the select? It seems like you can't have that many rows. I am assuming the SegmentNo is a unique value? With a small int you...

If the job is taking 2 hours maybe you need to look at making the job run faster? That seems like a long time for a job to me.

Lokesh Vij (10/10/2012)

---

This query would give the best performance from all the queries posted above 🙂

SELECT dtStartDate,

(SELECT Max(dtRunDate)

...

You are quite welcome. Thanks for letting me know that worked for you.