vikingDBA (10/11/2012)

---

I know some will cringe, but here are some UDF's that I have created for this type of manipulation. When you are in a time crunch, they really...

But what have you tried? I have to agree this looks a...

This has to be one of the strangest processes I have ever seen. You have a table to record the rowcount from every table. Why? It will always be out...

Can you post what you want for desired output? Just create a temp table and hard code inserts into it. I can't understand your explanation very well and the data...

That...

I am guessing that you didn't read through the article I suggested and understand this code. You can't reference the cte by multiple statements after it is declared. You need...

Cheryl McLaughlin-385812 (10/11/2012)

---

It works too a point, but it pulls all the records. If I substitute @Ord_Nbr ='12345' the script still pulls all the records and not the record that...

where order_nbr = isnull(@Ord_nbr, 'xxxx') maybe????

This is a running total problem. Jeff has a great article about it here. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

If you can't figure out how to put that all together post back here. In order...

Thanks for ddl and data. Makes this a lot easier.

Your data structures don't allow for anything like a join because there is nothing to tie a status to a phase....

a4apple (10/11/2012)

---

Sean Lange (10/11/2012)

---

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.....

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...